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.
Skills Required
- Extensive experience gathering requirements and business process knowledge to design high-quality data transformations
- Design, development, and implementation experience with Azure Data Factory including Self-Hosted Integration Runtime, data movement, ETL pipelines, performance tuning, complex transformations, and ADF Debugger
- Experience with Databricks for data processing and transformations
- Experience with Informatica components: Workflow Manager, Repository Manager, Designer, Workflow Monitor
- Experience developing solutions using Azure Logic Apps and Azure Functions
- Experience in rapid application development (RAD) methodologies
- Experience maintaining and improving existing ETL processes and investigating data issues within ETL pipelines
- Experience with BI tools IBM Cognos and Microsoft Power BI
- Experience with CI/CD concepts and DevOps pipelines including Azure Resource Manager, GitHub, source control, branching, pull requests, build and release processes
- Experience with Azure DevOps (Azure Boards, Azure Test Plans, Azure Pipelines, Azure Repos, Azure Artifacts)
- Extensive experience designing and developing SQL Server stored procedures and Oracle PL/SQL programs
- Experience with Oracle and Microsoft SQL Server databases and tools
- Experience with relational and hierarchical database technologies
- Extensive knowledge of Azure SQL Database and Azure Synapse platforms including performance tuning on large data volumes
What We Do
ITProFound Inc. is a global technology services and solutions provider specializing in software development, IT consulting, and staff augmentation. They deliver end-to-end business practice solutions, including ERP, cloud migrations, and data analytics, across various industries.
