Duration: 6+Months

Responsibilities
:

  • Strong data modeler with 10+ years of experience in BI/Data Warehousing required to develop a new complex data warehouse. Should have the following skills
  • Experience leading teams or on-shore, off-shore, internal organization and external organization members
  • Be able to create a plan or backlog and manage to it with the proper artifacts, and processes
  • Waterfall
  • Agile
  • Extensive experience designing data warehouse models
  • Has defined the data models for at least 4 large scale data warehouses
  • Strong SQL skills
  • Strong in database scripting, and utilities
  • Ability understand business requirements & own the entire data model design lifecycle (Conceptual to logical to physical)
  • Good understanding of ETL and BI principles
  • Able to communicate with business stakeholders to capture requirements
  • Strong understanding of tuning data structures for performance
  • Ability to capture and communicate complex mappings, transformations, calculations, look ups, joins and business rules
  • Experience with Data Governance
  • Data Dictionaries, Data Glossaries, Data Catalogs, Impact Analysis, Data Lineage, Data Quality, Data Procurement and Compliance standards GDPR, CCPA, and PII


Requirements
:

  • Technologies (Select based on requirement)
  • Data modeling tools like ERWIN. ERSTUDIO and/or SQL Developer Data modeling
  • Databases - Oracle, Teradata, Postgres, SQL Server, Big Data, Snowflake, or Redshift
  • Calibra, Alation, or Informatica EDC, Axon and IDQ
  • Languages SQL, PL-SQL, T-SQL
  • J/ODBC, JSON
  • Data Governance Tools ? INFA (EDC, Axom, Secure at Source, IDQ), Calibra, or Alation
  • Data Virtualization - Design
  • Service Design - REST, Web Services
  • Data Virtualization Design - Denodo
  • Has a minimum of 7+ years of relevant data management consulting or industry experience
  • Possesses deep knowledge in Data Governance and Master Data Management
  • TalenD, SQL based ELT/ETL, Snowflake, Complex SQL Queries
  • Delivers complex data management engagements including all phases of the project life cycle from scoping and planning, requirements gathering, design, development, testing, and go live / post go live

The Capgemini Freelancer Gateway is enabled by a cutting-edge software platform that leads the contingent labor world for technology innovation. The software platform leverages Machine Learning and Artificial Intelligence to make sure the right people end up in the right job.
A global leader in consulting, technology services and digital transformation, Capgemini is at the forefront of innovation to address the entire breadth of clients’ opportunities in the evolving world of cloud, digital and platforms. Building on its strong 50 year heritage and deep industry-specific expertise, Capgemini enables organizations to realize their business ambitions through an array of services from strategy to operations. Capgemini is driven by the conviction that the business value of technology comes from and through people. It is a multicultural company of over 200,000 team members in more than 40 countries. The Group reported 2018 global revenues of EUR 13.2 billion.