Summary
Overview
Work History
Education
Skills
Timeline
Generic

Naveen Yadav Anaboina

Hyderabad

Summary

Overall 12 years of experience in the IT industry as a Software Engineer, specializing in Oracle PL/SQL, SQL, and ETL development using Informatica PowerCenter (9x/10x), Informatica Cloud (IICS), and Oracle and Snowflake databases. Led and managed Data Engineering teams responsible for end-to-end data engineering processes including data modelling, ETL design, development, automation, testing, and creation of data marts. Played a key role in large-scale data warehouse projects, including successful migration from Oracle to Snowflake and automation of validation processes. Hands-on experience in handling complex data integrations, including source files with multiple delimiters, and implementing slowly changing dimensions (SCD Types I, II, and III) for maintaining historical and incremental data. Strong knowledge of USA Healthcare domain, having worked extensively in projects involving Payer, Provider, Clinical IT, Pharmacy Benefits, Membership & Eligibility, and Claims. Proficient in data warehousing concepts, PL/SQL programming, and creating DB objects such as Tables, Views, Materialized Views, Indexes, and Sequences. Experienced in using advanced Informatica transformations like Filter, Router, Aggregate, Lookup, Joiner, and Update Strategy. Actively participated in Agile methodology across projects—contributed to sprints, peer reviews, sprint demos, and ensured continuous integration testing of workflows. Developed technical design documents, source-to-target mappings (STM), and unit testing documents; conducted extensive unit testing and debugging to ensure high data quality. Provided mentorship and conducted knowledge-sharing sessions for team members and new joiners, ensuring consistent project execution and cross-training. Strong ability to learn new technologies quickly, demonstrated through ongoing training in Azure Data Factory and integration tools like Workato, and an overall focus on automation and optimization of data pipelines. Excellent communication skills, capable of clearly conveying both technical and functional concepts to stakeholders at all levels. A dependable team player and quick learner, with a proven track record of meeting tight deadlines and delivering under high-pressure environments.

Overview

11
11
years of professional experience
1
1
year of post-secondary education

Work History

Lead Data Engineer

Concentrix Catalyst
11.2020 - Current

Data Engineer

Concentrix
10.2020 - 06.2023
  • Led a Data Engineering team responsible for automating ETL workflows and validating data pipelines to ensure high data quality and timely availability for reporting and analytics.
  • Designed and implemented data integration solutions using Informatica Cloud (IICS), ingesting data from Salesforce, MySQL, Oracle, and SQL Server into target systems for centralized processing.
  • Played a key role in the migration of the enterprise data warehouse from Oracle to Snowflake, ensuring accuracy through automated validation processes and reconciliation techniques.
  • Built and maintained scalable workflows to handle data ingestion, transformation, and load operations across multiple systems, improving operational efficiency and reducing manual interventions.
  • Acted as an administrator for both IICS and Snowflake, managing user roles, monitoring performance, and ensuring the reliability of automated data jobs.
  • Worked closely with business analysts to understand reporting requirements and translated them into data models and data marts, supporting BI and financial analytics teams.
  • Developed reusable testing frameworks to validate ETL logic, schema changes, and end-to-end data flow between source and target systems.
  • Provided mentorship to junior engineers on ETL standards, performance tuning, and best practices in cloud data integration and testing.

Senior Software Engineer – A3

UST Global Pvt Ltd
11.2019 - 10.2020

Senior Software Engineer

UST
11.2019 - 10.2020
  • Company Overview: Dell is US based computer technology company that develops, sells, repairs, and supports computers and related products and services.
  • Worked on design and development of ETL Process using Informatica Power Centre 10.1.
  • End to end implementation of code and involved in Requirement gathering, design, Unit testing and Deployment.
  • Prepared the design documents and involved in preparing STM (Source to Target column mapping sheet).
  • Involved in creating the DB scripts (Table creation, Views, Materialized views, Indexes etc.,).
  • Created Workflows, sessions, mapping based on the requirement.
  • Performed Unit testing of Workflows and analyzed the data flow.
  • Involved in scheduling the workflow through Pmcmd command, Informatica scheduler.
  • Monitoring Workflows and Sessions using Workflow Monitor.
  • Using debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
  • Involved in deployment of ETL objects using Pmrep and Informatica Deployment tools.
  • Checking in and out the ETL scripts using SVN.
  • Reporting the daily status to manager and clients.
  • Communicating with business customers to discuss the issues and requirements.
  • Worked on Unix scripting for picking the multiple source files and merging the data into single file.
  • Dell is US based computer technology company that develops, sells, repairs, and supports computers and related products and services.

