Description

You will design, develop, and optimize large-scale ETL and data-pipeline solutions across Azure, SQL Server, and Oracle platforms within a complex enterprise environment.

Responsibilities

• Design logical and physical data models using Sybase PowerDesigner and create detailed system design documents.
• Build complex ETL/ELT pipelines using Azure Data Factory, Informatica PowerCenter, and stored procedures.
• Implement automated CI/CD pipelines for ADF using Azure DevOps, Logic Apps, and Function Apps.
• Develop and optimize complex PL/SQL and SQL Server stored procedures for data transformation.
• Review project artefacts, including Use Cases and SRS, to ensure alignment with technical requirements.

Required Skills

• 7+ years of experience designing and implementing complex ETL transformations and data pipelines.
• Extensive hands-on experience with Azure Data Factory, Databricks, and Informatica PowerCenter.
• Strong proficiency in SQL Server stored procedures and Oracle PL/SQL programming.
• Experience with Azure SQL, Synapse, and Oracle databases.
• Hands-on experience setting up Azure DevOps CI/CD pipelines, including build, release, and Git branching.
• Ability to create detailed system design and transformation mapping documentation.
• Strong knowledge of data integration best practices in highly complex enterprise environments.

Preferred Skills

• Experience enhancing existing ETL ecosystems and improving legacy pipelines.
• Exposure to advanced Azure services and cloud security best practices.

Key Skills

Education

Any Graduate