Vijay Ramaraju Jampana
ETL Test Engineer
Plano,TX
Summary
Highly skilled ETL Test Engineer with 6 years of experience in testing data pipelines, ETL processes, and cloud-based data platforms. Expertise in ETL tools like Talend, Informatica, and Ab Initio, alongside cloud platforms such as Snowflake, AWS Redshift, and Azure Synapse. Adept at validating data migrations, ensuring data integrity, and automating data quality processes for large-scale enterprise systems. Strong skills in problem-solving, effective communication, and teamwork, combined with a solid understanding of data models, data mapping, and financial control frameworks.
Overview
6
6
years of professional experience
1
1
Certification
Work History
ETL Tester
GE Healthcare
07.2023 - Current
- Developed test plans for Snowflake migrations, including historical and incremental loads.
- Validated DB2 and Snowflake scripts, ensuring PII compliance and role-based access.
- Manage the QA migration project by gathering requirements, creating test plans, and coordinating with teams to identify dependencies between apps and tests
- Assisted with project development phases such as requirement gathering, design, SIT, UAT, and production implementation.
ETL Tester
Frontier Communications
05.2022 - 06.2023
- Validated data pipelines for customer accounts, billing systems, service usage, and network operations as part of the data integration and transformation process.
- Implemented complex data transformations within Snowflake using SQL-based transformations for dimensional modeling and aggregation
- Integrated Snowflake with cloud ecosystems like AWS S3 and Azure Blob Storage, enabling seamless data ingestion and external stage configuration.
- Collaborated with business analysts and data architects to design scalable data models in Snowflake for Frontier’s analytics needs.
Senior Software Engineer
Capgemini
04.2019 - 08.2021
- Performed the Unit and System Testing in the legacy code and checked if the outputs are matching in both regions.
- Collaborated with LOB to identify idle jobs in Control-M, resulting in reduced system workload and shorter timescales.
- Conducted UT and ST tests in Preprod region using scrubbed data from Production.
- Resolved platform difficulties, including S3 bucket connectivity, database connectivity, SFTP, and MVS systems.
- Developed and executed detailed test cases, scenarios, and scripts to verify Snowflake-specific features, such as time travel, cloning, and virtual warehouses.
- Created the config file, Schema and SQL files which will be used as input for Spark framework to load to Snowflake Data warehouse.
Education
Master of Science - Business Analytics
University of North Texas
Denton, TX 05.2001 -
Skills
SQL, PL/SQL,Unix shell scripting,XML,JSON
MySQL, Teradata, Oracle, Sybase, SQL server, DB2
Informatica Power Center 8x,9x,10x, Informatica Intelligent Cloud Services, MSBI, Ab Initio GDE 335/3326, 2/2x, COOP 32/2x/1x, SAS BASE, SAS MACRO, SAS SQL, SAS EG and Pyspark
Agile/Scrum, Waterfall methodologies
Linux/Unix, MacOS, Windows
Certification
Oracle Certified Associate, Java SE 8 Programmer - Oracle OC1900520
Timeline
ETL Tester
GE Healthcare
07.2023 - Current
ETL Tester
Frontier Communications
05.2022 - 06.2023
Senior Software Engineer
Capgemini
04.2019 - 08.2021
Master of Science - Business Analytics
University of North Texas
05.2001 -
Similar Profiles
Khoa NguyenKhoa Nguyen
Customs Operational Leader at GE Power, GE Healthcare, GE RenewableCustoms Operational Leader at GE Power, GE Healthcare, GE Renewable
Jesus Dominguez, RNJesus Dominguez, RN
Clinical Applications Specialist at GE HealthCareClinical Applications Specialist at GE HealthCare
Navya Anna PrinceNavya Anna Prince
Software Engineer at GE HealthCareSoftware Engineer at GE HealthCare