Sign in

Data Etl

Milpitas, CA
May 13, 2020

Contact this candidate


*QVidya Sagar Nattala




Professional Summary

8+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications

Solid Back End Testing experience by writing and executing SQL Queries

Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling

Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices

Expertise in designing the test scenarios and scripting the test cases in order to test the application and Test Data Management Plan.

Expert in PERL, UNIX Shell Scripting&SQL writing for several technology needs

Involved in Developing Data Marts for specific Business aspects like Marketing & Finance

Creation of test data and Automation of test cases for system and analyzing bug tracking reports

Expertise Shell Scripting experience on UNIX, Linux and Windows environment

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage

Good working experience in Oracle, Unix Shell Scripting

Extensively strong on databases including Oracle, MS SQL Server, and Teradata

Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL

Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming

Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

Technical Skills Summary

Big Data: Hadoop, Hive, GCP Big query, Sqoop, Kafka, Spark (PySpark) and Tableau.

Programming: Python, Shell scripting, Understanding of Core Java.

RDBMS: Oracle 10g &11g, Teradata and Informatica.

WIPRO TECHNOLOGIES 06/2019 – Till Date

Test Lead

Client: Kohl’s, CA.

June 2019 to Present


The scope of this project is to process sales & customer data to analyze the customer behavior (Customer 3600), offers impacts (Loyalty programs) and also to generate data for Campaign.


Develop the automation scripts using UNIX to validate Hive & PySpark applications. Coordinate with all the QA Leads to prepare automated scripts for regression testing.

Validate the webstore data application which provide Transacational data for the marketing team using Hive.

Validate the PySpark applications sourcing data from Mosaic (ecom) & Sales Hub system to generate Analytical reports of sales.

Validate the Demand, Fulfilled Sales data & Offers to analyze the various loyalty programs using Spark.

Validate incremental model for multiple databases to ingest data from GCP MySQL source to GCP bucket using Sqoop.

Validate the Pig scripts to process online transactions data.

Validate the reports in Tableau using the aggregated data to give a visual representation.

Analyze the aggregated data migrated from Hive to Big query for faster query responses for the business teams.

Worked closely with GCP DevOps, Security developers to fix environmental issues and integrate projects into GCP environment.

Worked closely with Product Owners (PO) for requirements, Jira stories and source to target mappings (STM). Analyzed STM’s based on source databases.

Environment: Google Cloud Platform (GCP), HDFS, Hive, Sqoop, Gerrit, Kafka, Linux Shell, Python, Spark, Agile and Scrum model.

Bank of America, Plano, TX Aug 2017 – Jun2019

ETL Tester

Environment: Informatica, UNIX, Hadoop/Bigdata, Oracle, Teradata, ALM/HP Quality Center, Agile, PL/SQL, Cognos


Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Highly experienced with different RDBMS and No SQL DB such as Oracle, MS SQL Server, Hadoop, MongoDB, Casandra, Talend, Teradata and MySQL

Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata

Tested data migration to ensure that integrity of data was not compromised.

Automated and scheduled the Informatica jobs using UNIX Shell Scripting

Coordinating data movement and validation with third party vendors.

Implementing ATDD Test concepts for defined User Stories.

Wrote PL/SQL stored procedures for certain data validations

Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.

Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.

Involved in testing the Cognos reports by writing complex SQL queries

Worked on issues with migration from development to testing

Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing

Writing Test Hive queries to test development algorithms in Hadoop cluster

Validated data moving from heterogeneous sources to target using Informatica

Monitored the workflow transformations in Informatica work flow monitor

Preparing manual test cases and test data for Scenarios

Developed test plans, test cases and test scripts for data validation testing.

Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.

Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools .

Experience in creating UNIX scripts for file transfer and file manipulation

Cytel, Waltham, MA Mar 2017 – Aug 2017

ETL Tester

Environment: Data Stage, UNIX, Teradata, Hadoop, Oracle, PL/SQL, ALM/HP Quality Center, Web Services, Agile, Cognos


Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.

Tested whether the reports developed in Cognos are as per company standards.

Managed and executed the test process, using Agile Methodology.

Prepared and validated several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP

Performed Pre Migration Assessment, Migration and Post Migration.

Validated data moving from different sources to target using Informatica

Prepared test data based on data mapping document.

Have experience in validating the business transformations by writing complex SQL queries.

Executing Autosys jobs and validating the source and the target files.

Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide ETL Solution using Informatica, SSIS, Data stage and Ab Initio

Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.

In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL, and Hadoop

Review each PBI with the Product Owner as part of Definition of Done.

