Informatica Iics Onsite Tech Lead

5 months ago


Toronto, Canada Capgemini Full time

Key Responsibilities:

- Take initiative, show ownership, and drive ETL projects to closure.
- Develop and maintain robust ETL processes using Informatica IICS, focusing on performance tuning and implementing Slowly Changing Dimensions (SCD) Type-I & II.
- Design and implement database solutions and ensure the integrity of high-volume data interactions using strong SQL skills.
- Utilize Snowflake for scalable data warehousing solutions and manage data transformations effectively.
- Employ ESP or similar scheduling tools to manage and monitor ETL jobs efficiently.
- Collaborate with client tech leads to discuss, get approval, and integrate ETL designs.
- Document ETL specifications clearly and comprehensively.
- Facilitate the understanding of project requirements, design, and planning phases.
- Provide technical leadership within the team, mentoring junior members and guiding them on best practices.

Required Skills and Experience:

- Minimum of 8 years of experience in DW/ETL projects with a strong foundation in data warehousing concepts.
- Proficiency in Informatica IICS for ETL development and extensive experience with Snowflake data warehousing.
- Strong database and SQL skills, with the ability to handle complex data environments.
- Experience with UNIX shell scripting and an understanding of Oracle, ODS, and EDW systems.
- Strong analytical and problem-solving abilities, with the capacity to lead technical discussions and decision-making processes.
- Excellent communication skills, able to effectively interact with both business users and IT stakeholders.
- Familiarity with Agile methodologies and the ability to work in a fast-paced, iterative development environment.
- Previous experience in the banking sector is highly regarded.

Preferred Qualifications:

- Technical lead experience, with a proven track record of getting ETL design approvals from clients.
- Experience in writing detailed ETL specification documents and managing project documentation.

