ETL Development-Data Integration
· Extensive experience in design, development, and implementation with Azure Data Factory, Databricks, including:
o Self-Hosted Integration Runtime
o Data movement, ETL pipelines
o Performance tuning on large data volumes
o Complex data transformations
o ADF Debugger to validate data transformation.
o Azure Roles
· Experience with Informatica, including:
o Workflow Manager
o Repository Manager
o Designer
o 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:
o Azure Resource Management
o GitHub Repo
o Source code version control
o Branching, pull requests, build, release, multiple parallel development repositories merge.
· Experience with Azure DevOps, including:
o Azure Boards
o Azure Test Plans
o Azure Pipelines
o Azure Repos
o 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:
o 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.
