Senior ETL Developer

Apex Systems; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Senior ETL Developer to spearhead the migration of legacy ETL processes to modern cloud-based systems. This role involves leading complex projects, ensuring high-quality code migration, and collaborating with stakeholders to optimize data handling. As part of a dynamic team, you will leverage your expertise in Informatica and Databricks while utilizing AI tools for enhanced efficiency. If you are passionate about data integration and transformation and thrive in a collaborative environment, this opportunity is perfect for you.

Qualifications

• 5+ years of ETL experience with Informatica and Databricks.
• Proven experience in leading complex migration projects.

Responsibilities

• Lead end-to-end conversion of Informatica code to Databricks.
• Ensure high-quality code migration aligned with business needs.

Skills

ETL Processes

Informatica

Databricks

Data Integration

Problem-Solving

Project Management

Education

Bachelor's Degree in Computer Science

Tools

EDH Tool

Azure

AI Tools

Job description

Direct message the job poster from Apex Systems

Senior Professional Technical Recruiter at Apex Systems

Senior ETL Developer

Apex Systems is a global IT services provider with an opening for a Senior ETL Developer to be placed at our client, a Top Five Bank.

Location: Hybrid, 1 day in office - Downtown

Terms: 6 Months with the possibility to extend

Application Process: Please send your resume in Word format to Peter at [e-mail], referencing Senior ETL Developer

Key Responsibilities:

• Lead the end-to-end (E2E) conversion of Informatica code to Databricks.
• Utilize the EDH tool for data handling and management during migration.
• Ensure smooth, high-quality code migration aligned with organizational standards and business needs.
• Train and optimize AI tools for code conversion to maximize effectiveness.
• Conduct code reviews to ensure performance, scalability, and functionality standards are met.
• Own the quality assurance process, troubleshooting issues during migration.
• Provide technical leadership, ensuring best practices throughout the project.
• Collaborate with stakeholders to address data issues and ensure compliance with data governance policies.

Requirements:

• 5+ years of hands-on experience in ETL processes, with expertise in Informatica, Databricks, and EDH.
• Proven experience leading complex migration projects from legacy ETL to cloud-based systems.
• Strong skills in data integration, transformation, and optimization.
• Familiarity with AI tools for code conversion and enhancement.
• Excellent problem-solving skills, focusing on code quality and performance.
• Understanding of data governance and compliance.
• Effective communication skills for cross-team collaboration.
• Project management skills to meet timelines and deliverables.

Preferred Qualifications:

• Certifications in Informatica, Databricks, or related cloud tech.
• Experience training AI tools for code conversion.
• Hands-on experience with Azure cloud platform.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Consulting, Information Technology, and Finance

Industries

• IT Services and Consulting, Data Infrastructure and Analytics, Software Development