Hands on experience in using Autosys scheduling.

Onsite/offshore coordination on daily bases.

Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.

Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.

Created UNIX scripts for file transfer and file manipulation

Identify business rules for data migration and Perform data validations.

Involved in various testing phases like Integration Testing, System Testing, Regression testing and Inactive prod testing.

Managed and reviewed Hadoop log files.

Ensure defect management activities for all bugs identified, reported and worked upon.

Draft and review test plans every sprint.

Tested several Data Stage jobs and ran on for loading purpose and checking the log files

Prepared Test Cases for the mappings developed through the tool Data Stage and executed those Test Cases

Worked with ETL group for understanding Data Stage graphs for dimensions and facts.

Assisted in promotion of Data Stage code and UNIX Shell scripts from UAT to Production.

Alta, Madison, WI Jan 2016 – Mar 2017

ETL Tester

Environment: Data Stage, Oracle, SQL, PL/SQL, UNIX, Teradata, ALM/HP Quality Center 11, TOAD, Cognos, MS Excel, Agile, XML, XSD, XSLT, XML Spy


Written extensive UNIX Shell scripting for error logging, cleanup, data archiving& job scheduling

Conducted backend testing by querying databases to synchronize testing databases and checked for data integrity and proper routing based on workflow rules at each step.

Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices

Generated the detailed Bug reports and Defects were tracked, reviewed and analyzed.

Involved in meetings to discuss the findings in the executed tests and decide the next steps.

Developed and Performed execution of Test Scripts manually to verify the expected results.

Validated that application meets requirements and functioning as per the technical and functional specifications.

Created complex SQL queries for querying data against different data bases for data verification process.

Tested new Data migration tool used in the mapping of data to new system.

Data migration of raw data to excel documents for clients

Participated in defining and executing test strategies using agile methodology.

Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.

Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.

Executed the Test cases for Cognos Reports.

Used TOAD & SQL Navigator GUI tools for Querying Database.

Interacted with the Business users to identify the process metrics and various keys dimensions and measures.

Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.

Developed complex queries to test the reports developed.

Involved in testing the XML files and checked whether data is parsed and loaded to table.

Tested the data and data integrity among various sources and targets.

Baxter Health, Chicago, IL Aug 2014 to Dec 2015


Environment:, Teradata SQL Assistant, Oracle, MICROSTRATEGY, SQL Server, ALM/ HP Quality Center, SQL, TOAD, XML, XSLT, XPath, XQuery.


Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS

Performed end-to-end testing of applications and coordinated with other teams.

Created ETL execution scripts for automating jobs

Prepared Execution procedure document format to prepare the Test cases based on mapping document.

Ensured that the mappings are correct and Conducted data validation testing

Worked with business analyst and developers in setting up test data

Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.

Extensively tested several MicroStrategy reports for data quality, fonts, headers & cosmetic

Writing complex SQL queries for data validation for verifying the ETL Mapping Rules

Extensively test the reports for data accuracy and universe related errors

Used Toad for query Oracle, SQL Assistant for Teradata and SQL Management studio for SQL Server

Used T-SQL for Querying the SQL Server database for data validation and data conditioning

Tested several dashboards and deployed them across the organization to monitor the performance

Used SQL tools to run SQL queries and validate the data loaded into the target tables

Involved in extensive DATA validation using SQL queries and back-end testing

Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures

Tested Operation Data Store process of ODS/DWL product

Used workflow manager for session management, database connection management and scheduling of jobs

Patni Computers Aug 2011 to Jun 2014

ETL Tester

Environment: UNIX Shell Scripting, Oracle, Informatica Power Center, Mercury Test Director, SQL *Loader, Cognos, SQL Server, Windows, TOAD


Assisted in creating fact and dimension table implementation in Star Schema model based on requirements

Written several complex SQL queries for validating Cognos Reports

Worked with business team to test the reports developed in Cognos

Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads

Extensively used Informatica power center for extraction, transformation and loading process

Creating test cases for ETL mappings and design documents for production support

Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files

Scheduling and automating jobs to be run in a batch process

Effectively communicate testing activities and findings in oral and written formats

Reported bugs and tracked defects using Test Director

Worked with ETL group for understating mappings for dimensions and facts

Extracted data from various sources like Oracle, flat files and SQL Server

Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document

Written complex SQL queries for querying data against different data bases for data verification process

Prepared the Test Plan and Testing Strategies for Data Warehousing Application

Preparation of technical specifications and Source to Target mappings

Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security

Written test cases to test the application manually in Quality Center and automated using Quick Test Pro

Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director

Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans

Contact this candidate