Senior ETL Software Developer

TEEMA; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A data integration solutions provider in Canada is seeking a Senior ETL Software Developer to design, develop, and maintain data integration solutions. The ideal candidate will have extensive experience with Informatica PowerCenter, SQL, and data warehousing. Responsibilities include developing ETL processes, performing code migrations, and optimizing performance. This hybrid role offers a dynamic work environment.

Qualifications

• 10+ years of experience as a BI/ETL Developer.
• Experience with Oracle databases including Oracle 11g and 19c.
• Hands-on experience with Informatica Cloud (IDMC) configurations.

Responsibilities

• Design and develop ETL processes using Informatica Cloud.
• Migrate Informatica PowerCentre ETL code from older versions.
• Conduct performance tuning and optimize PL/SQL code.

Skills

SQL

PL/SQL

Informatica PowerCenter v10.2

Data warehousing

Data modeling

Problem-solving

Cloud platforms (Azure, AWS, GCP)

Data quality assurance

Tools

Oracle 11g

Informatica Cloud (IDMC)

REST/SOAP APIs

Job description

Job Title:Senior ETL Software Developer
Job ID:82165
Location:Toronto, Ontario – Hybrid

Overview:
A highly skilled and experienced ETL Developer to design, develop, and maintain robust data integration solutions. The ideal candidate will have deep expertise in Informatica PowerCenter v10.2 and Informatica Intelligent Data Management Cloud (IDMC), PL/SQL, and data warehousing, with a strong background in performance tuning, troubleshooting, and cloud migration. This role involves working closely with business analysts, developers, and stakeholders to ensure high-quality data delivery and system integration.

What you will be doing:

• Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (IDMC).

• Migrate Informatica PowerCentre v10.2 ETL code including embedded SQL and PL/SQL code developed using Oracle 11g and 19c

• Test migrated embedded SQL code and PL/SQL based Stored Procedures.

• Performance-tune and optimize SQL queries and PL/SQL code for performance and scalability.

• Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery to achieve optimum baseline-based performance

• Perform data extraction, transformation, and loading (ETL) from various sources into data warehouses (star/snowflake schemas).

• Translate technical specifications into fully tested applications and data pipelines.

• Collaborate with vendor and entire project team for unit testing, debugging, and validation of ETL processes.

• Document technical designs, deployment guides, and support materials.

• Participate in Agile/Scrum development cycles and iterative delivery.

• Ensure compliance with data governance, security, and access control policies.

• Provide post-implementation support and participate in knowledge transfer sessions.

• Provide database administration including configuration, backup/recovery, user roles, database synchronization, etc.

What you must have:

• Must haves 10+ years of experience as a BI/ETL Developer.

• 10 + years of experience developing and performance tuning SQL, T-SQL, PL/SQL and advanced SQL query optimization

• 10+ years experience with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.

• 5+ years Experience with relational database including Oracle including Oracle 11g and 19c

• 3+ years of hands-on experience with Informatica PowerCenter v10.2 administration

• 2+ years of experience with Informatica Cloud (IDMC) including PC to IDMC migration; asset management; and configuration of secure agents, schedules, orgs and sub-Orgs, connections, users and roles

• Hands-on Oracle 11g and 19c experience configuring, user roles setup, RMAN, data dumps, and Golden Gate synchronization

• Proficiency in data modeling (OLTP, OLAP, dimensional modeling).

• Experience with REST/SOAP APIs, system integration, and cloud platforms (Azure, AWS, GCP)

• Experience with data replication, data cleansing, and data quality assurance

• Excellent analytical, problem-solving, and communication skills.

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.

For more information about TEEMA and to consider other career opportunities, please visit our website atwww.teemagroup.com