Engineer Software

Phone: 408-***-****

Email: adcnbj@r.postjobfree.com

LinkedIn:

linkedin.com/in/gayathri-vavilthota-3281bba2/

Address: Dublin CA-94568.

Professional Summary

Highly productive and competent Data Quality Engineer with 9+ years of experience and 14 years of overall IT experience in Retail, Financial, Healthcare, and Telecom sectors in the areas of Cloud Computing, ETL, Data Warehousing, Big data and Data Integration. Well versed in handling multiple projects concurrently. Self-motivated with an ability to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.

Technical Skills

Microsoft Azure, GCP (Google Cloud Platform), Big data, Python, SQL, Hadoop, Hive, Informatica, DataStage, Tableau, Mainframes, Oracle, DB2, BigQuery, UNIX, Jira, GIT, SVN, Jenkins, VersionOne, Aqua Data Studio

Work Experience

Macy’s, Inc., San Francisco Bay Area 03/2011 – To Date

Sr. Cloud / Big data QA Lead

Professional experience of all the phases and methodologies of System Development Life Cycle (SDLC) including Waterfall, Agile and Scrum Methodologies.

Experience in Google Cloud technologies like BigQuery, Google Cloud Storage, Composer/Airflow, Dataproc, Dataflow etc.

Hands on experience in handling and processing ETL application with extensive knowledge of Testing and Validating Data Warehouse.

Experienced in analyzing Functional Requirement Specifications (FRS), Detailed Functional Requirements (DFR), Use Cases and System Design Specifications (SDS).

Interacted with business user to get data requirements such as list of tables, attributes, reference tables.

Proficient in Gathering Data, Test Cases/Scripts, Execution, Bug Tracking and Reporting Systems.

Good experience in writing SQL queries for Database Testing from different Databases.

Analyze, Design and Develop solutions for Critical business pain points in Decommissioning a 20 years old Application System involving handling Sensitive legacy table data, SQL Scripts, Data analysis, etc.

Experience in defect management activities like defect logging, tracking and prioritizing defects through review meetings.

Good experience in Onsite-Offshore Delivery model.

Performed all phases of testing: System, Integration, Regression, and end to end testing.

Interacted with the Business Users for user acceptance testing (UAT).

Conducted Daily Defect status and Progress meeting reports with QA team.

Wells Fargo, San Francisco Bay Area 01/2010 – 03/2011

Sr. ETL QA Engineer

Analyzed the business requirement document and the system requirement document to come up with a detailed Test Plan.

Created and executed test cases, 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.

Interacted and worked with the development teams to resolve issues observed during test execution.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Involved in creating test cases based on the requirement and giving walkthrough of those to the client.

Executed shell scripts to refresh the QA DB in order to reflect the changes made to the mapping workflows.

Tested the ETL mappings for Tables like SCD Type 1 / Type 2.

Executing test cases and verified actual results against expected results.

Blue Shield of California, San Francisco Bay Area 07/2009 – 12/2009

ETL QA Engineer

Analyzed the Source to Staging and Stage to Warehouse documents to come up with test plans for tables data validation results.

Involved in creating test cases based on the requirement and giving walkthroughs of those to the client.

Performed all phases of testing: System, Integration, Regression, and Performance testing.

Generated defect reports for project status meetings as necessary. Involved in Quality Center activities and used Quality Center for executing test cases, JIRA for logging defects, creating data warehouse test plan and handling test lab activities.

Interacted and worked with the development teams to resolve issues observed during test execution.

Participated in test case review and walkthrough meetings.

Prepared reports for project status meetings as necessary.

Public Communications Services - Los Angeles, CA 06/2008 – 07/2009

ETL Developer

Designed mapping documents and developed ETL mappings using Informatica.

Designed and developed Informatica mappings to build business rules to load data. Extensively worked on Informatica Lookup and update transformations to implement complex rules and business logic.

Maintained warehouse metadata, naming standards and warehouse standards for future application development.

Implemented Type II slowly changing dimension to keep a full history of dimensional data in the table

Wrote Unix Shell scripts to work with flat files and xml files.

Worked as a Software Engineer for Melstar Information Tech Ltd, Hyd,India 03/2006 – 12/2007

Worked as a Software Engineer for US Technology,Trivandrum, India 08/2005 – 01/2006

Education

Bachelor of Technology - Electronics and Communications Engineering, Jawaharlal Nehru Technological University, Hyderabad, India

Gayathri Vavilthota

Lead QA Engineer

Contact this candidate