Senior Data Analyst Data Engineering Modeling

Mandatory Skills

· Able to create Logical and Conceptual data models for business and functional users

· Understanding of ER and Dimensional modeling techniques like Star, Snowflake or Constellation

· Hands on experience in implementing Star Schema and Relational (Normalized including 3NF) models is mandatory

· Should have implemented physical data models for a variety of RDBMS and cloud hosted databases

· Strong understanding of different types of facts and dimensions

· Hands on experience with data modeling tools like Erwin, ER Studio, InfoSphere Data Architect (IDA)

· Strong SQL or python skills for carrying out data analysis and data profiling

· Transforming businessfunctional requirements into technical specifications.

· Capturing data mapping data transformation and business rules logic using source to target mapping templates

· Handson exposure to SQL and NoSQL databases and able to write pseudocode for ETL requirements.

· Data validation and testing using SQL or any toolbased testing methods

Nice to have skills

· Exposure to scrum master or product owner role will be desirable

· Knowledge of data processing ETL using Ab Initio SAS SSIS Python Scala Apache Spark Databricks

· Exposure to one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform

· Exposure to Data Governance projects including Metadata Management, Data Dictionary, Data Glossary, Data Lineage and Data Quality aspects.

· Experience and knowledge of one or more domains – Banking or Healthcare