RQ09467 - Sr. Software Developer - ETL

St. Clair West, Toronto

Hybrid work: 3 days per week and 2 days remotely.

Contract (8 months)

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.

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 of experience with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
• 5+ years of experience with relational databases 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 modelling (OLTP, OLAP, dimensional modelling).
• Experience with REST/SOAP APIs, system integration, and cloud platforms (Azure, AWS, GCP).
• Experience with data replication, data cleansing, and data quality assurance.

• Strong understanding of Agile, SDLC, and DevOps practices.
• Experience with Azure DevOps and version control systems.
• Familiarity with OPS (Ontario Public Service) methodologies and enterprise architecture.
• Experience in public sector projects, especially in environmental or inter-jurisdictional data systems.
• Understanding of Information Management principles and data governance.