Senior Software Developer ETL

About the role

Requirements: What you'll need

Skills, Knowledge, Experience, and Qualifications:

ETL Development-Data Integration

Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.

Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:

Self-Hosted Integration Runtime

Data movement, ETL pipelines

Performance tuning on large data volumes

Complex data transformations

ADF Debugger to validate data transformation.

Azure Roles

Experience with Informatica, including:

Workflow Manager

Repository Manager

Designer

Workflow Monitor

Experience with developing solutions using Logic App and Function App.

Experience in rapid application development (RAD) methodologies.

Experience in maintaining and improving existing ETL processes.

Experience in investigating data to identify potential issues within ETL pipelines.

Experience with Business Intelligence tools IBM Cognos and Microsoft PowerBI.

Azure Technologies

Experience with CI/CD (DevOps) pipelines and concepts, including:

Azure Resource Management

GitHub Repo

Source code version control

Branching, pull requests, build, release, multiple parallel development repositories merge.

Experience with Azure DevOps, including:

Azure Boards

Azure Test Plans

Azure Pipelines

Azure Repos

Azure Artefacts

Oracle PL/SQL Development

Extensive experience in designing and developing SQL Server Stored Procedure, Oracle PL/SQL programs.

Database Technologies

Experience with Oracle, Microsoft SQL Server database and tools.

Experience with relational and hierarchical database technologies.

Extensive knowledge of Azure SQL DB and Synapse platforms, including:

Performance tuning on large data volume

Must haves:

Extensive experience in gathering requirements and business process knowledge in order to design correct and high-quality data transformation.