SUMMARY

• Over 7yrs of experience in IT industry as an ETL test engineer and Data QA.
• Good knowledge on Data Warehouse concepts.
• Experience in preparing Test plan, Test strategy, Preparing/Reviewing/Executing Test cases, Defect logging/tracking/analysis as per the FS.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.
• Excellent team player and excellent communication skills.
• Worked with Business Analyst to understand requirements for the purpose of generating test cases.
• Expertise in Test case management tool HPQC- 9.0/10.0, open source defect tracking tools like Jira, Bugzilla, TFS.
• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Expertise in ETL/DWH testing concepts.
• Skilled in understanding Functional requirements, designed documents, Mapping document and STLC.
• Expertise on various manual testing types like System testing, Regression testing, Functional testing, UAT testing etc.
• Experience in Healthcare and Pharma domain projects.
• Experience in using database objects like Tables, Constraints, Views, Joins etc.
• Experience in writing Ranking functions, Common Table Expressions (CTE), Temporary Tables and Table variables, Sub Queries to test the ETL process.
• Experience in developing Table, Sub Reports, Matrix Reports, Drill Down Reports, and Drill through Reports using SQL Server Reporting Services.
• Experienced in working in the onsite-offshore model as a good team member and as an individual contributor.
• Quick learner with strong problem-solving skills, interpersonal skills and a good team player

TECHNICAL SKILLS

Databases: Oracle 11g, SQL Server

Methodologies: Waterfall, Agile/Scrum

Project management tool: JIRA

ETL Tools: Informatica Power Center 10.2/10.1/9.6

Reporting Tools: Tableau 10.0

Testing Tools: HP ALM 12.0/11.0, Quality Center 10.x, 9.x

Tools: TOAD, SQL Navigator, Oracle SQL Developer

Languages and OS: SQL, PL/SQL, Win 98/2000/XP/Win-7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Database Tester/ETL Tester

Responsibilities:

• Design Test cases based on the Business requirements that address areas such as database impacts, software scenarios, Regression Testing, negative Testing, error or bug retests and usability.
• Responsible for Planning and Analysis of the project and involved in creating Test Plan, Test Scripts and Test cases.
• Analyzed and maintained requirements and created Traceability Matrix (RTM) between Requirements and Test Cases.
• Created and managed test cases and detailed test procedures for administered software tests.
• Determined acceptance criteria and recorded software test results.
• Analyzed test results and recorded and reported defects.
• Executed functional, regression, and end-to-end testing as required on GUI and Mainframe applications.
• Experience working with Agile methodology specifications
• Experience dealing with different phases of Software Development Life cycle (SDLC), methodologies and application testing processes.
• Experience working with both Manual testing and Automation testing process on different modules.
• Responsible for Smoke, Integration, Functional and System testing
• Performed End-To-End testing and Regression testing of the application as per the Agile Sprints
• Written and executed SQL queries to ensure the data integrity and to verify the updates made on the front-end Application.
• Performed database validation testing using MySQL queries.
• Participated in testing software by conducting User Acceptance testing (UAT)
• Interacted with developers and Business Analysts to resolve defect issues.
• Reviewed the ETL mappings to ensure the transformations are applied correctly. Executed the workflows in the workflow manager to start the ETL process.
• Develop automated test suites and test executions using DTF (Data Testing Framework).

Environment: ETL, Informatica PowerCenter 10.2, DTF, TOAD, UNIX, Windows10, JIRA, MS Excel, Cucumber.

Confidential - Dallas, TX

ETL QA Tester

Responsibilities:

• Thorough out the project in various iterations/Sprints - conducted system testing, integration testing, functional testing and integration testing.
• Developed 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
• Developed ETL test scripts based on technical specifications/Data design documents and Source to Target mappings.
• Extensively interacted with developers, business& management teams to understand the OPM project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Extensively used and developed SQL scripts/queries in backend testing of Databases.
• Defects identified in testing environment are communicated to the developers using Quality Center - Defects module.
• Prepared daily status reports with details of executed, passed, and failed test cases and defect status.
• Tested several complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support
• Automate the repetitive manual test cases to reduce the testing time and cost
• Running already automated test cases during test execution
• Conducting knowledge sharing workshops for offshore team to enable them
• Assisting user acceptance testing by preparing test data
• Creating QA tasks for offshore team after every sprint planning

Environment: SSIS, SQL Server, Flat Files, TOAD, SQL, PL/SQL, HP Application Lifecycle Management (ALM), QTP, UNIX, Microsoft Office Suite, Windows 7.

Confidential, Chicago, IL

Data Warehousing Tester

Responsibilities:

• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports
• Validated the data in the reports by writing simple to complex SQL queries in the transactional system.
• Managed multiple projects and schedule the timelines for testing process for entire data warehousing projects.
• Executed the Test cases for Crystal Reports and Cognos
• Performed segmentation to extract data and create lists to support direct marketing mailings and marketing mailing campaigns
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata.
• Oversaw the historical loads in UAT and PROD environments.
• Also worked on Integration of all the processes in UAT/PROD.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency
• Experience in Data Inspection/analysis of tables as well as outbound files (data files in EBCIDIC & ASCII format)
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Verified layout of data files and control file entries as per business requirement.
• Based on the generated test data wrote test cases to demonstrate testing approach with detailed explanation of the cases for SORs.(System Of record)
• Did Unit Testing for all reports and packages
• Tested the entire data reconciliation process for multiple source and target systems
• Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh, Impromptu scheduled reports, Backup and recovery maintenance.
• Involved in creating the test data for generating sample test reports before releasing to production.
• Wrote complex SQL scripts using joins, sub queries and correlated sub queries.
• Provided input into project plans for database projects providing timelines and resources required.
• Maintained the data integrity and security using integrity constraints and Data base triggers
• Involved in the application tuning of database by identifying the suitable Indexes
• Extensively used Informatica power center for extraction, transformation and loading process.
• Tested analytical reports using Analysis Studio

Environment: ETL, Informatica Power Center, DTF, TOAD, UNIX, Windows 7, Cucumber, JIRA, MS Excel