Description

Develop and maintain ETL pipelines for data integration.

Responsibilities

• Develop and maintain ETL pipelines using IBM DataStage to integrate data into Netezza databases.
• Write optimized SQL scripts for data extraction, transformation, and loading.
• Develop stored procedures, functions, and performance-tuned queries for efficient processing.
• Ensure data quality, integrity, and consistency through validation and error handling.
• Monitor and troubleshoot ETL jobs and database performance issues.

Required Skills

• 6+ years of experience in ETL development using IBM DataStage.
• Strong expertise in SQL Scripting and Query Optimization in Netezza.
• Hands-on experience with Performance Tuning of SQL queries, indexing, and stored procedures.
• Proficiency in Unix/Linux Scripting for ETL automation.
• Experience in data warehousing concepts, data modeling, and ETL best practices.
• Strong problem-solving skills to troubleshoot ETL failures and performance issues.
• Familiarity with job scheduling tools and data orchestration frameworks.

Key Skills

Education

Any Graduate