About the role
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 Location: Toronto (Onsite)
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. · Analyze requirements/specifications and architectural/system design documents · Implement solutions using Azure Data Factory (ADF) pipelines and stored procedures, and Informatica Power Centre to populate the enterprise data warehouse · Develop Azure CI/CD pipeline to automate ADF release · Implement complex data conversion, e.g., binary to character, EBCDIC to UTF · Implement complex data transformation(s) 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 · Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects · Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow
Skills Required: · SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required. · Understanding of data modelling concepts. · Extensive experience with ETL tools Informatica Power Centre and Microsoft SSIS · Extensive experience with Azure Data Factory · High attention to detail · Passionate about complex data structures and problem-solving
If you are a skilled ETL Developer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.
Please apply via LinkedIn or send us your resume at hr@cloudvital.ca
Similar Jobs
About the role
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 Location: Toronto (Onsite)
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. · Analyze requirements/specifications and architectural/system design documents · Implement solutions using Azure Data Factory (ADF) pipelines and stored procedures, and Informatica Power Centre to populate the enterprise data warehouse · Develop Azure CI/CD pipeline to automate ADF release · Implement complex data conversion, e.g., binary to character, EBCDIC to UTF · Implement complex data transformation(s) 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 · Debug ADF pipeline and stored procedure and Informatica workflow to investigate and fix defects · Optimize performance of ADF pipeline, Azure SQL and Synapse databases, and Informatica workflow
Skills Required: · SQL competence (query performance tuning, index management, etc.) and a grasp of database structure are required. · Understanding of data modelling concepts. · Extensive experience with ETL tools Informatica Power Centre and Microsoft SSIS · Extensive experience with Azure Data Factory · High attention to detail · Passionate about complex data structures and problem-solving
If you are a skilled ETL Developer looking for an exciting opportunity to work with cutting-edge technologies in a collaborative environment, we would love to hear from you.
Please apply via LinkedIn or send us your resume at hr@cloudvital.ca