Back to results

Hybrid! ETL Developer, 1 Month Contract

  • Toronto, ON, Canada
Apply on jobs.crelate.com About employer

Applications open in a new tab.

Job details

Posting language
English
Posted

Original job description

  • Openings: 1
  • Duration: 2027-02-12 to 2027-03-31 (29 days)
  • Job Type: Hybrid: Candidate MUST work 3 days onsite
  • Location: Toronto, Ontario

Requirements:

  • 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-based 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.
More about this job

Responsibilities

The ETL Developer at Dimensional Tech Inc. will build and maintain data pipelines in Informatica Cloud, migrate older Informatica and Oracle code, and tune SQL for speed. The role also includes fixing data loading problems and testing the results.

Requirements

Candidates need hands-on ETL experience with Informatica, strong Oracle SQL and PL/SQL skills, and experience tuning queries. They must also be able to work from the Toronto office three days per week.

Skills

  • Informatica Cloud (IDMC)
  • Informatica PowerCenter
  • Oracle SQL
  • PL/SQL
  • Oracle 11g
  • Oracle 19c
  • Embedded SQL
  • Stored procedures
  • SQL query optimization
  • PL/SQL performance tuning
  • ETL development
  • ETL migration
  • Data warehousing
  • Star schema design
  • Snowflake schema design
  • Data extraction
  • Data transformation
  • Data loading
  • Root cause analysis
  • Test case development
  • Data pipeline development
  • Technical specification translation
  • Database performance tuning

Categories

  • Data & Analytics
  • Software
  • Technology

Keywords

  • ETL Developer
  • Informatica Cloud
  • IDMC
  • Informatica PowerCenter
  • Oracle 11g
  • Oracle 19c
  • PL/SQL
  • SQL
  • stored procedures
  • data warehouse
  • star schema
  • snowflake schema
  • data pipelines
  • performance tuning
  • root cause analysis
  • data migration
  • hybrid
  • Toronto
  • contract
  • data integration

Seniority

Mid level

Tools

  • Informatica Cloud (IDMC)
  • Oracle 11g
  • Oracle 19c

Languages

  • English

Report this job

Get in touch
MovoJobs

How can we help?