Job Description

- Expert knowledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects.

- Design, Development, and implementation of the enterprise-wide architecture for structured and unstructured data providing architecture and consulting services to Business Intelligence initiatives and data driven business applications

- Business Process Modeling, Process Flow Modeling, Data flow modelling

- Creating ETL specification documents, & creating flowcharts, process workflows and data flow diagrams.

- Performed extensive data cleansing, data manipulations and date transforms and data auditing.

- Developed database objects like PL/SQL packages, tables, stored procedures, triggers that are used for meeting the business objectives.

- Hands on experience of working in the Cloud technologies AWS/Azure/GCP

- End to end data and analytics solutions design experience using cloud technologies- AWS S3, Spark, EMR, Data bricks, MPP databases, Redshift/Snowflake right from Ingestion to Transformation to Consumption using various methods including API delivery

Minimum Qualifications

- Over 8 years of experience in Information Technology as Data Analyst and Data Modeler with advanced analytical and problem-solving skills.

- 4+ years of experience in snowflake.

- 6+ years of experience in RDBMS (Like Teradata, oracle etc)

- Extensive experience with OLTP/OLAP System and E - R modeling, developing Database Schemas like Star schema and Snowflake schema used in relational, dimensional, and multidimensional modeling.

- Extensive experience in Relational Data Modelling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering, Publishing Erwin diagrams, analysing data sources and creating interface documents.