ETL Software Developer

Cynet Systems Inc; Toronto; On-site; CAD 90,000 - 120,000; Full time

Job summary

A leading technology solutions provider based in Toronto is looking for a seasoned BI/ETL Developer to lead the design and maintenance of ETL processes. This role requires over 10 years of experience in SQL and PL/SQL, along with hands-on skills in Informatica PowerCenter and Cloud. The ideal candidate will excel in optimizing data pipelines and ensuring adherence to data governance policies. Excellent problem-solving and communication skills are essential for success in this role.

Qualifications

• 10+ years of experience as a BI/ETL Developer.
• Expertise in SQL, T-SQL, PL/SQL, and advanced SQL query optimization.
• Hands-on experience with Informatica Cloud (IDMC) including migrations.

Responsibilities

• Contribute to designing and maintaining ETL processes.
• Migrate ETL code from Informatica PowerCentre.
• Performance-tune SQL queries and PL/SQL code.

Skills

SQL performance tuning

PL/SQL development

Data modeling

ETL process management

Agile methodologies

Data governance principles

REST/SOAP APIs

Tools

Informatica PowerCenter v10.2

Oracle 11g

Oracle 19c

Azure DevOps

Job description

Job Description:

• Contribute to and support the 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 vendors and project teams 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, and database synchronization.

Requirement/Must Have:

• 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 of experience with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
• 5+ years of experience with relational databases 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 migration from PowerCentre, asset management, and configuration of secure agents, schedules, organizations, sub-organizations, connections, users, and roles.
• Hands-on Oracle 11g and 19c experience including configuration, user role 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.

Skills:

• Strong understanding of Agile, SDLC, and DevOps practices.
• Experience with Azure DevOps and version control systems.
• Familiarity with enterprise methodologies and architecture.
• Experience in public sector projects, especially in environmental or inter-jurisdictional data systems.
• Understanding of information management principles and data governance.