Datastage Developer

Job Summary

We are seeking experienced ETL developers with expertise in IBM DataStage and Netezza SQL scripting. The role involves developing and maintaining ETL pipelines, writing optimized SQL scripts, and ensuring data quality and integrity. The position contributes to the organization's goals by optimizing data workflows and supporting data-driven decision-making.

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.
• Work closely with data architects, business analysts, and stakeholders to understand requirements.
• Optimize ETL workflows and SQL queries for performance improvements.
• Implement data governance and security measures per organizational policies.
• Document ETL processes, data flows, and technical specifications for reference.

Qualifications

• Minimum 3 years of experience in ETL development using IBM DataStage.
• Strong expertise in SQL scripting, query optimization, and performance tuning in Netezza.
• Experience with data warehousing concepts, data modeling, and ETL best practices.
• Hands-on experience with performance tuning of SQL queries, indexing, and stored procedures.
• Proficiency in Unix/Linux scripting for ETL automation.
• Familiarity with job scheduling tools and data orchestration frameworks.
• Strong problem-solving skills to troubleshoot ETL failures and performance issues.
• Excellent communication skills for collaboration with cross-functional teams.

Preferred Skills

• Knowledge of additional ETL tools and technologies.
• Experience with cloud data platforms and big data technologies.
• Understanding of data governance and compliance standards.

Experience

4 to 8 years of relevant experience in ETL development, with a focus on IBM DataStage and Netezza SQL scripting.

Environment

• Location: Bangalore
• Work Mode: Full-Time Employment (FTE)
• Mode of Interview: MS Teams
• Notice Period: Immediate

Openings

• Number of Positions: 4