SUMMARY

• 6+ Years of IT experience in Requirement Analysis, Design, Code and test using ETL Tools, Hadoop Big Data,Python Scripting and Spark SQL for different sectors like Telecommunication, health care and Financial at both onsite(US and Sweden) and offshore.
• 3+ Years of experience in testing big data applications and working in Hadoop hdfs, hbase, hive,mongodb,kafka and pig. Worked on ETL Testing, Functional and Report Testing for Telecom, health care and banking domains.
• Strong experience using Defect Management Tools like Quality Center (ALM), ClearQuest,Rally,Jira for Requirement Management, Test Planning, Test Case development, Test Case execution and Defect Tracking.
• Strong knowledge of Data Warehouse concepts such as star schema, snowflake schema, dimensions, facts and slowly changing dimension types (SCD). Experienced in Preparing Defect RCA (Root Cause Analysis) and Defect Prevention Reports.
• 5+Years of strong Data warehouse ETL testing experience using Datastage,Tidal scheduler, Control - M and Informatica Power center .Wide range of database experience, using Oracle, MS SQL Server and Teradata.
• Proficient in writing and debugging SQL queries using DML commands for Back-end testing.
• Proficient in working with UNIX commands using PUTTY Environment.
• Well versed with different phases of testing like Unit Testing, Integration Testing, System Testing, Regression
• Testing, Smoke Testing, User Acceptance Testing and Web services testing.
• Strong experience in all the phases of Software Development Life Cycle (SDLC) methodologies such as waterfall,Agile (Scrum) and Kanban.
• Experience in providing user and helping the business users to understand the QA/UAT process.
• Proficient in creation and execution of Test Plans, Test Scripts and Test Cases using both Manual and Automated testing techniques.
• Ability to understand and translate Business Requirements and to operate independently or in a team environment.
• Well versed in different management scenarios like Change Control, Quality Assurance, Defect Tracking and System Integration.
• Worked very closely with Customers and End users in gathering requirements and assisting with any needs and helped clarify process related questions.

TECHNICAL SKILLS

Tool: Informatica, OBIEEE, Toad

Programming Languages: Java, XML, HTML5/CSS3

Databases: Oracle 12c/11g, SQL Server 2014/2012/2008

Frameworks: AngularJS, NodeJS, Test & Defect

Management Tools: HP Quality Center 10.0 & ALM 11.0, Bugzilla, TFS, Q TestOffice Tools MS-Word, Excel, PowerPoint, Outlook

Operating Systems: MAC, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Denver

ETL Tester

Responsibilities:

• As an ETL Tester involved in understanding the business requirement, ETL Analysis, ETL test and design of the flow for the Data warehouse project using Informatica.
• Developed test cases and scripts for ETL rules in Quality Center Test Plan. Involved in preparing detailed Business Analysis Documents, Design Documents, unit test plan for mappings.
• Tested ETL mappings to extract and load data from different databases such as Oracle, SQL Server and Flat files and loaded them in to Oracle.
• Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions, whether the mapping work correctly in relation to other process in the data logical flow.
• Tested the ETL data movement from Oracle Data Mart to SQL data mart on an incremental and full load basis.
• Validation of ETL mappings/builds as per Functional specification and technical mapping documents.
• Validate, Transform & Load (ETL) Specifications (Source to target and Business rules).
• Developed Test Plans, Test Cases for end to end testing using Python,Pytest,Chispa,Pandas and Spark SQL.
• Involved in the error checking and testing of the ETL procedures and programs in Informatica session log.
• Developed ETL test scripts based on technical specifications/Data Design Documents and Source to Target mappings.
• Developed data quality test plans and manually executed ETL and BI test cases. Involved in data warehouse testing by checking ETL procedures/mappings.
• Performed Transformations, cleaning and filtering based on mapping document on imported data and loaded in to target system.
• Performed Regression testing on new builds, every modification in the application. Conducted backend testing in QTP by inserting database checkpoints.
• Participated in workflow migration from development to QA and UAT environment as required.
• Responsible complete manually testing of the USER Acceptance Test.

Environment: Informatica, Oracle, SQL

Confidential

ETL Tester

Responsibilities:

• Analyze the Business Requirements and closely work with the Business Team to get the clarifications addressed
• Run Defect Triaging and Review the Test Scenarios/ Test Cases with Business Review Business requirement for different Specialty center modules and provide Test estimation to project management
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Developed Test Cases for Deployment Verification, ETL Data Validation and Report testing, front end user interface testing.
• Created Test Scripts in SOAP UI and Restful for Testing Web Services
• Planning for Test Execution activities to accomplish tasks on daily/weekly basis
• Actively participate in review meeting including Functional Spec, Test Plan and Test Case.
• Worked with end users to generate UAT scripts and to successful completion of UAT testing Reached Testing Goals by doing Data Completeness, Data transformation, Data Quality, Performance and Scalability
• Expertise with System Testing, Functional Testing, Regression Testing.
• Performed browser compatibility testing, performed front end web application testing and verified and validated defects using SQL to retrieve data from database.
• Tested ETL mappings that transfer data from Oracle source systems to the Data Mart Working experience on daily status reporting & managed end to end testing

Environment: ETL Informatica 9.5, Oracle 11g, SQL, PL/SQL, MS Office Suite, HP ALM 11.0,Jira, Unix, Windows, Cognos

Confidential

ETL Tester

Responsibilities:

• Onsite Test Lead coordinating the offshore team for ETL Testing.
• Involved in handling the project from creating a test id for a project till submission of exit report.
• Created test scripts based on the Functional specification. Verify Functional Data Warehouse (DW) analysis & design documents.
• Developed Test Plans, Test Cases.
• Managed and conducted System testing, Integration testing, Regression, and Database testing. Raise the defect in-case of the business rule violation with the data and assign it to the concerned stakeholders.
• Tracked the defects using the Quality Center .
• Prepared test exit reports with details of executed, passed, and failed test cases to the senior management.
• Participated in regular project status meetings related to testing and process improvement. Compare the flat file with the database content as per the Business requirement.
• Tested the reports built on top of the tables in Teradata using the reporting tool Business Objects.