SUMMARY

• Having more than 10+ years of experience in Analysis, Planning, Scheduling, Effort Estimation, Design, Development, Testing, S/W Configuration Management, Delivery activities, Team Coordination and Team Leading activities.
• Significant exposure in developing and testing Datawarehouse using ETL tool like Informatica, OBIEE, SSIS, SSRS, DVO, Hadoop, HDFS, Hive, pig, sqoop . Databases and Tools: MySQL, MS SQL Server, Oracle, DB2, Teradata, Sybase NoSQL: Cassandra
• End to End ETL Test Automation using Informatica Data Validation Output, Custom Framework using shell scripting, Platinum.
• Automating Cognos Framework Validation using unix
• Good Knowledge about Software Development Life Cycle & Software Testing Life Cycle Concepts.
• Strong at testing ETL process and ensure Data correctness and data quality as per business rules.
• Good working experience in validating Cognos reports, OBIEE Reporting and SSRS report
• Strong skills in back end testing using Complex SQL queries, generating reports to ensure data integrity and validate business rules
• Excellent Experience in End to End DW Testing - Test Plan, Test Strategy, Estimation, Communication Plan, Test Approach, Test Data Setup, Defect Tracking, and preparing Test Reports effectively
• Expertise in creating Traceability Matrix to map Test Cases with Functional and business requirements
• Talented in running Black box, White box and Grey box testing on standalone, web based client server, and N-tier applications.
• Practiced in executing Negative Testing, Integration Testing, Regression Testing, Functional Testing and Graphical User Interface Testing
• Expert in tracking tools like Clear Quest, Bugzilla and Test Management tool Quality Centre.
• Proficiency in User Acceptance Test (UAT) with good communication skill and demonstration skill

TECHNICAL SKILLS

Platforms: Windows and UNIX

Database: Oracle, DB2, Teradata and SQL Server 2005, Hive, Cassandra

Tools: Informatica, IDE, IDQ, ODI, OBIEE, SSIS, Hadoop, OBIEE, DVO, SSRS, Cognos, Hive, PIG, Sqoop, Hue

PROFESSIONAL EXPERIENCE

Business Intelligence

 RESPONSIBILITIES:

• Involved in analysis, requirement, validation, debugging and documentation of applications to satisfy the requirements of one or more user areas.
• Understand the requirements and data model from BSAs
• Responsible for validation Hadoop, Hive, PIG and Sqoop jobs.
• Responsible for Defining, documenting, and executing Cognos Report testing processes.
• Writing TD SQL Queries to Test the Cognos Reports and backend Teradata views
• Automated end to end ETL process using DVO, Unix and QTP
• Creating data driven test cases using QTP data tables.
• Written test cases to test the application manually in Quality Center and automated using QTP
• Comparing the count by using QTP executing the count queries which will fetch the total number of records.
• Comparing the data values using by Executing the value queries which fetch the actual values to be compared.
• Sending the test report once the execution and validation of table values are done, exporting the same output sheet into a particular path.

Technology and Tools:INFORMATICA , COGNOS, Oracle, UNIX, JIRA

RESPONSIBILITIES:

• Involved in analysis, requirement, validation, debugging and documentation of applications to satisfy the requirements of one or more user areas.
• Developed test Scripts that address areas such as database impacts, software scenarios, regression testing, negative testing, error or bug retests or usability.
• Works closely with client management to identify and specify complex business requirements and processes.
• Supports business with thorough data validation & verification to help business users identify gap with current business model that allows them to take right decisions.
• Wrote complex SQL queries to compare the counts and data from source to target.
• Validate Data Completeness, Data Integrity and Data Transformations by comparing source and target counts, data and data profile.
• Represented the weekly status calls, testing progress update calls, development progress update calls.
• Automated the ETL Process using Unix Shell scripting.
• Creating data driven test cases using QTP data tables.
• Written test cases to test the application manually in Quality Center and automated using QTP
• Comparing the count by using QTP executing the count queries which will fetch the total number of records.
• Comparing the data values using by Executing the value queries which fetch the actual values to be compared.

Sr ETL Test Engineer

Technology and Tools:XML,Oracle, ALM

RESPONSIBILITIES:

• Creating Test Plans, Test requirements, Test sets and raising Defects.
• Created SQL to test to validate the Data on XML file for testing purpose.
• Validating the XML file Outputs generated through different SOA services.
• Validating the different Rules applied on Input XML using SOA services against the Output XML.
• Identifying risks and issues while doing SIT.
• Making new joiners aware of all processes and quality which enables in delivering project successfully.
• Understanding existing business model and customer requirements.

Sr ETL Test Engineer

Technology and Tools:Informatica, Teradata, Cognos, ALM

RESPONSIBILITIES:

• Understand the requirements and data model from BSAs
• Analyzed application data using the SQL to identify the ETL processes
• Analyzed the Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performed Integration Testing to ensure that the ETL Process loading the data as per the documentation.
• Validate Data Completeness, Data Integrity and Data Transformations by comparing source and target counts, data and data profile.
• Verify data integrity and referential integrities
• Tested the Cognos Reports and backend Teradata views
• Track and report upon testing activities, including testing results, test case coverage, required resources, defects discovered and their status, performance baselines, etc.
• Develop Unix Shell Scripts to automate (ETL) work done and reduce manual efforts

