Senior ETL Developer

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 [email protected]

Design, develop, and maintain ETL processes for data integration and transformation using Azure Data Factory and Informatica. Implement complex data conversions, automate releases via CI/CD pipelines, and optimize performance for Azure SQL and Synapse databases.

Candidates must have extensive experience with Informatica Power Centre, Microsoft SSIS, and Azure Data Factory. Strong SQL competence, understanding of data modelling, and experience with complex data structures are required.

Identified from the job description. Confirm important requirements above.

• SQL
• Data Modelling
• Informatica Power Centre
• Microsoft SSIS
• Azure Data Factory
• Azure CI/CD
• Azure SQL
• Azure Synapse
• ETL/ELT
• Data Integration
• Data Transformation
• Stored Procedures
• Performance Tuning
• Index Management
• Data Conversion
• Unit Testing

• Data & Analytics
• Software
• Technology

Minimum experience

5+ years

Apply by

Aug 20, 2026

Posting language

English

Working hours

40 hours per week

Seniority

Mid-Senior level

Application method

Direct apply is available