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 solid 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.

📌 Software Developer – ETL | Informatica Cloud (IDMC), PowerCenter v10.2, Oracle 11g/19c, PL/SQL, SQL Performance Tuning, Data Warehousing (Toronto)
🏢 CCI- Computer Consultants International
📍 Toronto