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
7
7
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
Pulivendula05-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
Senior Data Engineer
Altimetrik Pvt Ltd
10.2024 - Current
Senior Consultant
Capgemini India Pvt Ltd
09.2021 - Current
Systems Engineer
Infosys Pvt Ltd
01.2019 - 09.2021
B.Tech - Electrical And Electronics Engineering
JNTU College of Engineering
Similar Profiles
ALOK KUMARALOK KUMAR
Senior Staff -Quality Engineer at Altimetrik Pvt LtdSenior Staff -Quality Engineer at Altimetrik Pvt Ltd
MOHAN DMOHAN D
Data Engineer II at PayPal India Pvt. Ltd. (Intial 6 months as AWF from Altimetrik Pvt. Ltd.)Data Engineer II at PayPal India Pvt. Ltd. (Intial 6 months as AWF from Altimetrik Pvt. Ltd.)
Durga Bagya Nayaki KDurga Bagya Nayaki K
Staff Engineer - Quality Engineering at Altimetrik Pvt., LtdStaff Engineer - Quality Engineering at Altimetrik Pvt., Ltd
MALI BASHA SHAIKMALI BASHA SHAIK
Junior Software Engineer at Cognizant Technology Solutions India Private Ltd.Junior Software Engineer at Cognizant Technology Solutions India Private Ltd.
PAVAN KUMAR MalleboinaPAVAN KUMAR Malleboina
Senior Test Engineer II at Allstate IndiaSenior Test Engineer II at Allstate India