Senior Data Specialist

• Sep 2021 - Present

Associate Consultant

• Sep 2017 - Nov 2020

• Promoted to Data Consultant position for handling agile teams and methodology. • Provided expertise in Data storage structures, Data modelling & mining and Data cleansing. • Maintained data stores with up-time of 99.9% while ingesting streaming and transactional data across. • Worked on creating Python scripts for accuracy check on quality of data in source and target systems • Implemented ETL/ELT data pipelines using SQL/Python by integrating different data sources. • Implemented CI/CD Pipelines in the project modules leveraging Code Deploy, Jenkins • Delivered BI Dashboards and Reports on Customer acquisition, operational efficiency, etc

Associate Analyst

• Dec 2016 - Sep 2017

• Worked on developing process flow to migrate data from source to on-premise or Cloud Systems. • Developed ETL pipelines on S3 parquet files on Data Lake using AWS Glue • Developed alerts/triggers on S3 bucket using AWS Lambda • Worked on data modelling by applying Dimensional and Relational concepts in on-going projects. • Completed process of Data Reconciliation successfully to ensure migration architecture is working. • Implemented normalization and de-normalization of target tables as per requirement. • Proficient in EDA (Exploratory Data Analysis), Root Cause Analysis and Impact Analysis on large datasets.

IT Analyst

• Jul 2015 - Dec 2016

• Worked on Data Processing and Storage Pipeline architectures. • Created optimal data extraction and ingestion processes for large structured and unstructured datasets. • Implemented SCD Type-2 and Constraint Based Loading in Informatica. • Developed logic to create Audit tables at each DDL operation during ETL process to keep track of updates. • Implemented Business logic by leveraging PL-SQL, Python and Unix Scripts. • Worked on version control, migration, and deployment of ETL mappings from Dev to QA and Prod environments. • Development of Transformations, Mappings and Workflows for purpose of DW creation. • Performed mappings, data clean-up and profiling using scripts and SQL Stored procedures.