Client: Ministry of Public and Business Service Delivery and Procurement

Work Location: 40 St. Clair Ave. W., Toronto, Ontario – Hybrid Estimated Start Date: February 12, 2027

Estimated End Date: March 31, 2027

Business Days: 29

Extension: Probable after the initial mandate

Hours: 7.25 hours per day

Security Level: No Clearance Required

Application Deadline: Monday, August 31, 2026 at 10:00 AM EST

Role Overview

We are seeking a Senior ETL Software Developer with strong experience in Informatica PowerCenter, Informatica Intelligent Data Management Cloud (IDMC), Oracle, PL/SQL, data warehousing, Azure Data Factory, and cloud data integration .

The successful candidate will be responsible for designing, developing, migrating, testing, optimizing, and supporting enterprise-scale ETL and data integration solutions. The role will focus heavily on migrating Informatica PowerCenter v10.2 ETL code to Informatica Cloud (IDMC) , including embedded SQL and PL/SQL developed against Oracle 11g and 19c environments.

The candidate should have strong experience with data warehousing, ETL/ELT, SQL optimization, performance tuning, troubleshooting, cloud technologies, Agile/Scrum, and large-scale data migration initiatives .

Note: The contractor will work in the office 3 days per week at 40 St. Clair West, Toronto , in accordance with OPS directives and LRC management guidelines.

Must-Have Skills

- 5+ years of experience in data warehousing and ETL development.
- Strong hands-on experience with Informatica PowerCenter v10.2 and Informatica Cloud (IDMC).
- Experience migrating Informatica PowerCenter ETL code, including embedded SQL and PL/SQL.
- Strong experience with Oracle 11g and Oracle 19c.
- Advanced PL/SQL and SQL development and optimization skills.
- Experience designing, developing, and optimizing ETL/ELT processes.
- Experience with data warehouses using Star and Snowflake schemas.
- Strong experience with Azure Data Factory and Azure SQL Server.
- Experience with cloud technologies including Azure, AWS, and/or Google Cloud.
- Experience with data migration and integration across multiple platforms.
- Experience troubleshooting ETL issues and performing root cause analysis.
- Experience with performance tuning, recovery, failover, and optimization.
- Experience working with Agile/Scrum and Waterfall methodologies.

Key Responsibilities
- ETL Development & Data Integration
- Design, develop, maintain, and optimize ETL processes using Informatica Cloud (IDMC).
- Develop and support enterprise data integration solutions.
- Perform data extraction, transformation, and loading from multiple source systems into enterprise data warehouses.
- Develop ETL processes supporting Star and Snowflake schemas.
- Translate technical specifications into fully tested applications and data pipelines.
- Maintain and improve existing ETL processes and data integration solutions.
- Ensure data architecture is scalable, maintainable, and aligned with business requirements.
- Informatica PowerCenter to IDMC Migration
- Migrate Informatica PowerCenter v10.2 ETL code to Informatica Cloud/IDMC.
- Migrate embedded SQL and PL/SQL code developed using Oracle 11g and 19c.
- Analyze existing ETL processes and identify migration requirements.
- Test migrated SQL and PL/SQL code.
- Validate PL/SQL stored procedures following migration.
- Collaborate with project teams and vendors throughout migration, testing, debugging, and validation.
- Support post-migration troubleshooting and optimization.
- SQL & PL/SQL Development
- Develop complex PL/SQL procedures, packages, views, and scripts.
- Perform data extraction, transformation, cleansing, denormalization, and loading.
- Develop data assets from highly normalized Oracle databases.
- Load transformed data into different DBMS platforms, including Microsoft SQL Server and PostgreSQL.
- Optimize complex SQL queries and PL/SQL code for performance and scalability.
- Perform query optimization, troubleshooting, performance tuning, failover, and recovery.
- Develop database change-tracking solutions supporting data warehousing.
- Data Warehousing & Data Modelling
- Design and develop enterprise data warehouse solutions.
- Develop relational and dimensional data models.
- Design and implement Star and Snowflake schemas.
- Perform data normalization and denormalization.
- Develop data mappings and transformation logic.




- Support Business Intelligence and data analytics initiatives.
- Design and maintain scalable data architectures.
- Ensure data solutions meet business and operational requirements.
- Azure & Cloud Data Engineering
- Design and develop cloud-based data integration solutions.
- Work with Azure Data Factory to create and manage data pipelines.
- Develop Copy Activities and custom Azure data integration solutions.
- Work with Azure SQL Server and other cloud data platforms.
- Support data migration to cloud environments.
- Work with Azure, AWS, and Google Cloud technologies where applicable.
- Support cloud-based data processing, integration, and storage solutions.
- Performance Tuning & Troubleshooting
- Conduct root cause analysis of ETL and database issues.
- Identify and resolve performance bottlenecks.
- Optimize SQL queries, PL/SQL procedures, ETL workflows, and database operations.
- Conduct proof-of-technology activities using test data to simulate application load.
- Perform application and web database performance optimization.
- Support incident management and application functionality sustainment.
- Troubleshoot production and non-production issues.
- Implement recovery, failover, restore, and refresh procedures.
- Database Administration & Recovery
- Provide database administration and operational support.
- Support database configuration, user roles, access, backup, and recovery.
- Perform database restore and refresh activities across Production, Development, UAT, and Test environments.
- Use RMAN for Oracle recovery and restore operations.

- Support Oracle environments including

- Oracle RAC

- Oracle Data Guard

- Oracle Exadata

- Oracle Enterprise Manager

