Pavan Kumar Dondapati
Manchester,NH
Summary
Versatile IT professional with a proven track record as an ETL Developer (DataStage and IICS) and GCP Data Engineer, offering 10+ Years of experience in end-to-end data integration and cloud-based solutions. Adept at designing and implementing scalable ETL processes using IBM Infosphere DataStage, IICS, and developing robust data solutions on the Google Cloud Platform (GCP). Experienced in creating and optimizing data pipelines, ensuring data accuracy, and implementing batch processing solutions by following the coding standards and best practices. Proficient in leveraging GCP services such as Big Query, Dataflow, Cloud Run, Cloud Storage, and Pub/Sub. Skilled in troubleshooting and resolving issues related to ETL processes, data flow, and cloud-based data solutions. Have rich working experience in both SDLC and AGILE Methodology of Software development. Involved in all phases of the project life cycle including requirement analysis, design, coding, testing, Migration, and production support. Result oriented individual with demonstrated business insight through leadership, communication, execution, and relationship building. Extensively worked on Relational Databases Systems like Teradata, Oracle11g/10g/9i/8i, MS SQL Server. Sound knowledge of Linux/UNIX, Shell scripting. Having good knowledge of Tableau, Python, and GitHub. Extensive knowledge of Data Warehousing Concepts.
Overview
1
1
Certification
12
12
years of professional experience
Work History
Sr. Technical Associate
UPS (United Parcel Service)
03.2021
- Working as a Migration consultant and developer for Migrating from On-Prem DataStage revenue data mart to Google cloud platform GCP.
- Implemented Google BQ scripts as per data stage job functionality and that finally load the data into GCP main tables from staging layer.
- Developed UNIX wrappers script to run various BQ scripts without manual intervention.
- Write unit test cases, validate the GCP BQ table results against on-Prem database and Demo to the customer.
- Defined end-to-end process for code (peer) review, code promotions, integrating with other teams, which reduced the defects.
- Responsible for creating technical specifications, Check List Documents, Prod Hand over Doc and other
- Attending daily stand up/scrum calls to give update on the work.
- Responsible for Delivery Audits on the project.
- Design and implement data storage solutions using GCP's storage services like Cloud Storage, Cloud SQL, Cloud run.
- Collaborate with cross-functional teams and document architecture, design, and deployment processes.
- Implement cost-effective solutions and monitor resource usage to optimize costs associated with GCP services.
- Provide training to team members and share knowledge about GCP services and best practices.
- Client: UPS (United Parcel Service)
- Project Name: RDMR REARCHITECTURE & GOOGLE CLOUD MIGRATION
- Environment: Google Cloud Platform, DataStage, Unix, SQL server
Sr. Technical Associate
UPS (United Parcel Service)
06.2025 - Current
- Migrated Oracle SQL and PL/SQL scripts, stored procedures, and ETL processes to Google BigQuery while optimizing performance and scalability.
- Implemented and supported Striim Initial Load and Change Data Capture (CDC) pipelines to replicate data from Oracle legacy systems to GCP in near real-time.
- Developed and optimized BigQuery transformation logic, data validation, and reconciliation processes to ensure data accuracy and consistency across source and target systems.
- Designed and maintained Google Cloud Dataflow pipelines for large-scale batch and streaming data processing requirements.
- Developed Cloud Run services and automation frameworks for job orchestration, monitoring, file processing, and operational support activities.
- Collaborated with business, development, and infrastructure teams for solution design, testing, production deployments, troubleshooting, and production support.
- Client: UPS (United Parcel Service)
- Project Name: Oracle to Google Cloud Platform (GCP) Migration
- Environment: Google Cloud Platform (GCP), BigQuery, Striim, Dataflow, Cloud Run, Cloud Storage, Pub/Sub, Oracle Database, SQL, PL/SQL, UNIX Shell Scripting, Git, Azure DevOps, CDC.
Sr. ETL Developer
Teradata, CA
10.2018 - 07.2019
- Worked in Agile development methodology environment and Interacted with the users, Business Analysts for collecting, understanding the business requirements.
- Developed new scripts/jobs based on BRD through Linux and Informatica Cloud
- Developed ETL programs using Informatica Cloud to implement the business requirements.
- Used Informatica Cloud to load data from different data sources like xml, flat files and Oracle, Teradata, Salesforce, Rest API's
- Developed the SQL scripts for the business rules using Unix Shell.
- Used the Teradata fast load utilities to load data into tables.
- Prepared Unit-Test Cases and performing the unit testing along with validating the scenarios.
- Validate the data loaded into database & preparing the code completion documents.
- Used Postman tool to check the API response.
- Client: Teradata, CA
- Project Name: Transcend
- Environment: Informatica Intelligent Cloud Services, UNIX, Teradata SQL Assistant, Oracle, Linux, WINSCP, Shell, Microsoft SQL Server 2008, Postman
ETL Developer
Teradata, CA
01.2018 - 10.2018
- As an ETL Developer, responsible for Migrating SAP BODS Jobs into informatica cloud environment.
- Worked in Agile development methodology environment and Interacted with the users, Business Analysts for collecting, understanding the business requirements.
- Worked on building the ETL architecture and Source to Target mapping to load data into Data warehouse.
- Designed and Developed mappings, Task Flows in informatica cloud as per BODS jobs.
- Created stored procedures, views, user defined functions and common table expressions.
- Created BTEQ Scripts.
- Converted BODS Script into Windows batch Script.
- Facilitated knowledge transition to new members joining the team.
- Prepared the Test Case Document and captured the test results.
- Client: Teradata, CA
- Project: IDW Migration
- Environment: Informatica Cloud Services, Teradata 16.1, Oracle12C, UNIX, Windows Batch Scripting, SAP BODS.
DataStage Developer
State Bank of India, India
03.2017 - 01.2018
- Performance Tuning of DataStage jobs.
- Involved in status calls and involved in team meeting with team members.
- Involved in interactions with Clients for gathering the requirements.
- Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.
- Used the Data Stage Designer for importing and exporting Data Stage components from the repository.
- Involved in doing file validations.
- Involved in Preparing the Technical Design Documents.
- Prepared the Test Case Document and capturing the test results.
- Knowledge transition to new team members to project.
- Client: State Bank of India, India
- Project Name: IDSPM
- Environment: Datastage11.5, DB2& UNIX
ETL/DataStage Developer
NEW LOOK - UK
11.2016 - 02.2017
- Involved in status calls and involved in team meeting with team members.
- Involved in interactions with Clients for gathering the requirements.
- Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.
- Used the Data Stage Designer for importing and exporting Data Stage components from the repository.
- Involved in doing file validations.
- Involved in Preparing the Technical Design Documents.
- Prepared the Test Case Document and capturing the test results.
- Designed Sequencer to automate the whole process of data loading.
- Solutions to satisfy the Business need.
- Client: NEW LOOK - UK
- Project Name: Transactional Phase - 1
- Environment: DataStage 11.5, Oracle 11g/10g, Putty.
ETL/DataStage Developer
The National Bank, UK
05.2014 - 10.2016
- Involved in status calls and involved in team meeting with team members.
- Used the Data Stage Designer to develop jobs for extracting, cleansing, transforming, integrating, and loading data into Data warehouse.
- Prepared the excel sheet and job execution plan for Tivoli scheduling tool.
- Used the Data Stage Designer for importing and exporting Data Stage components from the repository.
- Performed data profiling, cleansing, and validation to ensure data quality and integrity throughout the ETL process.
- Collaborating with database administrators to optimize database performance and ensure compatibility between DataStage and database platforms.
- Provided support for production ETL processes, including monitoring, troubleshooting, and resolving issues in a timely manner.
- Client: The National Bank, UK
- Project Name: Misys business intelligence
- Environment: DataStage 8.5, Oracle 11g/10g, Putty, TWS & Unix
Education
Master of Science - Information Technology
University of New Hampshire
ManchesterBachelor of Technology - undefined
ANU
IndiaSkills
- ETL Tools: DataStage 85,113, 115, Informatica Intelligent Cloud Services
- Databases: Teradata 161, Oracle12C/11g/10g/9i/8i:80, DB2 UDB 81, MS SQL Server 2008/2005, Big Query
- Cloud Platform: GCP Cloud Storage, Big Query, Dataflows, Cloud run, Cloud Pub/Sub, Kubernetes, Load Balancer, Secret Manager
- Programming: SQL, Windows Batch Scripting, Python, UNIX Shell Scripting
- Job Scheduling Tools: Tivoli Job Scheduler, Main Frame ESP
- Other Tools: SQL for DB2, SQL Assistant for Teradata, MS Excel, GITHUB, DataStage Conversion Tool, Tableau
- Methodologies: Agile, Waterfall
Certification
- Google Cloud Certified - Professional Data Engineer (Valid through Oct 2027)
- Teradata Database Associate 16.01
Personal Information
Title: ETL/DataStage/GCP Data Engineer
Timeline
Sr. Technical Associate
UPS (United Parcel Service)
06.2025 - Current
Sr. Technical Associate
UPS (United Parcel Service)
03.2021
Sr. ETL Developer
Teradata, CA
10.2018 - 07.2019
ETL Developer
Teradata, CA
01.2018 - 10.2018
DataStage Developer
State Bank of India, India
03.2017 - 01.2018
ETL/DataStage Developer
NEW LOOK - UK
11.2016 - 02.2017
ETL/DataStage Developer
The National Bank, UK
05.2014 - 10.2016
Bachelor of Technology - undefined
ANU
Master of Science - Information Technology
University of New Hampshire