Data Governance - Informatica / Power BI Developer

This hybrid role combines ETL development using Informatica with data visualization and reporting using Power BI. The developer will design, implement, and maintain data integration workflows and create interactive dashboards to deliver actionable insights for business stakeholders.

Key Responsibilities

Informatica (ETL & Data Integration)

Design, develop, and maintain ETL processes using Informatica PowerCenter or IICS. Create and optimize data mappings, workflows, and sessions for efficient data movement. Perform data extraction, transformation, and loading (ETL) from multiple sources into data warehouses. Ensure data quality and integrity through rigorous testing and validation. Monitor ETL jobs, troubleshoot performance issues, and resolve errors. Document technical specifications, data mappings, and workflows.

Power BI (Data Visualization & Analytics)

Design and develop Power BI dashboards and reports based on business requirements. Build and optimize data models in Power BI, including relationships, hierarchies, and row-level security. Implement advanced DAX calculations for KPIs, time intelligence, and complex measures. Connect Power BI to various data sources (SQL Server, Snowflake, Azure SQL, Databricks). Optimize report performance and ensure scalability. Collaborate with stakeholders to gather requirements and deliver actionable insights.

Life at Capgemini

• Flexible work
• Healthcare including dental, vision, mental health, and well-being programs
• Financial well-being programs and Employee Share Ownership Plan
• Paid time off and paid holidays
• Paid parental leave
• Family building benefits like adoption assistance, surrogacy, and cryopreservation
• Social well-being benefits like subsidized back-up child / elder care and tutoring
• Mentoring, coaching and learning programs
• Employee Resource Groups
• Disaster Relief

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, generative AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2024 global revenues of €22.1 billion.

Equity & Inclusion

Capgemini is an Equal Opportunity Employer encouraging inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity / expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.

Job Details

Job Title : Data Governance - Informatica / Power BI Developer

Location : CAN-ON-Toronto

Requisition ID : 082705

#J-18808-Ljbffr