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, Canada

This is a Hybrid role with 3 days onsite and 2 days remote!

Responsibilities:

· Collaborate with cross-functional teams to gather and analyze requirements for data integration projects.

· Analyze requirements/specifications, architectural/system design documents

· Implement solution using Azure Data Factory (ADF) pipeline and stored procedure, and Informatica Power Centre to populate 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.