SUMMARY

• Overall 9+ years of experience in ETL, Functional and Big data testing on various applications with strong Technical, Domain and Functional experience
• Onsite experience in Swiss Data Hub project for Confidential, which helped in enhancing client centricity, business knowledge and leadership skills.
• Rich experience of client interaction Including communication with various stakeholders
• Good knowledge in Securities and Banking domain
• Worked as BA/QA analyst for requirement understanding, defining, analyzing and documenting requirements and providing a technical solutions
• Excellent in writing test plan, test strategy, test scenarios and test cases/SQL scripts
• Expert in activities like Estimations, Status tracking, Defect Triage, Tracking test cases through HP ALM
• Experience in working as team lead/test coordinator & mediating onsite - offshore project Delivery with teams located on multiple geographical locations
• Ability to work on multiple applications/projects at a time and adapt new technologies quickly.
• Strong ability in requirement analysis, Source to target mapping analysis
• Skilled in writing SQL, Hive queries, Unix and HDFS commands
• Expert in performing validations like count checks, Null Checks, Schema validation - Column names, data types checks and End to End ETL Testing
• Great exposure working in Agile methodology
• Skilled in CA TDM tool to generate synthetic data, subsets of data, data masking and creating gold copy as a baseline
• Familiar in automation by writing Python/Shell script for file validation
• Received various awards for individual and team contributions

TECHNICAL SKILLS

Testing Type: ETL testing, Big Data, Datawarehouse, Functional testing and Mobile testing

Test Management Tools: HP ALM, JIRA

Defect Tracking Tools: HP ALM

ETL Tool: Informatica PowerCentre, Query Surge

Process: Waterfall, Agile

Operating system: Windows 7, XP, UNIX/LINUX, iOS

Programming Language: C, VB Script, Python, Shell Scripting

Test Data Management tools: CA TDM

RDBMS/Database: Oracle, SQL server, Hive, Mainframe

PROFESSIONAL EXPERIENCE

Confidential

Senior QA/Test Lead

Responsibilities:

• Performed test planning and monitoring activities of Hadoop projects
• Managed the project releases with onsite and offshore model to conduct testing for the major releases to ensure integrity of applications
• Providing Estimations, Identify the scope and testing approach
• Understanding Incoming Data Capture and Outgoing Data Capture Requirements and raised appropriate questions timely
• Worked as BA/QA analyst for requirement understanding, defining, analyzing and documenting requirements and providing a technical solutions
• Prepared test scenarios, test cases and associated Hive Queries and also reviewed test cases of other team members
• Creating sample test data for validating transformation logic
• Validating Schema - Data Types, Primary Checks, Null checks, Count Checks, extract Validation
• Reported new problems found, debugged and provided detailed information to development
• Conducting Defect Triage meeting and sending Minutes of Meeting to track the activities and action items
• Reviewed testing execution and ensuring project deadlines and milestones were met utilizing various reporting on HP ALM
• Groom new joiners in the team with for Quality Processes and Design understanding of the Project
• Preparing Dashboard Reports and produced QA reporting deck and test closure report for project stakeholders
• Used JIRA for tracking new change requests, sprint backlogs and defect tracking
• Ensure the timely delivery of different testing milestones
• Managed the compliance requirements for Confidential projects
• Automation through python and shell scripts to do sanity/data validation
• Client appreciation on collaborative working, automation efforts and excellent execution on test activities
• Worked on CA TDM tool to generate synthetic data, subsets of data, data masking

Confidential

Senior Test Engineer/Test Lead

Responsibilities:

• Understanding the project requirements by going through Functional Specification Documents and Technical specification documents, Mapping Sheets etc.
• Analyzing Testing Requirements, Providing Estimations, Identify the Scope and testing approach.
• Prepared Test Plan, Test Scenarios, Test Cases, Lesson Learnt Documents and updating WSR reports to client.
• Creating SQL/Hive queries for test scenarios & test cases for each area of scope
• Creating sample test data for validating complex transformation logic
• Defect reporting and analysis in HP ALM.
• Conducting Defect Triage meeting and sending Minutes of Meeting to track the activities and action items
• Estimates for change requests and planning their tests.
• Used JIRA for tracking new change requests, sprint backlogs and defect tracking
• Validated Schema - Data Types, Primary Checks, Null checks, Count Checks, Extract Validation
• Validated transformation logic with reference to mapping document
• Coordinating between BA and DEV Team for defect discussion
• Excellent in co-coordinating with Upstream, downstream for upcoming plans for testing

Confidential

Test Engineer

Responsibilities:

• Understanding the business logic and the ETL Processes.
• Creating test cases for ETL mappings.
• Testing - Involved in writing manual test cases & test execution.
• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements
• Responsible for validation of Target data in Data Warehouse and Data Marts.
• Validated data in between source and target after running Control M jobs
• Handling Daily Status meetings/Calls with all groups involved in the delivery (Release management/Project Managers/Development/Business/Testing).
• Preparing Testing Timelines, test planning and strategy planning for the releases.
• Creating SQL queries for test scenarios & test cases for each area of scope
• Identifying and reporting the bugs.
• Performed mainframe application testing for data, CICS page navigation and Functional testing
• Performed mobile testing on iOS