Software Developer – ETL | Informatica Cloud (IDMC), PowerCenter v10.2, Oracle 11g/19c, PL/SQL, SQL Performance Tuning, Data Warehousing

Title Software Developer – ETL Description To support Government of Ontario priorities under Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to related projects. The contractor will work onsite 3 days per week (40 St. Clair West, Toronto) per OPS directive. Seeking a skilled ETL Developer to design, develop, and maintain robust data integration solutions. Expertise in Informatica PowerCenter v10.2, Informatica Intelligent Data Management Cloud (IDMC), PL/SQL, and data warehousing is required, with strong background in performance tuning, troubleshooting, and cloud migration. Key Responsibilities Design, develop, and maintain ETL processes using Informatica Cloud (IDMC). Migrate Informatica PowerCentre v10.2 ETL code with embedded SQL/PLSQL (Oracle 11g/19c). Test migrated SQL and PL/SQL stored procedures. Optimize SQL queries and PL/SQL code for scalability. Conduct root cause analysis and resolve ETL issues. Perform ETL from multiple sources into star/snowflake schemas. Translate technical specs into tested applications and pipelines. Collaborate with vendors/project team for testing/debugging. Document technical designs, deployment guides, and support materials. Participate in Agile/Scrum cycles. Ensure compliance with governance, security, and access policies. Provide post-implementation support and knowledge transfer. Perform database administration (configuration, backup/recovery, roles). Skills General Programming and analysis; structured methodologies for design, implementation, and maintenance. Application design, coding, debugging, documentation. Experience with relational/hierarchical databases, query languages, and protocols. Strong analytical, problem-solving, communication, and negotiation skills. Team player with proven ability to meet deadlines. ETL Requirement gathering and business process knowledge. Maintaining/improving existing ETL processes. Ensuring scalable, maintainable data architecture. Delivering high-quality data solutions. Investigating pipeline issues and proposing solutions. Preparing detailed documentation. Desirable Internet-ready applications, RAD, Agile methodologies. Middleware/gateways experience. Reviewing/modifying installation scripts. Post-implementation support and issue resolution. Conducting design walkthroughs. Knowledge of AODA standards. Experience and Skill Set Technical Skills – 40% 5+ years in data warehousing design/development (star/snowflake schemas). Advanced SQL (PL/SQL, TSQL), scripting (Python, Unix shell). Cloud technologies (Azure, AWS, Google). Azure SQL Server, Azure Data Factory pipelines. Elasticsearch optimization. GitHub version control, JIRA, Azure DevOps. Oracle tools (OEM, RAC, Data Guard, Exadata, OWB). Data migration/integration across platforms. RMAN backup/recovery. Core Skills – 30% Technical analysis, program design, unit testing. Multi-platform software, middleware, gateways. System design models, documentation, specifications. BI/data analytics, dimensional modeling. Translating business requirements into technical solutions. QA collaboration, debugging, performance tuning. Leadership in identifying improvements. SDLC methodologies (Agile/Scrum, Waterfall). Public Sector – 5% Experience with inter-jurisdictional projects. Knowledge of environmental services and legislative frameworks. OPS Enterprise Architecture artifacts and methodologies. General Skills – 25% Strong analytical, troubleshooting, and consulting skills. Excellent communication and customer service. Flexible, detail-oriented, organized team player. Must Have: ETL development with Informatica Cloud (IDMC). Migration of PowerCentre v10.2 ETL code (Oracle 11g/19c). Testing SQL/PLSQL stored procedures. Performance tuning of SQL/PLSQL. Root cause analysis and issue resolution. ETL into star/snowflake schemas. Translating specs into tested pipelines.

Design, develop, and maintain robust ETL processes using Informatica Cloud (IDMC) and migrate legacy PowerCenter code. Optimize SQL queries and PL/SQL stored procedures to ensure scalable data integration into star and snowflake schemas.

Requires over 5 years of experience in data warehousing and advanced proficiency in SQL, PL/SQL, and Informatica tools. Candidates must have a strong background in cloud technologies and the ability to perform root cause analysis for ETL pipelines.

• GitHubPreferred
• JiraPreferred
• PythonPreferred

Identified from the job description. Confirm important requirements above.

• Informatica Cloud (IDMC)
• Informatica PowerCenter v10.2
• Oracle 11g/19c
• PL/SQL
• SQL Performance Tuning
• Data Warehousing
• Star/Snowflake Schemas
• Cloud Migration
• Python
• Unix Shell
• Azure Data Factory
• GitHub
• JIRA
• Azure DevOps
• Agile/Scrum
• RMAN

• Data & Analytics
• Software
• Technology
• Government & Public Sector
• Consulting

Minimum experience

5+ years

Apply by

Sep 26, 2026

Posting language

English

Working hours

40 hours per week

Office presence

3 days per week

Seniority

Mid-Senior level

Application method

Direct apply is available