ETL Consultant (Informatica Power Center)
- Remote, Canada
Remote
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Workplace
- Remote
- Apply by
- Remote eligibility
- Canada listed. Check the posting for province restrictions.
- Posting language
- English
- Posted
Original job description
Role Overview
We are looking for a skilled ETL Developer with strong PL/SQL and Oracle expertise to support data integration, batch processing, and production support activities. The role involves working on ETL development, database programming, and ensuring smooth execution of large-scale data workflows.
Key Experience Required
•
In-depth knowledge of ETL tools , specifically Informatica PowerCenter (or similar platforms).
•
Hands-on experience developing and deploying ETL code using Informatica PowerCenter or equivalent tools.
•
Strong PL/SQL skills with experience testing and optimizing:
•
Stored Procedures
•
Functions
•
Packages
•
Experience scheduling and executing monthly and annual batch jobs using ETL tools and PL/SQL.
•
Experience handling production issues , managing data interfaces, and generating/tuning SQL reports.
•
Experience gathering business requirements and designing functional solutions for data integration projects.
•
Knowledge of Siebel EIM automations using PL/SQL jobs (preferred).
Technical Skills
•
PL/SQL
•
ETL Tools: Informatica PowerCenter (or similar)
•
Database: Oracle (SQL & PL/SQL)
More about this job
Responsibilities
The ETL Consultant at Querentia will build and deploy ETL code, write and tune PL/SQL procedures, functions and packages, and keep large data workflows running in production. The role also gathers business requirements and designs data integration solutions.
Requirements
Candidates need hands-on Informatica PowerCenter or similar ETL experience, strong Oracle SQL and PL/SQL skills, and experience scheduling batch jobs. Production support and SQL report tuning experience is required, and Siebel EIM automation is preferred.
Skills
- Informatica PowerCenter
- ETL development
- PL/SQL
- Oracle SQL
- Oracle database
- Stored procedures
- Packages
- Functions
- Batch job scheduling
- Production support
- Data integration
- SQL performance tuning
- SQL report generation
- Business requirements gathering
- Functional solution design
- Siebel EIM
- Data interface management
Categories
- Software
- Technology
- Data & Analytics
Keywords
- ETL
- Informatica PowerCenter
- Informatica
- PL/SQL
- Oracle
- SQL
- stored procedures
- functions
- packages
- batch processing
- batch jobs
- data integration
- production support
- SQL reports
- Siebel EIM
- data warehousing
- data interfaces
- ETL developer
- ETL consultant
- contract
Seniority
Mid level
Tools
- Informatica PowerCenter
- Oracle
- PL/SQL
- SQL