SUMMARY:

• 4 years of Manual + ETL testing experience.
• Strong experience in ETL testing using tools Informatica & Abinitio on Windows/Linux Environment.
• Competent in Test planning, Test design techniques, testing strategies, developing Tractability Matrix and Test Coverage reports.
• Possess specific experience performing Web based testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration Verification and Validation End - to-end and User Acceptance Testing.
• Proficient in Defect management including Defect creation, modification, tracking, and reporting using Quality Center.
• Expertise in Test case management tool HP ALM v11, defect tracking tools like Jira.
• Experience in BI report testing.
• Strong domain experience in Corporate Banking Technology
• Worked on multiple database servers with strong knowledge and experience in PL/SQL, SQL
• Good knowledge of Data warehouse concepts.
• Understands Data models and excels at Transformations.
• Strong identification and mitigation of existing data defects and errors.
• Superior ability to collaborate with all stakeholders.
• Solid understanding of source to target data mapping.
• Good knowledge on Testing Life Cycle, Bug/Defect life cycle, Defect tracking and management.
• Hands on experience of Autosys scheduling tool.
• Worked with Business Analysts, developers while reviewing the Business Requirement Documents and when there are enhancements in the applications. Involved in documentation in order to maintain and run scripts for future enhancements.
• Excellent problem solving, communication, leadership, analytical and interpersonal skills working in captive as well as part of team, highly effective at communicating with all levels of management and coworkers.
• Experience in transferring knowledge to team members.

TECHNICAL SKILLS:

Tracking tool: HP ALM v11,JIRA

ETL: Informatica Power Center 9.x, Abinitio

OS: Windows XP,UNIX

Programming: PL/SQL, SQL, Shell Scripting

Scheduler tool: Autosys

Database: Oracle 11g,IBM DB2

PROFESSIONAL EXPERIENCE:

Confidential

Test Engineer

• Requirements understanding with Development team & Business users.
• Designing test plan for Functional / Integration / System tests.
• To design high and detailed level test cases based on Business requirement documents and Technical Requirement documents in ALM.
• Verified data completeness and transformation rules.
• Tested referential relations and integrities of data.
• Running the autosys jobs/Workflows for ETL process for test cases execution.
• Prepared and ran sql queries to verify Dimensional and Fact tables.
• Verifying the data in target database by ETL process.
• Verified column mapping between source and target.
• Prepared test data for functional & Integration testing.
• Identified Test cases for Regression testing.
• Verified BI reports.
• Defect Analyzing and Reporting in ALM.
• Interactions with BA & Dev teams to resolve the issues.
• Status reporting, project tracking, documentation and reporting.
• To interact with the client during the Peer review, External walk through and status report calls.
• Knowledge transfer to team members.

Confidential

Test Engineer

• Understanding business requirements from BA’s.
• Coordinating with dev team for depth knowledge of application releases and for tracking the defects.
• Managing entire application to have it tested per business requirement.
• Preparation of test artifacts.
• Verified data completeness and transformation rules.
• Tested referential relations and integrities of data.
• Running the jobs/Workflows for ETL process for test cases execution.
• Prepared and ran sql queries to verify Dimensional and Fact tab les.
• Verifying the data in target database by ETL process.
• Verified column mapping between source and target.
• Performed Input Validations, User Interface Validations, Browser Compatibility testing and Navigation testing.
• Prepared test data for functional & Integration testing.
• Knowledge transfer to team members.

Confidential

Test Engineer

• Understanding business requirements from BA’s and Coordinated with dev team for depth knowledge of releases and for tracking the defects
• To Design High and Detailed level test cases based on Business requirement documents and technical Requirement documents in QC.
• Running the Jobs/Workflows for ETL process.
• Prepared SQL queries to verify the data.
• Verifying the ETL data in target database.
• Column Mapping between source and target databases.
• Reporting daily testing status report.
• Designed and Peer reviewed the test cases.
• Defect Analysis and defect Management.

Confidential

• To Design High and Detailed level test cases based on Business requirement documents and technical Requirement documents in QC.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
• Extensively used SQL queries for data validation and backend testing.
• Defect Analysis and defect Management.