**_
The pay range that the employer in good faith reasonably expects to pay for this position is $32.36/hour - $50.56/hour. Our benefits include medical, dental, vision and retirement benefits. Applications will be accepted on an ongoing basis._


  • Informatica Iics

    1 week ago


    Toronto, Canada Tekishub Consulting Services Full time

    **Job Title/ Role: Informatica iPaas** **Location : Toronto(hybrid 2 days onsite in a week)** **Contract** **Job Description &** - Strong implementation experience in ETL solutions Lead - Experience in creating mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanisms by using Informatica...

  • Lead Administrator L1

    20 hours ago


    Toronto, Canada Emonics LLC Full time

    **10+ years** of Strong ETL knowledge on Informatica PowerCenter and IICS, Implementation of at least 2 projects in IICS - Experience on IICS Platform setup, Connection, SAML authentication, Secure Agent and Group configuration - Experience in DevOps - Experience for IICS mapping scheduling through IICS native scheduler - Working with CDI-Elastic and...


  • Toronto, Canada Atlantis IT group Full time

    Toronto **Role name**: Lead **Role Description**: Lead the design, development and implementation of ETL processes using Informatica IICS ensuring seamless data integration and overseeing the team and issues /enhancement in this area. Manage Support and Enhancement activities, monitor ETL performance, troubleshoot issues and ensure adherence to best...


  • Toronto, Canada MPA Recruitment Full time

    Informatica DeveloperToronto (remote)6 Months (Strong possibility of extension)Competitive hourly ratesThis is an open call for Informatica/IICS Developers in Ontario. We have several new projects kicking off in Jan 2025.We are seeking experienced Informatica Developers for a 6-month contracts opportunity in Toronto, with a strong potential for extension....


  • Toronto, Canada MPA Recruitment Full time

    Informatica DeveloperToronto (remote)6 Months (Strong possibility of extension)Competitive hourly ratesThis is an open call for Informatica/IICS Developers in Ontario. We have several new projects kicking off in Jan 2025.We are seeking experienced Informatica Developers for a 6-month contracts opportunity in Toronto, with a strong potential for extension....


  • Toronto, Canada MPA Recruitment Full time

    Informatica Developer Toronto (remote) 6 Months (Strong possibility of extension) Competitive hourly rates This is an open call for Informatica/IICS Developers in Ontario. We have several new projects kicking off in Jan 2025. We are seeking experienced Informatica Developers for a 6-month contracts opportunity in Toronto, with a strong potential for...


  • Toronto, ON, Canada MPA Recruitment Full time

    Informatica Developer Toronto (remote)6 Months (Strong possibility of extension) Competitive hourly rates This is an open call for Informatica/IICS Developers in Ontario. We have several new projects kicking off in Jan 2025. We are seeking experienced Informatica Developers for a 6-month contracts opportunity in Toronto, with a strong potential for...


  • Toronto, ON, Canada MPA Recruitment Full time

    Informatica Developer Toronto (remote) Competitive hourly rates We have several new projects kicking off in Jan 2025. We are seeking experienced Informatica Developers for a 6-month contracts opportunity in Toronto, with a strong potential for extension. The successful candidate will work on data integration/migration projects, leveraging ...

  • Informatica Developer

    2 months ago


    Toronto, Ontario, Ontario, Canada Hays Full time

    Role : Informatica MDM developerJob SummaryWe are seeking a highly skilled Informatica MDM developer with 8 to 12 years of experience to join our team. The ideal candidate will have extensive experience in Infa Cloud Data Profiling, Infa Cloud Data Quality, Infa Cloud Data Integration, IICS, Informatica Cloud Data Quality, and Informatica Cloud. This role is...


  • Toronto, Ontario, Canada MPA Recruitment Full time

    We are seeking an experienced Informatica Developer for a 6-month contract opportunity in Toronto, with a strong potential for extension. The successful candidate will work on data integration/migration projects, leveraging Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) to build scalable and efficient ETL solutions.This is an open...


  • Toronto, Canada Patch Tech Staffing Full time

    We are seeking a highly skilled Data Engineer to join our data team at Patch Tech Staffing. In this role, you will play a crucial part in designing and maintaining our data infrastructure and pipelines. The ideal candidate will have experience with Informatica Intelligent Cloud Services (IICS) for data integration, ETL development, and cloud data...


  • Toronto, Ontario, Canada MPA Recruitment Full time

    MPA Recruitment is currently seeking an experienced Informatica Data Integration Specialist to join our team. Salary: $65-$90 per hour (dependent on experience) in Toronto, Ontario.This role offers a unique opportunity to work on high-impact projects utilizing cutting-edge tools and technologies in the field of data integration.Job Description: We are...


  • Toronto, Ontario, Ontario, Canada Hays Full time

    Tile: Informatica MDM DeveloperRate: 65-70Job SummaryWe are seeking a highly skilled Informatica MDM developer with 8 to 12 years of experience to join our team. The ideal candidate will have extensive experience in Infa Cloud Data Profiling, Infa Cloud Data Quality, Infa Cloud Data Integration, IICS, Informatica Cloud Data Quality, and Informatica Cloud....


  • Toronto, Ontario, Canada MPA Recruitment Full time

    We are seeking experienced Informatica Developers for a 6-month contract opportunity in Toronto, Canada. About the RoleAs an Informatica Developer with MPA Recruitment, you will work on data integration/migration projects, leveraging Informatica PowerCenter and Informatica Intelligent Cloud Services (IICS) to build scalable and efficient ETL solutions.You...


  • Toronto, Ontario, Canada Patch Tech Staffing Full time

    About UsPatch Tech Staffing is a leading provider of innovative data solutions. Our team of experts is dedicated to delivering cutting-edge technology and exceptional service.Job DescriptionWe are seeking a highly skilled Data Architect to join our team. As a key member of our data engineering group, you will play a crucial role in designing, building, and...


  • toronto, Canada Patch Tech Staffing Full time

    We are seeking a highly motivated and skilled Data Engineer to join our growing data team. In this role, you will play a crucial part in designing, building, and maintaining our data infrastructure and pipelines. You will be responsible for ingesting, transforming, and loading data from various sources into our data warehouse, ensuring its quality,...


  • Toronto, Canada Tata Consultancy Services Full time

    Inclusion without Exception:Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...


  • Toronto, Canada Tata Consultancy Services Full time

    Inclusion without Exception:Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...


  • Toronto, Canada Tata Consultancy Services Full time

    Inclusion without Exception: Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...


  • Toronto, Canada Tata Consultancy Services Full time

    Inclusion without Exception:Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity is reflected in our...