SUMMARY:

• Over one year of Experience as QA Engineer in Manual and ETL testing in banking domain.
• Expertise in entire Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC).
• Good understanding of Agile software development lifecycle and strong knowledge in working with Waterfall and Agile (Scrum)
• Proficient in Analyzing Business Requirements, Design Specifications, Use Cases, User stories, Product and Sprint backlogs, Prototypes and Design documents to prepare Test Plans, Test Cases, and Test Scripts.
• Extensive experience in Smoke Testing, Functional, UI Testing, Database Testing, Browser Compatibility, Performance Testing, API Testing, Regression and System Integration Testing (SIT), Backend testing.
• Proficient in raising/coordination of Defect reporting and monitoring the status using HP Quality Center ALM defect tracking tool.
• Extensive experience in ETL/ Data warehouse backend testing and BI reports testing
• Experience in analyzing the error caused to failure of the ETL load with reference to the log file generated by Informatica Power Center and report them to the corresponding team to get it rectified.
• Good experience in understanding ETL logics and perform ETL code validations.
• Hands on experience in interacting with DBA team to set up QA and UAT environment.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging, conducting defect triage, coordination with development team on defect fixes and verification of fixed bugs.
• Proficient in performing ETL , BI , backend manual testing .
• Adept in writing SQL scripts/ PL SQL required for testing various ETL and backend processes
• Hands on experience in interacting with onsite and offshore teams.
• Proactive and initiative versatile team player with proven problem-solving abilities
• Worked on multiple projects and conducted daily stand up meetings with offshore team of multiple projects.
• Experience in using bug reporting tools like JIRA to track test progress, execution and deliverables.
• Ability to work individually and in team coordinating and resolve issues with team of SME’s and stakeholders.
• Experience in working within PUTTY and UNIX environment to check the sources files and running ETL batches.
• Dynamic person with strong ability to learn new skills. Excellent interpersonal, technical and communication skills. Willing to work whatever assigned.

TECHNICAL SKILLS:

Programming Languages: C, C++, JAVA.

Defect Tracking Tools: HP QC ALM, JIRA

ETL Tools: Informatica Power Center

Databases: Oracle 12c/11g/10g, MySQL, SQL Server

Database Tool: Toad, SQL Developer, MS Access, DENODO

Operating Systems: Windows 7 & 10, UNIX/Linux, MAC OS

Versioning Tool: SharePoint, SVN

IDE: Eclipse, Dreamweaver

Other Tools: MS Office, Putty, WinSCP, VEdit, Notepad++

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, AZ

Quality Analyst

Responsibilities:

• Worked in highly dynamic environment with sprint teams using Agile (Scrum) SDLC methodology.
• Involved in Communication with business analysts, scrum master, development team and the stake holders for Sprint Planning, Epic Stories, handling the Sprint Backlogs and defect management.
• Documented the validation rules, error handling and test strategy of the mapping.
• Analyzed and reviewed ETL (Informatica) mappings to understand the technical implementation of the business rules.
• Tracked the defects using HP ALM tool and generated defect summary reports.
• Testing ETL data feeds from various data sources to ware house .
• Explaining the requirement and coordination with offshore on daily basis.
• Performing pre (sanity) check on source data to make sure the source is proper.
• Compared the actual result with the expected results. Validated the data by reverse engineering the Informatica ETL code i.e. backward navigation from target to source.
• Created temporary tables for validations after understanding the transformation logic. To compare with the data loaded by ETL process.
• Tested several UNIX shell scripting for File validation and file processing.
• Established and documented ETL QA standards, procedures and QA methodologies.
• Involved in testing data reports. Written several complex SQL queries for validating the front-end data from backend.
• Tuned the complex SQL queries for better performance.
• Worked with DBA team to data refresh in QA environment and set up environment for testing.
• Conducted back to back meetings with developers and BSA team (Business System Analyst / Data Analyst) to discuss on all open issues.
• Conducted test case reviews to ensure scenarios accurately capture business functionality.
• Worked with ETL Source System and Target System (ETL Mapping Document) for writing test cases and test scripts.
• Written several SQL statements to confirm successful data transfers between source and target.
• Executed SQL queries to perform backend database testing and verify/modify user data.
• Have done PPV (post production validation) on entire dataflow after project deployment in Production.

Environment: ETL Informatica, Oracle, Toad, SQL developer, UNIX, Putty, WinSCP, JIRA, PL/ SQL, XML, HP QC ALM, Windows, VEdit, QTP.