Aditya Bagdi
Indore,Madhya Pradesh
Summary
Experienced Data Engineer with a strong track record in defining requirements and architecting enterprise-level solutions. Adept at solving complex analytical problems through a meticulous and detail-oriented approach. Brings 3.5 years of hands-on experience working with various AWS services and is well-versed in agile methodologies. Passion for learning and staying updated with emerging technologies makes this individual a valuable asset to any team. Currently seeking a dynamic new opportunity with room for growth and advancement in the field of Data Engineering.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Data Engineer
Principal Financial Group
2021.11 - Current
- Architected and implemented comprehensive data pipeline using Agile SDLC methodology on AWS Cloud, which increased data quality and integrity by 25% and helped business meet SLAs for report delivery, improving compliance from 50% to 79%, as part of Client Content Data Modernisation Initiative.
- Designed and implemented resilient data pipelines as integral part of Data Modernisation initiative, utilising AWS services such as AWS Glue, AWS Lambda, AWS S3, AWS Step Functions, AWS SQS, Athena, AWS Lake Formation, AWS API Gateway, AWS RDS and CloudWatch, all orchestrated efficiently through AWS CDK framework.
- Led team to build Extraction Hub, product utilized by various teams to extract data from around 10 data domains, built on top of RDS, S3, DynamoDB, etc., increasing code reusability and improving performance and code quality by 30%.
- Enhanced system performance by data cleaning, implementing proper indexing strategies in database tables, and to optimise backend SQL queries for reports, resulting in significant 65% reduction in runtime of 100 reports, decreasing completion time from 1.5 hours to 0.5 hours.
- Improved code quality by 40% through implementation of unit tests using pytest library, increasing overall unit test coverage of code from 56% to 80%.
- Built CI/CD pipeline on GitHub Actions, integrating various checks including prospector, mypy, and unit test code coverage. This initiative facilitated adoption of software design best practices and improved code maintenance by approximately 50%.
- Acted as mentor to junior data engineers, facilitating their project onboarding and providing guidance to resolve technical challenges.
Analyst
Principal Financial Group
2020.11 - 2021.11
- Optimized Amazon API Gateway-driven REST APIs built on top of Amazon RDS database by implementing query string parameters, thereby reducing cost by 50%.
- Revamped 10+ Informatica ETL workflows to eliminate performance bottlenecks, rectify bugs and introduced new features aligned with business requirements and future needs.
- Identified and refactored issues in factsheet translation process, leading to substantial monthly cost savings of €45,000.
- Supported as POC for issues/bugs in client facing analytics reporting tool for delivery of 100+ factsheets.
Android App Development Intern
EngineerBabu
2019.05 - 2019.06
- Worked on Health Application named Fit-Shuffle which is based on subscription business model
- Developed functionality of application using JAVA and XML
- Created UI for app involving use of fragments, bottom navigation, drawer, view pager, recycler view, card view, expandable listview etc
- Raised approximately 25 bugs which after got fixed improved user experience.
Education
Bachelor of Engineering in Information Technology - Information Technology
SGSITS
Indore09.2020
Skills
- AWS Services - Glue, Lambda, S3, Athena, Step Function, API Gateway, RDS, Dynamodb, Lake Formation, SQS, SNS, EventBridge, Cloudwatch, IAM etc.
- Python - Pyspark, Pandas, Numpy, sqlalchemy, Boto3 etc.
- SQL
- Aws-cdk
- CI/CD - Azure Devops, Github Actions
- Informatica Powercenter
- ETL development
- Data Modeling
- Data Warehousing
Certification
- AWS Certified Solutions Architect - Associate, 08/2022, Present
- SQL(ADVANCED) by HackerRank, 03/2023, Present
Accomplishments
- Ace Performer
- Best Mentor
- Spot Award - 4 Times
Hobbies and Interests
- Finance and Technology
- Cricket
- Travelling
- Chess
Timeline
Data Engineer
Principal Financial Group
2021.11 - Current
Analyst
Principal Financial Group
2020.11 - 2021.11
Android App Development Intern
EngineerBabu
2019.05 - 2019.06
Bachelor of Engineering in Information Technology - Information Technology
SGSITS
- AWS Certified Solutions Architect - Associate, 08/2022, Present
- SQL(ADVANCED) by HackerRank, 03/2023, Present
Similar Profiles
ELMA VOJICELMA VOJIC
Sales Compensation Administration Representative at Principal Financial GroupSales Compensation Administration Representative at Principal Financial Group
Brad CraigBrad Craig
Assistant Vice President of Retirement Operations at Principal Financial GroupAssistant Vice President of Retirement Operations at Principal Financial Group
Nickol CrewsNickol Crews
Sr Plan Reporting - Team Lead at Principal Financial Group IncSr Plan Reporting - Team Lead at Principal Financial Group Inc