Senior Software Engineer

TCS
01.2019 - 09.2019
  • Company Overview: AVIS Car Rental Company: Avis is an American car rental company headquartered in Parsippany, New Jersey, United States.
  • Involved in creating the Workflows, Sessions, Mappings as per the requirement.
  • Involved in creating various transformations like Filter, Router, Aggregate, lookup, Update strategy transformations etc., in Mappings.
  • Scheduling the workflows and monitoring the workflow.
  • Created DB tables, Views, Materialized views, Indexes as per the poc provided.
  • Communicating with business customers to discuss the issues and requirements.
  • Prepared the design documents.
  • Involved in preparing STM (Source to Target column mapping sheet).
  • Performed Unit testing of the code developed.
  • AVIS Car Rental Company: Avis is an American car rental company headquartered in Parsippany, New Jersey, United States.

Senior Software Engineer

TCS
08.2017 - 09.2019

Senior Software Engineer

TCS
07.2017 - 10.2018
  • Company Overview: Humana is one of the largest publicly traded health benefits providers in the country with a vast network of healthcare professionals.
  • Worked on design and development of ETL Process using Informatica Power Centre 9X.
  • End to end implementation of code and involved in Requirement gathering, design, Unit testing and Deployment.
  • Experienced in understanding the requirements, S-T mappings and preparing Technical design Documents.
  • Involved in designing the data model (star and Snowflake schema).
  • Created Workflows, sessions, mapping based on the requirement.
  • Performed Unit testing of Workflows and analyzed the data flow.
  • Involved in deployment of ETL objects using Pmrep command and Uni-view Console (Scheduler).
  • Checking in and out the ETL scripts using SVN.
  • Reporting the daily status to manager and clients.
  • Involved in making the technical design document and Unit testing document.
  • Involved in Peer reviews and provided Knowledge Transfer to new joiners when required.
  • Humana is one of the largest publicly traded health benefits providers in the country with a vast network of healthcare professionals.

PL/SQL Developer

CTS
11.2015 - 04.2017
  • Company Overview: Automated Business system of Health Net is a Migration project.
  • Used SQL loader for loading data as per the requirement.
  • Created Views and materialized views as per the project requirements.
  • Written PLSQL blocks for loading data into dimensions and Fact tables.
  • Extensively used the advanced features of PL/SQL like Records, Tables and Dynamic SQL.
  • Partitioned the tables to enhance the performance.
  • Involved in Requirement Gathering. Interacted with Client to gather the Requirements.
  • Involved in Data analysis and taken a decision for proper approach.
  • Created scripts for spooling the data from database to local environment.
  • Created Procedures and Functions based on the requirements.
  • Automated Business system of Health Net is a Migration project.

Senior Process Executive – Data Analyst

Cognizant Technology Solutions
03.2014 - 04.2017

PL/SQL Developer

CTS
05.2014 - 09.2015
  • Company Overview: Med Data Group is a dynamic and fast-growing company headquartered on the North shore of Boston, Massachusetts.
  • Used SQL loader for loading data as per the requirement.
  • Creation of database objects like tables, views, materialized views, Index, Sequences.
  • Created Partition tables by range using date column to increase the performance.
  • Good knowledge on Exception Handling and writing Cursors.
  • Wrote complex SQL queries on oracle tables to pull data for analysis purpose.
  • Prepared Technical Design Documents and Unit Test Documents.
  • Med Data Group is a dynamic and fast-growing company headquartered on the North shore of Boston, Massachusetts.

Education

Master of Science - Chemistry

Osmania University
Hyderabad
01.2013 - 08.2013

Skills

Oracle 10g

Timeline

Lead Data Engineer

Concentrix Catalyst
11.2020 - Current

Data Engineer

Concentrix
10.2020 - 06.2023

Senior Software Engineer – A3

UST Global Pvt Ltd
11.2019 - 10.2020

Senior Software Engineer

UST
11.2019 - 10.2020

Senior Software Engineer

TCS
01.2019 - 09.2019

Senior Software Engineer

TCS
08.2017 - 09.2019

Senior Software Engineer

TCS
07.2017 - 10.2018

PL/SQL Developer

CTS
11.2015 - 04.2017

PL/SQL Developer

CTS
05.2014 - 09.2015

Senior Process Executive – Data Analyst

Cognizant Technology Solutions
03.2014 - 04.2017

Master of Science - Chemistry

Osmania University
01.2013 - 08.2013
Naveen Yadav Anaboina