Description

You will design, implement, and optimize ETL/ELT processes and data pipelines within Azure and Informatica environments. You will own the release pipeline, build complex data models, and resolve technical incidents to ensure data integrity and performance.

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