Summary
Overview
Work History
Education
Skills
LinkedIn
Languages
Accomplishments
Timeline
Generic

Sandhya K R N

Data Engineer
Bangalore

Summary

Highly skilled Software Developer and Data Engineer with 3.4 years of experience in developing and implementing efficient, results-driven solutions. Specializing in Core Python, data integration, mapping, and transformation, strong track record in designing and optimizing ETL processes that ensure seamless data flow across systems. Strong proficiency in SQL for complex querying, data manipulation, and database optimization, along with foundational expertise in data analysis to support insightful decision-making. Experienced in managing and integrating large datasets from multiple sources, I ensure data integrity and consistency throughout the process.

Overview

10
10
years of professional experience

Work History

Data Engineer

Q2
Bengaluru
03.2022 - Current
  • Company Overview: A financial services organization offering a wide range of products and services
  • Evaluated data files from external vendors for ETL pipeline compatibility, ensuring data integrity across the extraction, transformation, and loading stages.
  • Developed and implemented data mapping and customizations using Python based on specifications from Business Analysts, improving data accuracy by 20% and reducing processing time by 30%, ensuring seamless integration with business requirements.
  • Incorporated additional files from financial institutions (FIs) into the migration pipeline, ensuring seamless integration by processing and aligning the supplemental data with existing systems for accurate and efficient migration.
  • Developed an efficient ETL process with Python GUI tools, enhancing data integration into the company's platform.
  • Loaded transformed data into company platform, achieving seamless integration through automation.
  • Resolved technical issues to ensure smooth system operation and meet functional requirements.
  • Performed comprehensive validation of the data loaded into the platform's user interface (UI) and web interface, cross-checking it against predefined data standards, and expected values.
  • Handled client interactions through Salesforce to oversee data migrations and troubleshoot complications.
  • Engaged in client calls to verify data accuracy.
  • Familiar with key AWS tools such as EC2, S3, Lambda, and RDS, and capable of leveraging these services to optimize infrastructure and improve performance.

Data Engineer

MassMutual on the payroll of People360D Consulting Private Ltd
08.2021 - 02.2022
  • Company Overview: A financial services organization offering a wide range of products and services
  • Collaborated with the project team to comprehend the overall development plan, business requirements, and assigned modules for data migration
  • Migrated data from Teradata to Vertica, handling both historical data (one-time load) and delta data (daily incremental loads), ensuring seamless data transfer and transformation
  • Designed and developed SQL tables and queries in alignment with the mapping documents provided by data analysts, ensuring the accuracy of data structures and transformations
  • Performed unit testing of SQL code to validate logic, and ran regression tests to verify that the migration process met business and technical requirements
  • Identified and resolved issues in daily delta job failures, troubleshooting SQL queries and resolving data inconsistencies to ensure uninterrupted data loading
  • Implemented changes to SQL code and migration logic based on evolving business requirements and ongoing feedback from data analysts
  • Automated the data loading process using Jenkins, enabling scheduled and consistent daily loads
  • Ensured that SQL code and data migration processes adhered to database standards, including implementing Slowly Changing Dimensions SCD Type 1 and Type 2 techniques for historical data management
  • A financial services organization offering a wide range of products and services

Mathematics & Computer Science Lecturer

Sri Krishna Polytechnic College
06.2015 - 06.2018
  • Company Overview: An educational institution providing polytechnic education

Education

M.Sc. - Mathematics

Sri Venkateswara University
Tirupati
07-2014

M.Sc. - Computers

S.V. University
Tirupati
06.2012

Skills

  • Python
  • Jira
  • GIT
  • PySpark
  • SQL
  • Sales Force
  • AWS
  • Hadoop

LinkedIn

www.linkedin.com/in/krnsandhya

Languages

Kannada
First Language
English
Advanced (C1)
C1
Telugu
Proficient (C2)
C2
Hindi
Upper Intermediate (B2)
B2

Accomplishments

  • B.Sc Computer Science Gold Medalist
  • COA team award 2022

Timeline

Data Engineer

Q2
03.2022 - Current

Data Engineer

MassMutual on the payroll of People360D Consulting Private Ltd
08.2021 - 02.2022

Mathematics & Computer Science Lecturer

Sri Krishna Polytechnic College
06.2015 - 06.2018

M.Sc. - Mathematics

Sri Venkateswara University

M.Sc. - Computers

S.V. University

Similar Profiles

CREATE PROFILE
Sandhya K R NData Engineer