SUMMARY

• Around 8 years of IT experience in the Analysis, Design, Development, testing and Implementation of Business Intelligence solutions using Data Warehouse, ETL, Client/Server applications.
• Extensive work experience in ETL analysis, testing and implementing ETL process in Informatica 9 and SSIS including writing complex SQL queries to evaluate the data Conditions.
• Holding valid H1B Visa
• Having experience in Hadoop - Hive data validations
• Having experience in writing HQL in Hue
• Experienced in HBASE validations
• Ample exposure on ETL tools Informatica and Query Surge.
• Worked on different ORDBMS like Teradata, Oracle and DB2.
• Worked as UAT tester and as DOC in Production support.
• Having good knowledge on UNIX, LINUX, and 3rd Party scheduling tool Control-M to run ETL jobs.
• Cross-functional experience in handling large scale delivery assignments in various domains like health care, Life sciences, Pharmacy and Banking.
• Experience in Functional Testing, Web Services API Testing, UI Testing, UAT Testing, Regression Testing, Smoke testing, Re-testing and Integration testing.
• Test case Writing, Review, Approve & Execution in HP ALM and HP QC.
• Informatica- ETL Testing using Toad and TIDAL
• Validation of Reports against data in the tables.
• Experience In using the HP QC and HP ALM tools for test management to track different activates and project status
• Ability to learn and incorporate new technologies.

TECHNICAL SKILLS:

Databases: MS SQL Server, MS Access 2000, Oracle 11i, Teradata 11, HIVE, Oracle

Methodologies: Waterfall, Agile

ETL /Reporting Tools: Informatica 9.0.1, Talend, Business Objects XI/4.0, CognosBO, QlikView10.0, Tableau

Testing Tools: HP-QTP, Win Runner, Jmeter, QC, Selenium Web drive

Data Access Tools: Teradata SQL Assistant, TOAD, SQL Navigator

Languages: C, C++, SQL, PL/SQL, VB Scripting, PHP

Operating Systems: MS DOS, Win 98/2000/XP/Win 7, UNIX, Linux, Android, IOS

Bug Trackers: Quality Center, MQC, JIRA

Web Technologies: XML, HTML, JAVA

Web Browser: Chrome, Fire Fox, Safari

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

ETL Tester

Responsibilities:

• Requirements Gathering & Understanding.
• Writing & executing test cases for ETL testing by understanding transformation rules and business requirements.
• Test data preparation to validate the File level validations, Record level validations, business rules and load process.
• Test case Writing, Review & Execution.
• Involved in Hadoop - Hive data validations / Data cleansing.
• Involved in writing HQL in Hue
• Involved in HBASE validations
• Informatica- ETL Testing using Toad and TIDAL.
• Responsible to verify Web services API request, response data validations in REST, SOAP protocols.
• Performed Web Service API testing for UI content verification and validation with business logic XML and JSON using REST.
• Validation of Reports against data in the tables.
• Writing SQL queries against database for data validation.
• Experience Conducting the Monthly Quality Audit with QR as part of Quality Control
• Experience in DD,DP, BCP,PMR activities
• Test Management with HPQC (HP ALM).
• Written Simple to complex queries to execute the test cases using sub-queries, joins, grouping etc...
• Validating the ETL processing In SQL server by querying the Dimension tables and Fact tables.
• Validation of Reports against data in the tables for sqoop jobs.
• Validation of Stage, Prep and Warehouse tables in SQL server
• Tested the Cognos/Tableau Reports.
• Conducted functional testing and regression testing
• Defect Tracking & reporting using HP ALM (HP QC)
• Prepare the lesson learned documents based on the previous defects.

Environment: Hadoop, SQL server 2008 R2/2012, SQL server Management Studio, Control M, MS Excel, .Net, TortoiseSVN, Teradata SQL Assistant, Oracle, Talend, Informatica Power Center 9.1.0, Cognos, Tableau, UNIX, Putty, Quality Center 10AnalytiX

Confidential

Software Test Engineer

Responsibilities:

• Reviewed and Analyzed business requirement documents, technical requirements and functional specification of various functionalities.
• Performed Data Validation using SQL, Defect Resolution and Maintenance.
• Involved in Hadoop - Hive data validations / Data cleansing.
• Involved in writing HQL in Hue
• Involved in HBASE validations
• Written SQL scripts to test the mappings and tested Cognos Reports
• Responsible for creating test data for validating ETL loads.
• Extensively written SQL queries to perform back end testing.
• Responsible for Automation Scripts & library functions maintenance.
• Involved in testing the ETL mappings, by validating whether the mapping adhere to the development standards and naming conventions; whether the mapping do what the technical design says it should do; whether the mapping work correctly in relation to other processes in your data logistical flow.

Environment: Informatica Power Center, Hadoop, Unix, Windows XP, HP Quality Center 10.0,QTP 9.5,Oracle 10g, Oracle SQL Developer, SQL Server, Tableau.

Confidential

Sr Tester

Responsibilities:

• Review project documentation, business requirements to prepare Mapping documents and detailed test schedules and plans.
• Involved in creating the mapping document including field to filed transformation rules from Heartbase to SQL Server.
• Validate approaches and validate the ETL loading the Database tables including net change.
• Created the test plan for Migration project from Heartbase to SQL Server and presenting it to the team.
• Creating the test plan for application testing.
• Created test data based on requirements to test the Application.
• Writing complex SQL queries for validation and data verification, Date.
• Executed SQL queries to validate the information updated in the database tables based on the test scripts.

Environment: SQL Server 2008, Informatica Power Center, Unix, Windows XP, HP Quality Center 10.0,QTP 9.5,Oracle 10g, Oracle SQL Developer, TOAD, SQL Server.

Confidential

Software Engineer

Responsibilities:

• Generated test cases as per Use cases defined in product requirement document.
• Performed complete End to End testing on the Application.
• Performed Functional, Database, Regression and System Testing on complete product.
• Performed extensive Back-End testing by writing and executing SQL queries on the database-using SQL Query Analyzer.
• Performed Manual Testing and regression testing activities for new releases as an end-to-end testing on Different platforms