SUMMARY

• Sr ETL Quality Analyst with over 8+ years of data warehousing experience in building and managing various data warehouses/data marts using ETL products along with hands - on experience of SDLC methodologies and Business Process Models (BPM) like Agile (Scrum and Kanban) Modelling and Waterfall model.
• Proficient in performing ETL, BI, backend manual testing. Expert in writing SQL scripts required for testing various ETL and Data Warehouses in Agile Scrum environment.

PROFESSIONAL EXPERIENCE

Sr. ETL Tester

Confidential

Responsibilities:

• Produced Test scripts, utilities, simulators, data sets, and different programmatic test tools as needed, performing test plans.
• Recognized important domains of business risk and revised the business process.
• Allotted work to offshore team members, no the status and coordinate with QA & Project Managers.
• Generated stored procedures to verify the data acquired.
• Proficient in database query tools for Oracle, SQL, and UNIX, like TOAD and SQL Plus.
• Utilized predetermined UNIX scripts for file transfer and file manipulation as part of the Test Data arrangement.
• Conducted Functional, Integration, and Regression testing, examining ETL sessions and PL/SQL scripts for multiple feeds and multiple LOB's.
• Proficient in interpreting the Data Model in the Data Warehouse dat comprises of Dimension and Fact tables.
• Presented design direction and oversight of code development in Ab Initio, KSH, and PL/SQL.
• Examined loaded data warehouse components like ODS (Stage), EDW, and data marts tables following the jobs run.
• Test Business Objects reports for data validations and examine results with TOAD.
• Conducted additional data validation using custom SQL scripts.
• Utilized Toad to communicate with Databases.
• Implemented metadata verification, performance testing, source to target data validation, and relevant error handling in ETL processes.
• Increased production reliability by writing automated tests in Python.
• Attended regular SCRUM meetings and presented the team with test outcomes and performance enhancements required.
• Performed Data Completeness, Data Transformation, Data Quality, Integration testing, UAT, and Regression testing.
• Utilized Quality Center for generating and writing ETL Test Plans and ETL Test Cases and register the demanded results.
• Implemented Tuning of DataStage Jobs for more reliable performance.

Sr. ETL Tester

Confidential

Responsibilities:

• Wrote test scenarios and test scripts for verifying end - to-end data and source and target in ETL flow design.
• Managed the requirements traceability matrix to check every condition was met according to the established business processes and specifications.
• Cooperated with QA team on utilizing documentation criteria to generate and evaluate Test plans and test cases.
• Refreshed Stored Procedures and Functions to produce reports depending on the downstream conditions (Naming Standards, data types).
• Recorded complex SQL queries to implement data validation for RI checks for history and incremental loads.
• Verified BI reports utilizing Business Objects * Designed UNIX scripts for file transfer and file manipulation.
• Conducted backend testing for Database integrity by performing complex PL/SQL queries for verifying the data in the backend database tables.
• Participated in the testing of the source Database and the target Data warehouse to guarantee data integrity.
• Utilized TOAD, DB Artisan tools(9.0) to join to Oracle database to autanticate the data.
• Performed data validation, data comparison as per the business logic associates the source to the target.
• Performed automation testing of ETL flows using Python.
• Used QC to prepare test documents and document test outcomes, and follow the requirements.
• Generated Test Scenarios & Test Cases with the UAT Team and the Business Analysts.
• Worked with the development team depending on the mapping document to examine and sign off the ETL design document.
• Committed to Integration testing of DataStage mappings.

QA Tester

Confidential

Responsibilities:

• Administered both QA and UAT test cases and test scripts for outside and inside agents and implemented QA Testing.
• Directed walk - through with the Business Analysts and QA Managers to simplify crucial problems associated with the Business Requirement Document.
• Generated several PL/SQL stored procedures for producing a Natural Key Comparison, Surrogate Key checks between Production and Test environments.
• Engaged in testing and writing different reports and verification of the data by utilizing SQL queries.
• Examined UNIX Shell scripts to automate repeated database methods and managed shell scripts for data transformation.
• Automated commonly employed test cases utilizing QTP Extensively applied SQL and PL/SQL for data integrity examination at the backend.
• Tested and verified data from the data warehouse and transferred it to SQL Server 2005.
• Generated nested Queries and implemented data loss or truncation testing utilizing Oracle 10.g. Implemented Data Validation Testing utilizing TOAD.
• Served with the different teams for examining data quality, data integrity, data consistency, and data validation.
• Developed python script to enhance existing test automation framework.
• Verified the test outcomes with the team members and presented them with the business.
• Involved in recording bugs, fixed defects, and communicated with the UAT team to get sign-off for the application/project.
• Utilized STM- Source to target mapping document to learn ETL end-to-end flow of data in ETL design.
• Managed DataStage jobs and logged files to control the test runs. SOA testing was completed on a top-down approach basis.

Environment: SSIS, SQL Server, MySQL, Tableau, Control-M, Waterfall

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 9 / 8.6

Reporting Tools: IBM Cognos 8.1/Business Objects XI R2/R3

Database: Oracle10g/9i, SQL Server 2012 / 2005, IBM DB2, Sybase, Teradata 13 and MS-Access

Utilities: Toad, Citrix server, Oracle SQL Developer, SQL Advantage, Putty

Testing Tools: HP Quality Center 9.2 / 10 / ALM, TFS, JIRA, Clear Quest, Rational Clear Case