Talent.com

Informatica developer Jobs in Toronto, ON

Create a job alert for this search

Informatica developer • toronto on

Last updated: 2 days ago
Senior Software Developer - ETL

Senior Software Developer - ETL

Randstad CanadaToronto, Ontario, CA
Temporary
Quick Apply
Do you have 10 + years of experience developing and performance tuning SQL, T-SQL, PL / SQL and advanced SQL query optimization? Do you have 2+ years of experience with Informatica Cloud (IDMC) inclu...Show moreLast updated: 3 days ago
Informatica Developer

Informatica Developer

ShoreWise ConsultingToronto, Canada
Full-time
ETL and Data warehouse experience.Synapse OR Azure services is nice to have.Candidates only Physically in Canada having Valid Canadian Work Authorization will be considered.NO VISA SPONSORSHIP will...Show moreLast updated: 30+ days ago
ETL Developer – Informatica IICS

ETL Developer – Informatica IICS

Astra North Infoteck Inc.Toronto, ON, ca
Full-time
Experience in ETL development using Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS).Design, develop, and maintain data warehouse solutions to support organizational data n...Show moreLast updated: 16 days ago
Intermediate Informatica & Powercenter Developer - 96565-1

Intermediate Informatica & Powercenter Developer - 96565-1

S.i. SystemsToronto
Full-time
Intermediate Informatica & Powercenter Developer .Every Monday and the first Friday of the month.Potential for expansion of onsite days. Office Location : 81 Bay 15th Floor.What project will this con...Show moreLast updated: 30+ days ago
Software Developer

Software Developer

Talent Test AccountToronto, Ontario, CA
Full-time
Quick Apply
Show moreLast updated: 30+ days ago
RQ10574 - Sr. Software Developer - ETL

RQ10574 - Sr. Software Developer - ETL

Source CodeToronto, ON, Canada
Full-time
Quick Apply
ONSITE 5 days a week - College St.A senior Software Developer ETL is required to provide best practice migration solutions and oversee all facilities of the data and files migration from legacy app...Show moreLast updated: 11 days ago
Sr. SAP ETL Developer

Sr. SAP ETL Developer

Piper CompaniesToronto, ON
Full-time
SAP and non-SAP data into a cloud-based enterprise data platform to support analytics, reporting, and machine learning initiatives. Responsibilities of the Senior SAP ETL Developer : .Design and imple...Show moreLast updated: 30+ days ago
RQ10584 - Software Developer - ETL - Senior

RQ10584 - Software Developer - ETL - Senior

MaarutToronto, ON, ca
Full-time
Quick Apply
Contribute to and support design, development, and maintenance of ETL processes using Informatica Cloud (.Migrate Informatica PowerCentre v10. ETL code including embedded SQL and PL / SQL code develop...Show moreLast updated: 2 days ago
Senior Data Quality Specialist (Informatica)

Senior Data Quality Specialist (Informatica)

Onico SolutionsToronto, ON
Temporary
Senior Data Quality Specialist (Informatica).The Senior Data Quality Specialist (Informatica) will drive the enablement of Data Quality Management practices with technology solutions to define, mon...Show moreLast updated: 30+ days ago
Software Developer - ETL - Senior

Software Developer - ETL - Senior

ProcomToronto, CA
Full-time +1
Software Developer - ETL - Senior : .On behalf of our Government Services client, Procom is searching for a Software Developer - ETL - Senior for a 13-month role. This position is a hybrid position wi...Show moreLast updated: 30+ days ago
Salesforce Developer

Salesforce Developer

Spectrum Health CareToronto, ON, CA
Full-time
Your happiness and well-being are top priorities at Spectrum! We offer competitive wages, paid sick days, RRSP matching and more!. In this role, you will be responsible for designing, building, and ...Show moreLast updated: 30+ days ago
People also ask
Senior Software Developer - ETL

Senior Software Developer - ETL

Randstad CanadaToronto, Ontario, CA
3 days ago
Job type
  • Temporary
  • Quick Apply
Job description

Do you have 10 + years of experience developing and performance tuning SQL, T-SQL, PL / SQL and advanced SQL query optimization? Do you have 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? If so, this would be a great opportunity for you!

Our client is looking for a Senior Software Developer - ETL for a 1 month contract in Toronto.

This is a hybrid role.

Rate : Advantages

  • Earn a competitive rate within the industry.
  • Location : work in office 3 to 5 days per week.
  • Potential for extension

Responsibilities

  • 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.
  • Collaborate with vendor and entire project team for unit testing, debugging, and validation of ETL processes.
  • Document technical designs, deployment guides, and support materials.
  • Participate in Agile / Scrum development cycles and iterative delivery.
  • Ensure compliance with data governance, security, and access control policies.
  • Provide post-implementation support and participate in knowledge transfer sessions.
  • Provide database administration including configuration, backup / recovery, user roles, database
  • Qualifications

    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 experience with Oracle tools : EXPLAIN PLAN, TKPROF, OEM, RMAN, etc.
  • 5+ years Experience with relational database 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 modeling (OLTP, OLAP, dimensional modeling).
  • Experience with REST / SOAP APIs, system integration, and cloud platforms (Azure, AWS, GCP).
  • Experience with data replication, data cleansing, and data quality assurance.
  • Excellent analytical, problem-solving, and communication skills.
  • Desirable Skills :

  • Strong understanding of Agile, SDLC, and DevOps practices.
  • Experience with Azure DevOps and version control systems.
  • Familiarity with OPS (Ontario 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.
  • Summary

    If you are interested in the Senior Software Developer - ETL role in Toronto, please apply online at www.randstad.ca. Qualified candidates will be contacted.

    Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary / gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

    Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.