SUMMARY

• Over 6 years of IT experience the field of IT with focus on QA and testing of ETL & Business Intelligence solutions using Data Warehouse Design,Big Data Technologies, ETL, OLAP, Client/Server applications
• Extensive experience in the Information Technology industry, involving analysis, SQL, Automation, ETL and BI testing of DWH applications and reporting applications.
• Extensive Experience in Agile Methodology and waterfall methodologies of SDLC.
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts and Test Scenarios
• Experienced in testing requirements that were developed in ETL and BI tools and reviewed scripts for positive and negative test scenarios, and prepared test summary reports.
• Experience in both Manual and automation testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, and Quality Center
• Possess extensive experience performing Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration and User Acceptance Testing.
• Hands on experience in testing soap UI and xml web service interfaces and running basic UNIX shell scripts using Putty in winscp server for data transfer between upstream to downstream interfaces.
• Well experienced in writing complex SQL queries for extracting data from multiple tables.
• Experience in Performance Tuning of SQL and Stored Procedures.
• Excellent experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
• Proficient in Quality Center for Test Designing, Requirement Mapping, Reports and Defect Tracking.
• Created ETL test data for all ETL mapping rules to test the functionality of the ETL process based on mapping document. Hands on expertise in Data warehousing concepts and tools.
• Extensive experience working with ETL tools like DataStage, Informatica, AB Initio, SSIS, and AutoSys tools.
• Good experience in SSRS, Microstrategy, Cognos & Business Objects Reports testing.
• Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling
• Proficient in Rational Clearquest and Quality Center for Defect Tracking
• Experience in Dimensional Data Modeling using Star and Snowflake Schema and working with slowly changing dimensions Type I II and III.
• Knowledge of writing Hive Queries to fine tuning using Hive Query Language.
• Good Exposure on Map Reduce programming, PIG Scripting, HiveQl, scripts for Data Analysis and ETL purposes and also extended the default functionality by writing User Defined Functions (UDFs) for data specific processing.
• Experience in using Sqoop to get data from HDFS to Relational Database Systems and vice-versa
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels

TECHNICAL SKILLS

ETL Tools: Informatica, SSIS, Abinitio

Databases: Oracle 11g/10g, MS SQL Server 2008/2005, DB2

Big Data Tools: hive, Pig, MapReduce, Sqoop

BI/OLAP Tools: Cognos 8, Business Objects 4

Languages: SQL, PL/SQL

Tools: Toad, SQL Loader, SQL Developer, SQL Server Management Studio

Operating Systems: Windows, AIX, Sun Solaris, Linux

Testing Tools: HP ALM/ QC, JIRA

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester Lead

Responsibilities:

• Extensively involved in building Test Strategies, Test Plans, Test Scripts, Test Execution, Requirement Traceability Matrix, Defect Tracking and Reporting for Data Warehousing and Reporting Capabilities.
• Involved in developing Test Strategies and Test Plans including Functional Testing, Regression Testing, Negative Testing, Deployment Testing, Smoke Testing, End-to-End Testing, ETL job execution (Tivoli) Testing, and Error Handling Testing.
• Deployed DataStage jobs and executed the jobs through DataStage director.
• Worked with SOAP UI for sending request and receiving responses.
• Test the FHIR (Fast Healthcare Interoperability Recourses) framework, so that, it aligns with the BCBSA Standards
• Reviewed requirements with Business and was involved in meetings for requirement elicitation.
• Has Experience of working in agile Scrum environment.
• Reviewed the test cases and test results with business for approvals
• Supported in production deployment of code
• Test Java code for webservices
• Written complex SQL Queries involving joins and Subqueries
• Has good knowledge of ETL schemas (Snowflake and Star Schema)

Quali Test

Confidential, Naperville, Illinois

Responsibilities:

• Involved in Test Plan creation, Test case execution, Requirement trackability matrix (RTM) creation
• Involved in running and debugging of infomatica workflows
• Involved in writing SQL to validate data between source and target table
• Used SQOOP for data load and used hive for data validation
• Conduct smoke test for verify the environment
• Performed Functional, Regression and sanity test as part of daily activities
• Performed load testing by creating a bulk load and dumping it against the system
• Performed performance testing for the jobs
• Regularly compared and validated impacted extracted files between different environments.
• Performed spot check data between source, data warehouse and Data Mart schemas wherever applicable.

Environment: Infomatica, Tivoli, Agile-Scrum, ALM 12.5, HDFS, Hive, SQOOP, UNIX, CSV, SharePoint, Cognos, SOAP UI

Confidential

ETL Tester

Responsibilities:

