Description

You will lead the migration of DataStage jobs to SSIS while managing data integration across Oracle, SQL Server, and MySQL.

This role is on-site.

Responsibilities

• Convert existing DataStage jobs into SSIS packages using stored procedures, functions, and views.
• Integrate relational databases with various systems and applications using SQL and PL/SQL.
• Perform data aggregation, analysis, and troubleshooting to optimize ETL performance.
• Execute code changes following an Agile-like software development life cycle.
• Conduct unit testing and maintain technical documentation for all developed processes.

Required Skills

• 5+ years of experience in software development.
• Expertise in SSIS and ETL processes.
• Proficiency in SQL and relational databases including Oracle, SQL Server, and MySQL.
• Strong experience with PL/SQL.
• Experience with IBM DataStage.
• Working knowledge of PowerShell or similar scripting languages.
• Experience with data integration and data mapping.
• Ability to work within an Agile development framework.

Preferred Skills

• Experience with data aggregation and complex problem-solving in a production environment.

Key Skills

Education

Any Gradute