SUMMARY

• 11+ years of IT industry experience in Software Testing.
• Experience as ETL Test Lead in Data warehouse testing, with full system development lifecycle experience, including designing, developing and implementing test plans, test cases and test processes fueling swift corrective actions, significant cost savings and fault - free audits
• Experience working with ETL Tool: IBM Infosphere DataStage Enterprise Edition 8.1/8.5/11.5
• Experience working in Agile Methodologies such as Scrum and Kanban
• Experience in HP Quality Center & Jira XRay for Test Management tool.
• Experience in Automation of Test cases by creating rules in iCEDQ Automation tool
• Experience in Data Migration Testing, DB2 software upgrade and ETL software upgrade Testing
• Experience in Test Data Management, Data Analysis, Data Validation, Data Cleansing, Data verification and identifying data mismatch
• Experience in DB2 using Toad 6.5
• Experience in writing various sql's based on the mapping provided by the Business Users
• Experience in Testing txt,csv,flat files, XML files
• Experience in Unix OS commands and shell scripting for scheduling and, file manipulation using PuTTY
• Experience in running the jobs in Controlm
• Designed and developed complex jobs, from varied transformation logic using different stages like Transformer, Lookup, Filter, Aggregator, Join, Merge, Funnel, Sort, Change Capture and many more.
• Dealt with SCD Type1/Type2 loads
• Extensive experience in Designing and Debugging Parallel jobs and job Sequencers.
• Knowledge in designing Star Schema and Snowflake Schema in implementing
• Experience in troubleshooting of jobs and addressing production issues like data issues, environment issues, performance tuning and enhancements.
• Knowledge of Erwin to reverse-engineer and refine business Data Models
• Strong Experience in End to End Functional Testing, Regression Testing, Integration Testing, Unit Testing and User Acceptance Testing
• Experience in co ordinating with offshore teams
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and work as a part of a team as well as independently.

TECHNICAL SKILLS

Technology: Data Warehousing and Business Intelligence

ETL Tool: IBM Infosphere DataStage Enterprise Edition 11.5

Databases: DB2, Oracle, SQL Server,Sybase

Scheduling Tools: Control-M

Automation Tool: iCEDQ, UFT

Tools: and Utilities: TOAD,Putty, JIRA, XRay HP Quality Center, SOAP, Hadoop,Impala

Programming: Shell Scripting, selenium,C, C++, Java, Groovy

Platforms/OS: Windows, UNIX

PROFESSIONAL EXPERIENCE

Confidential

ETL Test Lead

Responsibilities:

• Participate in Agile Sprint Planning, Daily scrum, sprint review and sprint retrospective meetings
• Coordinate with business and development team and identify the scope and impact of the changes to various downstream
• Coordinate with offshore resources and manage the work deliverables
• Validate data from the data sources through each step of extract and transformation process including final load in data warehouse
• Develop and review test plan and test cases
• Write sql scripts to extract data from various databases and system and compare against data warehouse
• Automate test effort using ICEDQ ETL automation tool
• Validating Design document, DDL's, Data model, data mapping & Report logic to ensure it meets the business requirements and data warehouse standards
• Perform Data preparation, SIT & UAT validation and production data validation
• Perform root cause and trend analysis to identify recurring patterns of errors
• Perform impact analysis and provide estimation

Confidential

Senior Tester

Responsibilities:

• Performed requirement analysis, prepared test plan & Test cases.
• Co-ordinating with offshore team on the deliverables
• Implemented and supported in-sprint test automation support for all projects
• Helped the team to remove impediments related to Test Automation, Continuous integration
• Conducted Test Plan/Test Case walkthroughs with Project Stakeholders/ Product teams
• Delivered detailed QA testing reports to project stakeholders
• Defect Management in JIRA and conducted Defect triage meetings
• Conducted scrum meeting with off-shore team and provide latest status update to on-site team
• Conducted User Acceptance Testing
• Timely tracking of tasks and user stories using JIRA

Confidential

Associate QA

Responsibilities:

• Learned SQL and through self-paced learning and performed Data Migration testing
• Performed Cross-browser testing
• Involved in User Acceptance Testing
• Provided detailed project status reports to stakeholders on a weekly/ monthly basis
• Conducted peer reviews and motivated team to perform Ad-hoc testing on the projects
• Conducted Test Plan/Test Case walkthroughs with Project Stakeholders/ Product teams

Confidential

Entry Level/Software Engineer QA

Responsibilities:

• Started as an Entry level trainee in Cognizant and promoted as software Engineer. worked as part of software development team as a QA engineer migrating Client/ Server application to a web portal.
• Involved in Requirement Analysis, Design discussions
• Involved in Test Plan/ Test Case preparation
• Identified quality defects and received appreciations from client managers
• Delivered quality QA artifacts