Overview
We are currently seeking an ETL developer to design, develop, and maintain ETL processes for data integration and transformation.
Job Role : ETL Developer
Job Type : Full-Time / Contract
This is an onsite role located in Toronto, requiring you to work in the office 4 to 5 days a week.
Responsibilities
- Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.
- Implement solutions using Azure Data Factory (ADF) pipelines and stored procedures, and Informatica PowerCenter to populate enterprise data warehouse.
- Develop Azure CI / CD pipelines to automate ADF releases.
- Implement complex data conversions, e.g., binary to character, EBCDIC to UTF.
- Implement complex data transformations for derived and calculated values.
- Integrate data sets from diverse source systems.
- Implement ADF for initial data load and incremental load.
- Promote ADF and Informatica ETL / ELT including Development, Integration Testing, QA, UAT, Production phases.
- Debug ADF pipelines, stored procedures, and Informatica workflows to investigate and fix defects.
- Optimize performance of ADF pipelines, Azure SQL and Synapse databases, and Informatica workflows.
Qualifications / Skills
SQL competence (query performance tuning, index management, etc.) and a grasp of database structure.Understanding of data modelling concepts.Extensive experience with ETL tools Informatica PowerCentre and Microsoft SSIS.Extensive experience with Azure Data Factory.High attention to detail.Passionate about complex data structures and problem solving.How to apply
Please apply via LinkedIn or send your resumes to hr@cloudvital.ca
#J-18808-Ljbffr