Sr ETL Test Engineer

Technology and Tools:Hadoop, Hive, Unix

RESPONSIBILITIES:

• Comparing input Data File against source System Data to ensure the data is extracted correctly.
• Validating the data requirements and ensuring the right data is extracted.
• Validating the files is loaded into HDFS and data processing is completed
• Validating the aggregation and consolidation after reduce process.
• Validating the output file against the source file and ensuring the data processing is completed correctly.
• Validating the data in reports against the table.

Sr ETL Test Engineer

Technology and Tools:SSRS, SSIS, SQL Server

RESPONSIBILITIES:

• Understand the requirement and data model
• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Verify that data transformation from source to destination works as expected
• Validate Data Completeness, Data Integrity and Data Transformations by comparing source and target counts, data and data profile.
• Created SQL to test the proper working of SSIS ETLs and SSRS reports for testing purpose.
• Understanding existing business model and customer requirements.

Sr Testing Engineer

Technology and Tools:Unix, Oracle

RESPONSIBILITIES:

• Creating and testing Shell Scripts.
• Developing and maintaining disaster recovery guidelines, standard operating procedures, emergency response procedures, measurement, monitoring and reporting criteria.
• Writing supporting documentation as directed by the DR Architect above
• Designing & Developing automation scripts and test harnesses as appropriate to support automatic failover
• Providing weekly status report to the clients through calls and emails

Sr ETL Tester

Technology and Tools:Oracle, Unix, OBIEE, ODI, HP QC

RESPONSIBILITIES:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ELT processes
• Created SQL to test the proper working of ODI ELTs and for testing purpose.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Responsible for maintaining all the Testing environments including QA and SIT.
• Responsible all the code migrations in all the Environments including Production.
• Interacting with the developers on daily basis in order to get the certain issue resolved.

Onsite Testing Lead

Technology and Tools:Oracle, Unix, Informatica 9.5, Toad, Quality Center

RESPONSIBILITIES:

• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Performed manual testing by entering positive values, negative values, and boundary values to the application.
• Created, maintained and updated regression suites upon receiving new build.
• Performed data validation testing writing SQL queries.
• Compared SQL results with application results by writing SQL queries.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.
• Validate Data Completeness, Data Integrity and Data Transformations by comparing source and target counts, data and data profile.
• Verify data integrity and referential integrities

ETL Lead

Technology and Tools:Oracle, SQL, PL/SQL, Informatica & TOAD, UNIX

 RESPONSIBILITIES:

• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Performed Black box, Integration, Regression, Systems, and Backend testing
• Performed data validation testing writing SQL queries.
• Used SQL queries to test the migrated database for Back End Testing.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Involved in writing Shell Scripts to load and extract information from files and tested the back-end for data integrity in UNIX.

Team Member

Technology and Tools:Mercury Quality Centre, Oracle, UNIX and Informatica, Guidware Claim center

RESPONSIBILITIES:

• Wrote Test Plans, which detailed the testing scope, testing requirements, success criteria, milestones, and necessary resources.
• Transformations by comparing source and target counts, data and data profile.
• Wrote and modified required UNIX scripts and other SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases using TOAD.
• Worked on UNIX to automate the manual process using shell scripting.
• Created SQL to test the proper working of Informatica ETLs and for testing purpose.

ETL Team Member

RESPONSIBILITIES:

• Study and analysis of existing system and set an approach to load the historical data.
• Develop the design specification
• Design and develop the ETL process
• Fixing defects from HP Quality Center tool.
• Implementing Change Request (CR).
• Unit testing

ETL Team Member

RESPONSIBILITIES:

• Understanding the requirement
• Followed the instruction from lead
• Develop the design specification
• Design and develop the ETL process
• Fixing defects from HP Quality Center tool
• Implementing Change Request (CR)
• Unit testing

ETL Team Member

RESPONSIBILITIES:

• Developing and Modifying IDQ plan.
• Developing and Modifying Power Centre workflow.
• Developing and Modifying Oracle view.
• Understanding existing business model and customer requirements.
• Attending Knowledge Transfer sessions.
• Preparing the status report and sending it across the onshore team.
• Interacting with client on daily basis in order to get the certain

ETL Team Member

ROLES AND RESPONSIBILITIES:

• Handling production Issues related to data loading from source to production environment.
• Worked on PL/SQL (Oracle 9i) scripts and done automations of existing manual process.
• Worked on ETL tools like Informatica.
• Worked with Informatica transformations such as, multi joins of heterogeneous flat files, connected/unconnected lookups, routers, etc.
• Created ETL mappings using Informatica Power Centre to move information from multiple sources into a common target area.
• Worked on source and target systems like flat file and databases like Oracle.
• Migrate code to respective environments.
• Worked with Excel Programming and automated the daily status sheets.
• Worked on UNIX and aware of shell scripting.
• Identifying risks and issues.
• Responsible for doing analysis and solving the tickets.
• Daily client call for status and discussion of risks and issues.
• Understanding existing business model and customer requirement.