Job Description

DataStage Developer

Role: DataStage Developer
Duration: 12 Months
Work Model: Hybrid (3 Days per Week Onsite)
Key Responsibilities

ETL Development

• Design, develop, test, and maintain ETL workflows using IBM DataStage and Talend.
• Build reusable ETL components and integration frameworks.
• Optimize ETL processes for performance, scalability, and reliability.

Data Integration & Processing

• Develop ETL/ELT solutions for extracting, transforming, and loading data from multiple sources, including databases, APIs, flat files, and cloud platforms.
• Process structured and semi-structured data efficiently.
• Implement data validation, cleansing, and transformation rules.

Data Warehouse Support

• Support enterprise data warehousing initiatives.
• Work with Star Schema, Snowflake Schema, Fact Tables, and Dimension Tables.
• Ensure timely and accurate data delivery for reporting and analytics.

Performance Tuning & Troubleshooting

• Analyze and optimize ETL job performance.
• Handle large-volume data processing workloads.
• Troubleshoot and resolve ETL failures and production issues.

Collaboration

• Work closely with business analysts, data architects, and development teams.
• Translate business requirements into technical solutions.
• Participate in Agile/Scrum activities including sprint planning and reviews.

Documentation & Governance

• Create and maintain ETL documentation, workflow diagrams, and data mappings.
• Follow data governance, security, and compliance standards.
• Support version control and deployment processes.

Required Skills

Core Technical Skills

• Strong experience with IBM DataStage (Parallel Jobs, Server Jobs)
• Experience with Talend Open Studio / Talend Data Integration
• Strong SQL skills with databases such as Oracle, SQL Server, DB2, or PostgreSQL
• ETL design, development, and optimization experience
• Data modeling and data warehousing concepts

Additional Skills

• Unix/Linux Shell Scripting
• Performance tuning and troubleshooting of ETL jobs
• Experience working with large datasets

Preferred Skills

• Talend Open Studio
• Data Warehousing
• Star Schema and Snowflake Schema
• Data Quality and Data Governance practices
• Agile/Scrum methodology

Keywords

IBM DataStage, Parallel Jobs, Server Jobs, Talend, Talend Open Studio, ETL, ELT, Data Integration, SQL, Oracle, SQL Server, DB2, Data Warehousing, Star Schema, Snowflake Schema, Data Modeling, Unix, Linux, Shell Scripting, Performance Tuning, Data Governance.