Hybrid! ETL Developer, 1 Month Contract
- Toronto, ON, Canada
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