-
Apply Now
-
Please wait...
Start applying with LinkedIn
Data Warehouse Architect - MY
Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.
YOUR ROLE:
As a Data Warehouse Architect with Capgemini, you will design, build, and maintain the framework for client's central data repository, ensuring data is accurately stored, integrated, and accessible for analysis.You will translate business needs into technical solutions, managing ETL (Extract, Transform, Load) processes, security, and data modeling to facilitate faster and reliable decision-making.
Primary Skill
- Onprem cloud
- Hybrid data warehouse architecture
- Dimensional modelling
- Data lake patterns
- Advanced SQL
- Design implement ETL pipelilnes
- Azure data factory
- Informatica
Secondary Skill
- Code review
- Documentation
- Stakeholder communications
YOUR PROFILE:
Required Expereince:
- 8 -12 years in data engineering DW roles
- 3 years in designing enterprisescale data warehouses
- Proven experience in delivering DW projects end to end
- Experience in supporting analytics or regulatory reporting environments.
Key Responsibilities
- Data Architecture Modelling
o Enterprise data warehouse architecture onprem cloud or hybrid
o Dimensional modelling star snowflake schemas
o Factdimension design slowly changing dimensions SCD Types 13
o Understanding of data lake patterns
- Database Performance
o Advanced SQL Oracle MSSQL
o Query optimisation indexing strategies partitioning
o Handling large data volumes and complex joins
o Capacity planning and performance benchmarking
- ETL Engineering
o Design and implementation of ETLELT pipelines
o Experience with tools such as SSIS Informatica Azure Data Factory
o Change data capture CDC strategies
o Error handling and logging
- Data Governance Security
o Data quality frameworks completeness accuracy timeliness
o Rowlevel and columnlevel security
o Data lineage and metadata management
o Familiarity with IAM concepts and access controls a plus
- Leadership Delivery
o Technical leadership and mentoring
o Code reviews and design authority
o Stakeholder communication and design walkthroughs
o Documentation standards
Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.
Make it real | www.capgemini.com
Kuala Lumpur, MY
-
Apply Now
-
Please wait...