Description

You will design, implement, and optimize ETL/ELT processes and data pipelines within Azure and Informatica environments.

Responsibilities

• Design logical and physical data models and produce transformation mapping documents.
• Implement data solutions using Azure Data Factory pipelines, stored procedures, and Informatica PowerCenter.
• Develop complex Oracle PL/SQL programs and manage data conversions such as EBCDIC to UTF.
• Build and manage Azure CI/CD pipelines to automate ADF releases across multiple environments.
• Optimize performance for ADF pipelines, Azure SQL, Synapse databases, and Informatica workflows.

Required Skills

• 5+ years of experience in ETL and BI development.
• Extensive experience with Azure Data Factory, including Self-Hosted Integration Runtime and complex data transformations.
• Proficiency with Informatica PowerCenter (Workflow Manager, Repository Manager, Designer, and Monitor).
• Strong Oracle PL/SQL development skills for complex program design.
• Hands-on experience with Microsoft SSIS and Azure Synapse.
• Experience with Azure DevOps, including Azure Boards, Pipelines, Repos, and Test Plans.
• Knowledge of CI/CD concepts including GitHub, branching, pull requests, and source control.
• Competency with Oracle and Microsoft SQL Server databases.

Preferred Skills

• Expertise in BI tools such as IBM Cognos and Microsoft PowerBI.

Key Skills

Education

Any Graduate