Santhan Goud Gundrathi

Nandyal

Summary

Senior Data Engineer with extensive experience at Altimetrik Pvt Ltd, specializing in Python and SQL. Led successful data migration initiatives that improved performance and maintained data integrity. Collaborated effectively with cross-functional teams to deliver innovative solutions and optimize data pipelines, resulting in significant business impact.

Overview

years of professional experience

Work History

Senior Data Engineer

Altimetrik Pvt Ltd

Bangalore

10.2024 - Current

Responsible for Batch and streaming ingestions with reconcilation process along with providing End to End onboarding support
Collaborated with cross-functional teams to define requirements and develop end-to-end solutions for complex data engineering projects.
Reengineered existing ETL workflows to improve performance by identifying bottlenecks and optimizing code accordingly.
Evaluated emerging technologies and tools to identify opportunities for enhancing existing systems or creating new ones.
Ensured data quality through rigorous testing, validation, and monitoring of all data assets, minimizing inaccuracies and inconsistencies.

Senior Consultant

Capgemini India Pvt Ltd

09.2021 - Current

# Project 3: Project Name: Coca_CRM & Creative Analytics Role: Development Engineer Description: “Data Migration from Google big Query to Azure Synapse DB” The user’s web behavior on different campaigns launched across Global countries thru different websites is collected in Google Analytics which is being loaded into Google Big Query by the Google Tag manager is the raw data/source. Only the required raw data is being ingested into Azure Cloud storage, Azure Synapse Database with Azure synapse pipelines there by T-SQL queries to make the aggregated data for the extraction of business metrics on daily basis as a process of Data Engineering. Indeed, the aggregated data is used by the data scientist for the data visualization. Responsibilities: Interacted with the client directly to get the requirements of the product to be delivered. Analyzed the requirements and designing the Requirements Page. Linked the Google Analytics with the Google Bigquery Developed Purging scripts to purge the data on Azure ADLS Created the tables and Developed T-SQL scripts in Azure Synapse Database with the best optimization techniques. Built Pyspark code for Automating the QA checks. Experienced with Data Conversion, Data Quality, and Data Profiling, Performance Tuning and System Testing. Experience working with Agile, Waterfall & Hybrid data modeling methodologies. Monitored the Data quality of the daily processes and ensure integrity of data was maintained to ensure effective functioning of the departments Experience in Data transformation and Data mapping from source to target database schemas and data cleansing. Experience in performance analysis and created partitions, indexes, and Aggregate tables where necessary. Responsible for data governance rules and standards to maintain the consistency of the business element names in the different data layers.

Systems Engineer

Infosys Pvt Ltd

01.2019 - 09.2021

#Project 2: Project Name: HSBC Account : IHUB Roles : Development Engineer POD : Marketing Effectiveness POD Duration : 1.8 years Description: On-premises Customer data from different Source Systems Is ingested into GCP (Google Cloud Platform) through Juniper an Ingestion Framework. ETL is performed on GCP loaded data for business analytics purpose to grow the Organization. Here I develop the BigQuery SQL Scripts based on the requirements. Responsibilities: Followed the AGILE methodology. Analyzed the requirements and designed the Requirements Page. Responsible for creating the GCP Buckets, Datasets, Big Query tables in different layers of different BQ projects. Responsible for Ingesting the data from one dataset to different datasets through BQ Queries as a part of ELT and ETL Process. Written DDL and DML statements for creating, altering tables, and converting characters into numeric values. Responsible for the unit testing and - Integration Testing and capturing the evidence. Responsible for Walk through to Business Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions. Developed the SQL Joins, SQL queries for data retrieval, accessed for analysis and exported the data into CSV, Excel files. Support and KT to team as and when required ______Achievements_____ Appreciation from HSBC Delivery Head and POD Lead in making a defect less product.
#Project 1: Project Name: HSBC Account : IHUB Roles : Development Engineer POD : Marketing Effectiveness POD Duration : 6 months Description: On-premises Customer data from different Source systems Is ingested into GCP (Google Cloud Platform) through Juniper an Ingestion Framework. ETL is performed on GCP loaded data for business analytics purpose to grow the Organization. Here I did Data validations from End-to-End flow. Responsibilities: Following the AGILE methodology. Responsible for analyzing the requirements and to design the test plan. Responsible for designing the Test Cases. Responsible for the (SIT) System Integration Testing and capturing the evidence. Responsible for SIT Walk through to Business to get Signoff’s. Responsible for Generating the Test reports through Python Automation framework. Responsible for providing the Data Quality Assurance. Executing Functional, Regression testing when required. Participation in review and Client calls. ____Achievements____ Appreciation mail from HSBC Delivery Head and Test manager in bringing the Automation in to more reality. Certificate of Appreciation from Infosys Delivery manager.

Education

B.Tech - Electrical And Electronics Engineering

JNTU College of Engineering

Pulivendula

05-2017

Skills

Python
SQL
Pyspark
Core Java
Synapse SQL, Big Query GCP,
JIRA
Kafka
REST API development

EMR
Hive
Hadoop
Data pipeline design
Performance tuning
SQL query optimization
Git version control

Languages

languages known : English, Hindi, Telugu

Awards

Rising Star Award provided by Infosys

RNR Award provided by Infosys for providing excellent service to the client

Appreciation from Coca-Cola Client on my ability and knowledge to have been a Critical for the evaluation Of the Data product.

Disclaimer

I hereby to declare that above information is correct to the best of my knowledge. Santhan Goud Gundrathi.

Timeline