Data Etl
Resume:
***** ****** *** **, ******* Narola
Alide VA 20105 ***************@*****.***
IT professional with 3 years of experience in Quality Assurance for ETL, Backend, Client/Server applications using Manual testing tools.
Summary
• Experience in testing Data warehousing Applications developed by Informatica Data Stage.
• Knowledge with all phases of software development life cycle (SDLC).
• knowledge on Hortonworks, Knowledge of Pig, Hive, Sqoop and HBASE.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software
• Worked on different ETL processes for the data ingestion module.
• Extensive experience with ETL technologies, such as Informatica.Capable of processing large sets of structured, semi-structured data and supporting systems application architecture.
• Able to assess business rules, collaborate with stakeholders and perform source-to-target data mapping.
• Expertise in scheduling, monitoring, job via UC4
• A very good team player, self-motivated, dedicated in any work environment.
• Expertise in creating Test Cases and Test Scripts based on Requirements
• Expertise in Smoke Testing, Back end Testing, Black-Box Testing, User Acceptance Testing (UAT), Functional Testing, Positive/ Negative Testing, System Testing, Regression Testing, Ad-hoc Testing, Boundary Value Testing.
• Understanding of Data Models, Data Schema, ETL and created SQL queries to perform back-end data warehousing testing.
• Experienced in Bug Reporting and Defect tracking using tools like HPALM HP Quality Center and Test Director to log and defect management.
• Experience in report data validations and cosmetic data validations which are developed in tableau
•
Key Skills:
Databases : Oracle 11g/10g/9i, Teradata, SQL Server Methodologies : Waterfall, Agile/Scrum
ETL Tools : Informatica Power Center 10.2/10.1/9.6 Reporting Tools : Tableau,
Testing Tools : Test Director, HP ALM 12.0/11.0, Quality Center 10.x, 9.x,Rally Tools : SQL Navigator, Oracle SQL Developer
Operating Systems : Win 98/2000/XP/Win-7, UNIX
Pacific Gas & Electric, San Francisco /san Ramon, CA Dec 2019- till date
ETL/QA Tester
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate cover- age of requirements and business processes
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log. Ensur- ing Data Quality, Cleansed the incoming data feeds and profiled the source systems data as per business rules using IDQ.
• Involved in testing end to end ETL Process DWH applications and used SQL Queries for data validation in ETL process.
• Performed Regression, and end to end business scenario testing.
• Validation of Informatica mappings for source compatibility due to version changes at the source
• Used HP ALM for Test Management, Defect Management
• Tested BI Reports Generated by OBIEE, Tableau
• Worked on UC4 Scheduling tool
• Wrote SQL test scripts for validating the data in the target database
• Experience with different file systems /databases like Oracle, Teradata,
• Tested complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Used waterfall testing methodology for achieving deadlines.
• Experienced in Black Box, White Box, Integration, Regression, Functional Back End Testing. Cigna healthcare, Denver, CO
Aug 2019- Nov 2019
ETL/DATA Tester
• Executed Workflows in the Test Environment in order to load the data from the source systems to the DWH
• Extensively executed SQL queries in order to view successful transactions of data.
• Responsible for Data mapping testing by writing complex SQL Queries using Query Studio.
• Involved in testing the UI applications.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail and Pivot reports.
• Extensively used ETL Informatica to load from operational system (Oracle database) and flat files into the target data warehouse.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines.
• Running SQL Query's in TOAD for counting the no of rows from the tables
• Submitted weekly bug or issue report updates to the Project Manager in the form of the QA Error Log Altumcore Technologies,GJ,India
Apr 2016 -July 2019
ETL Tester
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Working with the Development team for process improvement and release planning
• Performing backend testing of the DB by writing SQL queries to test the integrity of the application and Oracle databases.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Designed test data using MS Excel sheet, created data driven test for testing the application with positive and negative inputs.
• Involving in communication between UAT team members, business leaders.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines.
• Created, maintained and updated regression suites upon receiving new build.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used HPALM for documenting, organizing and tracking requirements. Education
Veer Narmad South Gujarat University
Bachelor of Commerce May 2015
Achievements
Udemy Certification:
1. MySQL database
2. Certified SQL Developer
3.Beginner to Advanced PL/SQL"
4.SQL Expert Certification.
5.Salesforce Certified Administrator.
Contact this candidate