Capgemini is looking to solve the problem of delivering actionable insights for business stakeholders through data integration and visualization
Requirements
- Informatica PowerCenter or IICS
- Power BI
- SQL Server
- Snowflake
- Azure SQL
- Databricks
- Data modeling and data warehousing
Responsibilities
- 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
- 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)
Other
- Valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in Canada by 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