RQ09467 - Sr. Software Developer - ETL
RQ09467 - Sr. Software Developer - ETL
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
RQ09467 - Sr. Software Developer - ETL
St. Clair West Toronto
Hybrid work: 3 days per week and 2 days remotely.
Contract (8 months)
A highly skilled and experienced ETL Developer to design develop and maintain robust data integration solutions. The ideal candidate will have deep expertise in Informatica PowerCenter v10.2 and Informatica Intelligent Data Management Cloud (IDMC) PL/SQL and data warehousing with a strong background in performance tuning troubleshooting and cloud migration. This role involves working closely with business analysts developers and stakeholders to ensure high-quality data delivery and system integration.
Must-Haves
- 10 years of experience as a BI/ETL Developer.
- 10 years of experience developing and performance tuning SQL T-SQL PL/SQL and advanced SQL query optimization.
- 10 years of experience with Oracle tools: EXPLAIN PLAN TKPROF OEM RMAN etc.
- 5 years of experience with relational databases including Oracle including Oracle 11g and 19c.
- 3 years of hands-on experience with Informatica PowerCenter v10.2 administration
- 2 years of experience with Informatica Cloud (IDMC) including PC to IDMC migration; asset management; and configuration of secure agents schedules orgs and sub-Orgs connections users and roles
- Hands-on Oracle 11g and 19c experience configuring user roles setup RMAN data dumps and Golden Gate synchronization
- Proficiency in data modelling (OLTP OLAP dimensional modelling).
- Experience with REST/SOAP APIs system integration and cloud platforms (Azure AWS GCP).
- Experience with data replication data cleansing and data quality assurance.
- Strong understanding of Agile SDLC and DevOps practices.
- Experience with Azure DevOps and version control systems.
- Familiarity with OPS (Ontario Public Service) methodologies and enterprise architecture.
- Experience in public sector projects especially in environmental or inter-jurisdictional data systems.
- Understanding of Information Management principles and data governance.
Employment Type
Full Time
