Data Governance - Informatica / Power BI Developer

Capgemini; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A global technology transformation partner is looking for a Data Governance - Informatica / Power BI Developer to design and maintain ETL processes and develop data visualizations. This hybrid role involves creating interactive dashboards and optimizing data flows for business insights. Ideal candidates will be experienced in Informatica and Power BI. Benefits include flexible work arrangements, healthcare coverage, and various well-being programs.

Benefits

Flexible work

Healthcare including dental and vision

Employee Share Ownership Plan

Paid parental leave

Qualifications

• Proficient in designing ETL processes with Informatica PowerCenter or IICS.
• Experience in creating and optimizing Power BI dashboards.
• Ability to perform data extraction, transformation and loading.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica.
• Create and optimize Power BI dashboards based on business requirements.
• Monitor ETL jobs and troubleshoot performance issues.

Skills

Informatica PowerCenter

Power BI

Data integration

ETL processes

DAX calculations

Job description

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