ETL Developer – Informatica & Cloud Migration
About the role
ETL Developer – Informatica & Cloud Migration: On behalf of our Government Services client, Procom is searching for an ETL Developer – Informatica & Cloud Migration for an 8-month role. This position is a hybrid position with 3 days onsite at our client’s Toronto office.
ETL Developer – Informatica & Cloud Migration - Job Description: This project involves the migration of existing ETL processes from Informatica PowerCenter to Informatica Cloud (IDMC), focusing on enhancing data integration solutions. The ETL Developer will ensure high-quality data delivery and seamless system integration by collaborating with various stakeholders.
ETL Developer – Informatica & Cloud Migration - Responsibilities:
- Design, develop, and maintain ETL processes using Informatica Cloud (IDMC).
- Migrate Informatica PowerCenter v10.2 ETL code including embedded SQL and PL/SQL (Oracle 11g and 19c).
- Test migrated SQL code and PL/SQL stored procedures.
- Optimize SQL queries and PL/SQL code for performance and scalability.
- Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery.
- Perform data extraction, transformation, and loading (ETL) into data warehouses using star/snowflake schemas.
- Ensure compliance with data governance, security, and access control policies.
ETL Developer – Informatica & Cloud Migration - Mandatory Skills:
- 10+ years as a BI/ETL Developer.
- 10+ years of experience with SQL, T-SQL, PL/SQL, and SQL optimization.
- 10+ years with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN.
- 5+ years working with Oracle 11g and 19c relational databases.
- 3+ years of Informatica PowerCenter v10.2 administration.
- 2+ years of Informatica Cloud (IDMC): PC to IDMC migration, asset management, agent/configuration setup.
- Hands-on experience with Oracle 11g/19c configuration, RMAN, user roles, data dumps, and GoldenGate.
ETL Developer – Informatica & Cloud Migration – Nice-to-Have Skills:
- Knowledge of Agile, SDLC, and DevOps practices.
- Experience with Azure DevOps and version control tools.
- Familiarity with Ontario Public Service (OPS) methodologies and enterprise architecture.
- Experience with public sector or environmental/inter-jurisdictional data systems.
- Understanding of Information Management and data governance principles.
ETL Developer – Informatica & Cloud Migration – Assignment Length: This is an 8-month contract position.
ETL Developer – Informatica & Cloud Migration - Start Date: ASAP.
ETL Developer – Informatica & Cloud Migration - Assignment Location: Toronto, Ontario, Canada. This is a hybrid position requiring 3 days onsite.
About Procom
Procom is one of North America’s leading staffing and contract workforce services providers. Successfully meeting the needs of Fortune 500 clients since 1978, we have 18 offices across North America, with over 12,500 skilled professionals currently on assignment.
We are an award winning staffing firm. Discover more about our Best of Staffing award and what real clients and job seekers have to say about working with Procom by checking out our client and talent ratings on ClearlyRated.
Procom has long been recognized as a market-leading source of high-performing services and solutions that transform how our clients acquire and manage the very best talent. Relying on the excellence of individuals to make a difference, we know that people matter.
And we want to work with you.
ETL Developer – Informatica & Cloud Migration
About the role
ETL Developer – Informatica & Cloud Migration: On behalf of our Government Services client, Procom is searching for an ETL Developer – Informatica & Cloud Migration for an 8-month role. This position is a hybrid position with 3 days onsite at our client’s Toronto office.
ETL Developer – Informatica & Cloud Migration - Job Description: This project involves the migration of existing ETL processes from Informatica PowerCenter to Informatica Cloud (IDMC), focusing on enhancing data integration solutions. The ETL Developer will ensure high-quality data delivery and seamless system integration by collaborating with various stakeholders.
ETL Developer – Informatica & Cloud Migration - Responsibilities:
- Design, develop, and maintain ETL processes using Informatica Cloud (IDMC).
- Migrate Informatica PowerCenter v10.2 ETL code including embedded SQL and PL/SQL (Oracle 11g and 19c).
- Test migrated SQL code and PL/SQL stored procedures.
- Optimize SQL queries and PL/SQL code for performance and scalability.
- Conduct root cause analysis and resolve ETL issues, including performance tuning and recovery.
- Perform data extraction, transformation, and loading (ETL) into data warehouses using star/snowflake schemas.
- Ensure compliance with data governance, security, and access control policies.
ETL Developer – Informatica & Cloud Migration - Mandatory Skills:
- 10+ years as a BI/ETL Developer.
- 10+ years of experience with SQL, T-SQL, PL/SQL, and SQL optimization.
- 10+ years with Oracle tools: EXPLAIN PLAN, TKPROF, OEM, RMAN.
- 5+ years working with Oracle 11g and 19c relational databases.
- 3+ years of Informatica PowerCenter v10.2 administration.
- 2+ years of Informatica Cloud (IDMC): PC to IDMC migration, asset management, agent/configuration setup.
- Hands-on experience with Oracle 11g/19c configuration, RMAN, user roles, data dumps, and GoldenGate.
ETL Developer – Informatica & Cloud Migration – Nice-to-Have Skills:
- Knowledge of Agile, SDLC, and DevOps practices.
- Experience with Azure DevOps and version control tools.
- Familiarity with Ontario Public Service (OPS) methodologies and enterprise architecture.
- Experience with public sector or environmental/inter-jurisdictional data systems.
- Understanding of Information Management and data governance principles.
ETL Developer – Informatica & Cloud Migration – Assignment Length: This is an 8-month contract position.
ETL Developer – Informatica & Cloud Migration - Start Date: ASAP.
ETL Developer – Informatica & Cloud Migration - Assignment Location: Toronto, Ontario, Canada. This is a hybrid position requiring 3 days onsite.
About Procom
Procom is one of North America’s leading staffing and contract workforce services providers. Successfully meeting the needs of Fortune 500 clients since 1978, we have 18 offices across North America, with over 12,500 skilled professionals currently on assignment.
We are an award winning staffing firm. Discover more about our Best of Staffing award and what real clients and job seekers have to say about working with Procom by checking out our client and talent ratings on ClearlyRated.
Procom has long been recognized as a market-leading source of high-performing services and solutions that transform how our clients acquire and manage the very best talent. Relying on the excellence of individuals to make a difference, we know that people matter.
And we want to work with you.