ETL Developer
- Toronto, ON, Canada
Full-time
Applications open in a new tab.
Job details
- Job type
- Full-time
- Apply by
- Posting language
- English
- Posted
Original job description
Must Have
- 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
Design, develop, and maintain ETL processes using Informatica Cloud and migrate legacy PowerCentre code. Optimize SQL queries and PL/SQL stored procedures to ensure high performance and scalability of data pipelines.
Requirements
Candidates must have experience with Informatica IDMC, PowerCentre, and Oracle databases. Proficiency in SQL, PL/SQL, and data warehouse schemas like star and snowflake is required.
Skills
- Informatica Cloud (IDMC)
- Informatica PowerCentre
- SQL
- PL/SQL
- Oracle 11g
- Oracle 19c
- ETL Development
- Performance Tuning
- Data Warehousing
- Root Cause Analysis
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
- Engineering
Keywords
- ETL
- Informatica Cloud
- IDMC
- Informatica PowerCentre
- SQL
- PL/SQL
- Oracle 11g
- Oracle 19c
- Data Warehouse
- Star Schema
- Snowflake Schema
- Performance Tuning
- Data Pipelines
- Root Cause Analysis
- IT Services
- IT Consulting