Location: Malvern, PA

Client: Capgemini

Tools and Skills (must have)

Erwin
SQL
Experience on working with relational and other databases.
Documentation using Confluence, Sharepoint
Collibra
Deep understanding of Datawarehouse, Datamart and Data lake Good Data Profiling skills
Hands on experience with AWS databases - such as HIVE, Redshift, and Aurora.
Deep understanding of OLTP and OLAP system
Deep understanding of Dimensional Modelling, Star schemas, Snowflake schemas
Good understanding of ETL VS ELT