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 wif UNIX commands using PUTTY Environment.
• Well versed wif 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 teh phases of Software Development Life Cycle (SDLC) methodologies such as waterfall,Agile (Scrum) and Kanban.
• Experience in providing user and halping teh business users to understand teh 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 wif Customers and End users in gathering requirements and assisting wif any needs and halped 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 teh business requirement, ETL Analysis, ETL test and design of teh flow for teh 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 teh ETL mappings, by validating whether teh mapping adhere to teh development standards and naming conventions, whether teh mapping work correctly in relation to other process in teh data logical flow.
• Tested teh 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 teh error checking and testing of teh 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 teh 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 teh USER Acceptance Test.

Environment: Informatica, Oracle, SQL

Confidential

ETL Tester

Responsibilities:

• Analyze teh Business Requirements and closely work wif teh Business Team to get teh clarifications addressed
• Run Defect Triaging and Review teh Test Scenarios/ Test Cases wif 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 teh functionality of teh 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 wif 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 wif 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 teh 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 teh offshore team for ETL Testing.
• Involved in handling teh project from creating a test id for a project till submission of exit report.
• Created test scripts based on teh 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 teh defect in-case of teh business rule violation wif teh data and assign it to teh concerned stakeholders.
• Tracked teh defects using teh Quality Center .
• Prepared test exit reports wif details of executed, passed, and failed test cases to teh senior management.
• Participated in regular project status meetings related to testing and process improvement. Compare teh flat file wif teh database content as per teh Business requirement.
• Tested teh reports built on top of teh tables in Teradata using teh reporting tool Business Objects.