Job Title

We are looking for a skilled Informatica Engineer to design, develop, and maintain robust data integration solutions using Informatica tools. The ideal candidate will have hands-on experience with ETL development, data pipelines, and data warehousing, and will play a key role in enabling data-driven decision-making across the organization. Hybrid not remote to go into the office in North York. Key Responsibilities: IDMC Develop and optimize ETL/ELT workflows using Informatica IDMC. Implement data quality rules, profiling, and cleansing using IDMC''s Data Quality services. Design and manage master data domains using IDMC''s Master Data Management capabilities. Ensure compliance and governance through metadata management and data lineage tracking. Integrate cloud and hybrid data sources to support analytics and operational reporting. ETL Development & Maintenance Design, develop, and optimize ETL workflows and mappings using Informatica PowerCenter or Informatica Intelligent Cloud Services (IICS). Extract, transform, and load data from various sources (databases, flat files, APIs) into data warehouses or data lakes. Ensure data quality, consistency, and integrity across systems. Data Integration & Support Collaborate with data analysts, architects, and business stakeholders to understand data requirements and deliver scalable solutions. Monitor and troubleshoot ETL jobs, resolving failures and performance issues in a timely manner. Maintain and enhance existing data integration processes to support evolving business needs. Documentation & Best Practices Document ETL processes, data flows, and technical specifications. Follow and enforce data governance, security, and compliance standards. Participate in code reviews and contribute to continuous improvement of development practices. Collaboration & Communication Work closely with cross-functional teams including BI, data science, and application developers. Provide support during UAT and production deployments. Communicate technical concepts clearly to both technical and non-technical audiences. Required Qualifications: Bachelor''s degree in Computer Science, Information Systems, or a related field. 36 years of experience in ETL development using Informatica. Strong SQL skills and experience with relational databases (e.g., Oracle, SQL Server, PostgreSQL). Familiarity with data warehousing concepts, star/snowflake schemas, and data modeling. Experience with job scheduling tools (e.g., Autosys, Control-M) and version control systems (e.g., Git). Preferred Qualifications: Experience with cloud platforms (Azure, AWS, or GCP) and cloud-based data integration. Exposure to Informatica Data Quality (IDQ) or MDM. Knowledge of Python, Shell scripting, or other automation tools. Informatica certifications are a plus. Life at Capgemini Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer: Collaborating with teams of creative, fun, and driven colleagues Flexible work options enabling time and location-based flexibility Company-provided home office equipment Virtual collaboration and productivity tools to enable hybrid teams Comprehensive benefits program (Health, Welfare, Retirement and Paid time off) Other perks and wellness benefits like discount programs, and gym/studio access. Paid Parental Leave and coaching, baby welcome gift, and family care/illness days Back-up childcare/elder care, childcare discounts, and subsidized virtual tutoring Tuition assistance and weekly hot skill development opportunities Experiential, high-impact learning series events Access to mental health resources and mindfulness programs Access to join Capgemini Employee Resource Groups around communities of interest About Capgemini Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of 22.5 billion. Get The Future You Want |