- Oracle Network Services
- Support database migration and integration across Windows and UNIX platforms.
- Testing, Quality Assurance & Release Support
- Design, code, test, debug, and document ETL applications.
- Conduct unit testing and support QA activities.
- Collaborate with QA teams to test integration services and extensions.
- Test migrated ETL code, SQL, and PL/SQL stored procedures.
- Support defect investigation and resolution.
- Participate in deployment, release, and post-implementation support.
- Validate data quality and integrity across ETL pipelines.
- Documentation & Knowledge Transfer
- Develop and maintain technical designs and specifications.
- Prepare deployment guides, support documentation, and operational procedures.
- Document ETL processes, data models, migration activities, and technical solutions.
- Conduct design walkthroughs with project teams.
- Provide knowledge transfer and post-implementation support.
- Prepare user and system documentation as required.

Experience & Skill Set Requirements Technical Skills – 40% 5+ years of experience with:

- Data warehousing design and development.
- ETL/ELT development using PL/SQL and equivalent technologies.
- Informatica PowerCenter and Informatica Cloud/IDMC.
- Complex procedures, packages, views, and scripts for data extraction and transformation.
- Data denormalization and data loading.
- Oracle, MySQL, and SQL Server relational databases.
- Relational and dimensional data modelling.
- Advanced SQL, including PL/SQL and T-SQL.
- Query optimization and database performance tuning.
- Data replication and database administration.
- Python and Unix shell scripting.
- Cloud technologies including Azure, AWS, and Google Cloud.
- Azure SQL Server and Azure Data Factory.
- Creating Azure Data Factory pipelines and Copy Activities.
- PL/SQL-based ETL development, troubleshooting, performance tuning, failover, and recovery.
- Elasticsearch and performance optimization.
- JIRA and Azure DevOps.
- GitHub for version control and data model changes.
- Oracle Enterprise Manager, Oracle RAC, Data Guard, Exadata, and Oracle Warehouse Builder.
- Data migration and integration across Windows and UNIX platforms.
- Oracle RMAN backup, recovery, restore, and environment refresh activities.

Core Skills – 30% 5+ years of experience with:

- Technical analysis, programming,



detailed specifications, program design, coding, and unit testing.
- Application development across multiple operating systems, database platforms, communication protocols, middleware, and gateways.
- Developing and maintaining system design models and technical documentation.
- Technical evaluation and assessment of application design and integration options.
- Gap analysis against technical requirements and specifications.
- Business Intelligence, data analytics, data warehouse design, and dimensional modelling.
- Researching and assessing technical design options.
- Supporting project plans, work breakdown structures, and resource estimates.
- Translating business requirements and functional specifications into application designs.
- Developing tested applications for large, complex, mission-critical systems.
- Working with QA teams on coding, testing, debugging, and integration.
- Complex multi-tier web applications and microservices architectures.
- Technical leadership and identifying opportunities for improvement.
- Application programming support for incident management and performance tuning.
- Web database performance optimization.
- Ensuring compliance with architecture frameworks and system standards.
- End-to-end SDLC, Agile/Scrum, and Waterfall methodologies.
- Security, privacy, usability, and modern application design principles.

Public Sector Experience – 5%
- Experience working on projects involving federal, provincial, and/or municipal governments.
- Experience working with public-sector data and regulatory environments.
- Knowledge of provincial environmental services and legislative frameworks governing data.
- Experience with data migration and integration across environmental systems.
- Knowledge of OPS Enterprise Architecture artifacts, processes, and practices.
- Ability to produce technical documentation following industry-standard practices.
- Experience adopting OPS Unified I⁢ Project Methodology.
- Experience working with OPS Enterprise Architecture and OPS gating processes.
- Knowledge of OPS Standard Systems Development Methodologies.

General Skills – 25%
- Exceptional analytical, problem-solving, and decision-making skills.
- Strong troubleshooting and critical-thinking capabilities.
- Excellent verbal and written communication skills.
- Strong interpersonal and negotiation skills.
- Strong listening and issue-resolution skills.
- Effective consulting skills with a proven ability to build robust stakeholder relationships.
- Excellent customer service skills with tact and diplomacy.
- Highly motivated, flexible, detail-oriented, and creative.
- Solid organizational and multitasking abilities.
- Proven ability to work effectively in a team environment.
- Ability to coordinate multiple priorities and meet strict deadlines.
- Ability to provide technical leadership, advice, and guidance.

Key Deliverables & Outcomes
- Successfully migrate Informatica PowerCenter v10.2 ETL processes to Informatica Cloud (IDMC).
- Deliver fully tested SQL and PL/SQL migration solutions.
- Design and optimize enterprise ETL/ELT pipelines.
- Develop reliable data warehouse solutions using Star and Snowflake schemas.
- Deliver scalable Oracle, Azure SQL, and cloud data integration solutions.
- Improve ETL and database performance through effective tuning and optimization.
- Resolve production and development ETL/database issues through root cause analysis.
- Support cloud migration and modernization initiatives.
- Ensure data quality, integrity, security, and reliability.
- Produce accurate technical documentation and deployment materials.
- Support Agile delivery, testing, release, and knowledge transfer activities.

How to Apply If you are interested and your profile matches the requirements, please send the following documents to [email protected] by Monday, August 31, 2026 at 10:00 AM EST :

- Updated Resume in Word format – Mandatory
- References – Mandatory
- Expected Hourly Rate – Mandatory
- Visa Status – Mandatory
- LinkedIn ID – Mandatory

Important: Without all mandatory documents, we cannot submit a candidate. If this opportunity is not suitable for you, please forward it to qualified Senior ETL Software Developers with strong experience in Informatica PowerCenter/IDMC, Oracle 11g/19c, PL/SQL, Azure Data Factory, SQL Server, data warehousing, ETL migration, cloud technologies, performance tuning, and enterprise data integration .

📌 – Software Developer – ETL – Senior (Toronto)
🏢 S M Software Solutions
📍 Toronto