• Extensively involved in building Test Strategies, Test Plans, Test Scripts, Test Execution, Requirement Traceability Matrix, Defect Tracking and Reporting for Data Warehousing and Reporting Capabilities.
• Involved in developing Test Strategies and Test Plans including Functional Testing, Regression Testing, Negative Testing, Deployment Testing, Smoke Testing, End-to-End Testing, ETL job execution (Control-M) Testing, and Error Handling Testing.
• Demonstrated full familiarity with the concepts of dimensionally modeled data warehouses & slowly changing dimensions including the ability to write complex SQL queries against such a model.
• Worked with operations team to coordinate the build of the testing environment for the initiative.
• Assisted in gathering the business requirements, ETL Analysis, ETL test and design of jobs and the logic for the Data warehouse project.
• Validated several Cognos reports.
• Reviewed and tested business requests for data and data usage.
• Experienced in data definitions and mapping, assisting in testing exercises.
• Tracked all testing results for management, categorizing issues and created/distributed trouble reports and managing defect listings in ALM.
• Developed, modified and debugged scripts in Automation framework using QTP for future release.
• Involved in Extracting, Transforming and Loading ETL of data to target warehouse database.
• Extensively used Aggregator, Transformer, Merge, Filter, Lookup, Copy, Funnel stages.
• Coordinated with Business Users and Business Systems Consultants to understand the Business requirements to source data from Origination Systems.
• Extensively involved in comparing impacted tables in different environments and validated foreign-key tables.
• Regularly compared and validated impacted extracted files between different environments.
• Performed spot check data between source, data warehouse and Data Mart schemas wherever applicable.
• Conducted smoke test in different environments for PMF, MRA, FIMS and IDEA Cognos applications.
• Involved in daily production support for the Production Data Warehouse and optimization for better performance.
• Executed HiveQL statements for data validation to check data integrity, error handling, data redundancy, and data consistency.
• Written complex HiveQL statements for data reconciliation including comparing record counts between source data, data loaded to the warehouse and rejected records
• Demonstrated advanced skills in SQL, UNIX, Control-M and ETL.
• Extensively involved with offshore team on Server Migration.
• Escalated risk and issues in time.
• Successfully executed all active FEP Digital eXperience (DX) Control-M job schedules sing Control-M and Co>Op 3.2.7 patch 10 while connected to DB2 10.5 on PureApp.
• Successfully executed all active FEP Digital eXperience (DX) web services using CO>Op 3.2.7 Patch 10 while connected to DB2 10.5 on PureApp.
• Successfully executed all active non-DX FEP Control-M job schedules using Control-M v9 and Co>Op 3.2.7 Path 10.
• Ensured that AB Initio ETL programs executed within the job schedules produced the same results using Co>Op 3.1.7 and Co>Op 3.2.7 Patch 10.
• Compared and validated the data loaded into DB2 10.5 using Co>Op 3.1.7 and Co>Op 3.2.7 Patch 10 in to DW, MRA, CAE, FIMS, BHI, RAE, DXS and ODS schemas.

Environment: DataStage 11.5, DB2 10.5, Control M V9, AB Initio, Agile-Scrum, ALM 12.5, IBM Rational Clearquest (Web Client 8.0.1.7), Tivoli, Tableau, UNIX, CSV, SharePoint, Cognos.

Confidential, New York

QA - Database

Responsibilities:

• Developing test scenarios, test cases and executing them.
• Backend testing of newly developed ETL processes and reports by writing SQL queries and also using MS Excel to compare data.
• Assigned task to all testing team members.
• Acted as the single point of contact between development and testers for iterations, testing and deployment activities.
• Extensively used SQL programming in backend and front end functions, procedures, packages to implement business rules and compliance.
• Organized and conducted internal training on various feeds.
• Validate production data in the backend tables related to the reports for data completeness and data correctness and generate an excel report with the discrepancies found on daily basis through below activities:
• Writing SQL queries and executing them in TOAD.
• Data comparison between source and target was done using MS Excel.
• Performing end to end testing once the individual processes were tested.
• Testing ETL processes that use flat files as source and generate flat files in UNIX environment using UNIX commands.
• Publisher-Subscriber process testing by comparing the data in source tables to the generated XMLs and finally to the target tables using SQL.
• Front end testing of the PEGA derived applications.
• Validating the data flow between front end PEGA application and corresponding backend tables.
• Identified and resolved many application bugs and bottlenecks .
• Validating the source data for reports to find any data inconsistencies.
• Testing the reports format by generating the report in Infoview and then saving as excel.
• Validating the tickets raised by the report users and assigning them to the developers for fix.
• Raising defects, validating fixed defects and tracking defects to closure using HP Quality Center.
• Entering all the requirements in the requirements tab of the HP Quality Center and uploading test cases into test plan tab and mapping both the test cases and requirements.
• Preparing the test data and cleaning up the data in tables of lower environments for testing purposes.
• Attending daily Scrum meetings, defect review meetings, requirements understanding meetings with Business Analysts.

Environment: Informatica 9.5, UNIX, Shell Scripting, SQL, PL/SQL, HP ALM, Oracle 11g, Business Objects, TOAD, JMS Client, XML Spy, XSD, XML