Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Rq09467 - Software Developer - Etl - Senior

Rubicon Path

RQ09467 - Software Developer - ETL - SeniorTo respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis.
Description:
Hybrid work: will work in office 3 days per week (40 St. Clair West, Toronto) and 2 days remotely.
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.
Key Responsibilities:
Contribute to and support 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 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 vendor and entire project team 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.
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 experience with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
5+ years Experience with relational database 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 set up, 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.
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.
Evaluation Criteria:
Design, develop, modify and enhance Oracle SQL and PL/SQL code for Oracle 11g and 19c.
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 performance.
Design, develop and maintain ETLs using Informatica PowerCentre v10.2 and IDMC.
Administer Informatica PowerCentre and IDMC including asset management;
and configuration of secure agents, schedules, orgs and sub‑Orgs, connections, users and roles.
Migration of Informatica assets from PowerCentre v10.2 to IDMC.
Problem‑Solving and Decision‑Making (20%)
Demonstrated analytical skills in identifying issues and developing effective solutions in a timely manner.
Proven track record of meeting project deadlines and managing deliverables within project constraints.
Familiarity with structured methodologies for software development and the ability to adapt to emerging technologies in GIS.
Demonstrated experience of Oracle 11g and 19c administration including Golden Gate synchronization.
Strong verbal and written communication skills for effectively engaging with technical and non‑technical stakeholders.
Proven ability to collaborate with both vendor and project cross‑functional teams throughout the project.
Proven experience of technical documentation and communication to stakeholders.
OPS Experience (5%)
Prior experience working with OPS as a senior ETL Developer.
Prior experience working with Public Sector as a senior ETL Developer.
#J-18808-Ljbffr
Vacancy posted 56 minutes ago
Similar jobs that could be interesting for youBased on the Rq09467 - Software Developer - Etl - Senior in Winnipeg, MB vacancy
  •  ...Bursting technologies, and Informatica ETL.Responsibilities Perform analysis, design, developing, unit testing, defect fixing and...  ...in Oracle PL/SQLDesign, develop and test Informatica mappingsDevelop...  ...and analysis; specialized software package support at the specified... 
    Senior
    Apprenticeship

    The Code Crackers Inc.

    Winnipeg, MB
    59 minutes ago
  •  ...Bursting technologies, and Informatica ETL. Responsibilities:This request is for strong developers to help in designing and...  ...environment in Oracle PL/SQL Design, develop and test Informatica mappings...  ...and analysis; specialized software package support at the specified... 
    Senior
    Apprenticeship

    Analyst Technical Solutions

    Winnipeg, MB
    1 hour ago
  • The Senior Software Developer - ETL will design, build, and maintain scalable data pipelines, integrations, and reusable data services that enable enterprise AI, analytics, and data initiatives. The role will help improve access to trusted data across enterprise systems... 
    Senior

    Pathlion

    Winnipeg, MB
    58 minutes ago
  • RQ08687 - Software Developer - ETL - SeniorAbout the job RQ08687 - Software Developer - ETL - Senior Responsibilities Participate in the review of project, work request and maintenance release artefacts - Use Case, System Requirement Specification, etc. Deliver detailed... 
    Senior
    Internship
    Work at office
    3 days per week

    Rubicon Path

    Winnipeg, MB
    55 minutes ago
  • RQ09230 - Software Developer - ETL - Senior About the job RQ09230 - Software Developer - ETL - Senior DescriptionA Note on Assignment Type:This position is currently listed as "Onsite"; however, the Assignmentunder this request will provisionally be "Hybrid", working... 
    Senior
    Contract work
    Work at office
    Monday to friday

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  • Client: Metrolinx – RQ00241We are seeking a Senior Software Developer – ETL with significant hands‑on experience in designing, developing, and maintaining scalable, production‑grade data pipelines and integration solutions. The ideal candidate will have strong expertise... 
    Senior
    3 days per week

    S M Software Solutions Inc

    Winnipeg, MB
    1 hour ago
  • RQ09315 - Software Developer - ETL - SeniorAbout the job RQ09315 - Software Developer - ETL - SeniorNOTE Assignment Type: This position is currently listed as "Hybrid" and consultants will be required to work onsite at the work location 3 days a week and 2 days from... 
    Senior
    Contract work
    Internship
    3 days per week

    Rubicon Path

    Winnipeg, MB
    58 minutes ago
  • Senior Software Developer, ETL & AI Data Engineering Location: Toronto, ON (Hybrid, 3 days onsite per week, near Union Station)Language: Written and spoken language requirements to be confirmedDuration: 6-month contract, until May 31, 2027About the Opportunity... 
    Senior
    Contract work
    3 days per week

    Altis

    Winnipeg, MB
    1 hour ago
  • RQ09222 - Software Developer - ETL - Senior About the job RQ09222 - Software Developer - ETL - Senior DescriptionA Note on Assignment Type:This position is currently listed as "Onsite"; however, the Assignmentunder this request will provisionally be "Hybrid", working... 
    Senior
    Contract work
    Work at office
    Monday to friday

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  •  ...data into silver/gold data for reporting consumption. Design, develop, and release deploy Power BI reports and dashboards meeting KPIs...  ...technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion... 
    Work at office
    Monday to friday

    SOFTLINE TECHNOLOGY

    Winnipeg, MB
    58 minutes ago
  •  ...Toronto, ON (5 days onsite in the office) Position Type: Contract Responsibilities: Power BI Development & Reporting Design, develop, and maintain interactive Power BI dashboards and reports to support business and operational needs. Create data models, measures,... 
    Contract work
    Work at office

    Dawn InfoTek

    Winnipeg, MB
    1 hour ago
  • Elevate your expertise as a Senior Software Developer ETL at the Office of the Public Guardian and Trustee. This hybrid role focuses on integrating and testing the Dynamics 365 solution. In this position, you’ll contribute to critical integrations within the integrations team... 
    Senior
    Work at office

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  • About the job RQ08100: Software Developer - ETLGeneral ResponsibilitiesThis role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The developer will... 
    Work at office
    3 days per week

    Rubicon Path

    Winnipeg, MB
    54 minutes ago
  • About the job RQ07956 - Sr Software Developer - ETLResponsibilities Design, implement, and continuously...  ...a track record for meeting deadlines ETL Skills Knowledge and experience in...  ...would be an asset Must Have Senior ETL Developer 7+ years Demonstrates... 
    Senior

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  • Overview Our client, an innovative industry leader in the insurance domain, is looking for a Senior ETL Developer - Hybrid to join their growing team. The successful candidate will have extensive experience building reliable, scalable, and efficient data pipelines to operationalize... 
    Senior
    Permanent employment
    Full time
    Work at office
    3 days per week

    Randstad Digital

    Winnipeg, MB
    1 hour ago
  • Build Azure ETL solutions as a Senior Software Developer, using Azure Data Factory and Informatica in a hybrid office schedule. Integrate data across complex environments.This senior developer designs, implements, and supports data pipelines throughout the software development... 
    Senior
    Work at office

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  • Build Azure ETL pipelines in a hybrid assignment supporting data migration with Azure Data Factory, Synapse, and strong SQL expertise. Work weekdays within stated hours.As a Senior Software Developer ETL, you will support the Office of the Public Guardian and Trustee’s migration... 
    Senior
    Work at office
    Weekday work

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  • $100 per hour

    SENIOR SOFTWARE DEVELOPER/ETL (Azure & Python; Enterprise AI & Data Centre of Excellence)Requisition #: R26-3629 (RQ00241) Location: Hybrid (3 days onsite / 2 days WFH; Toronto, ON - *See WorkModel) Engagement Type: Contract Number of Resources required... 
    Senior
    Hourly pay
    Contract work
    For contractors
    Work at office

    Tri-global Solutions Group Inc.

    Winnipeg, MB
    1 hour ago
  • $180k - $200k per year

     ...visionary and a strategic leader within our AI organization. While a Senior Data Scientist excels at building and deploying specific models,...  ...), Agile. What You Must Have 10+ years of experience in software or data science, with at least 8+ years specifically... 
    Senior
    3 days per week

    TEEMA Group

    Winnipeg, MB
    5 days ago
  • You should have experience with InfoSphere on the Linux Platform administration Must have experience in DataStage and QualityStage Experience in Linux and shell scripting Strong experience in Information Services Director, Information Analyzer and PL SQL Hands on...
    Senior

    Lorven Technologies, Inc.

    Winnipeg, MB
    1 hour ago
  • Build scalable ETL pipelines and data integrations as a Senior Software Developer supporting enterprise AI and analytics initiatives.This senior role develops trusted data access across enterprise systems. You will create reusable services, prepare structured and unstructured... 
    Senior

    Pathlion

    Winnipeg, MB
    1 hour ago
  • Deliver senior ETL solutions with Azure Data Factory, Power BI, and SQL while translating specifications into tested applications and deployments.This Senior Software Developer specializes in extraction, transformation, and loading across complex application and data environments... 
    Senior

    Rubicon Path

    Winnipeg, MB
    1 hour ago
  •  ...Software Developer - ETL / Power BI - Intermediate (BBBH12319) Toronto, Canada Seeking an experienced Software Developer - ETL / Power BI to support enterprise data integration, ETL processes, and business intelligence initiatives. The successful candidate will develop and... 

    isgSearch

    Winnipeg, MB
    1 hour ago
  •  ...proficiency in Teradata SQL and BTEQ is required.8-10 years of experience ETL development using various versions of Teradata6+ years of...  ..., releases.Excellent written and verbal communication skills.Develops statements of problems and requirements. Can translate both business... 
    Senior

    United Software Group Inc

    Winnipeg, MB
    58 minutes ago
  • Design cloud ETL solutions with Informatica IICS, IDMC, PowerCenter, and SQL in a senior development capacity. Support data processing, reporting, and troubleshooting.This Senior Informatica Developer requires eight to ten years of overall ETL development experience. You will... 
    Senior

    Astra-North Infoteck Inc.

    Winnipeg, MB
    1 hour ago
  • Transform data processes as a Senior DataStage ETL Developer with expertise in Linux and advanced data analysis tools. Dive into QualityStage and PL SQL tasks regularly. This role is intended for experienced ETL developers with more than 5 years focusing on DataStage and QualityStage... 
    Senior

    Lorven Technologies, Inc.

    Winnipeg, MB
    59 minutes ago
  • Use Ab Initio expertise in a hybrid Senior Developer assignment, working three days weekly in Toronto Downtown. Bring eight years of experience to complex ETL migration.This Ab Initio Developer serves as the subject matter expert for an existing Ab Initio ETL ecosystem. The... 
    Senior
    Work at office

    Apptoza Inc.

    Winnipeg, MB
    54 minutes ago
  • Elevate your career as a Senior ETL Developer with the Central Agencies Cluster in Toronto, ON. Design and maintain innovative ETL solutions to support large-scale data operations. This role focuses on building and optimizing data pipelines and architectures for the Enterprise... 
    Senior

    Analyst Technical Solutions

    Winnipeg, MB
    55 minutes ago
  •  ...you! We’re looking for an Intermediate ETL Developer to join Pandell-ESG's Project Services...  ...help customers move their data into our software and work alongside a strong team that’s...  ...unfamiliar data models with support from senior teammates. Take the technical lead on... 
    Senior
    Manual labor
    Work at office
    Work from home
    Flexible hours

    Pandell Technology Corporation

    Winnipeg, MB
    57 minutes ago
  • A software solutions provider is seeking an experienced ETL developer in Canada with strong proficiency in Teradata SQL and BTEQ. Candidates should have 8-10 years of ETL development experience and 6+ years working in enterprise data warehouses. Strong documentation skills... 
    Senior

    United Software Group Inc

    Winnipeg, MB
    59 minutes ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Rq09467 - Software Developer - Etl - Senior. Be the first to apply!