SUMMARY

• Having 5+ years of experience.
• Experience in ETL Testing with extensive usage on different Databases (Teradata, Oracle SQL), ETL Tool - Informatica
• Well versed in Data warehousing Concepts and experienced in Big Data and ETL Testing.
• Good Knowledge in Agile process.
• Good Understanding of HDFS(Hadoop Distributed File System).
• Experience in Analysing Business Requirement Document (BRD).
• Well versed in writing SQL and HQL Queries.
• Performed automation testing with Unix Shell Scripting.
• Good knowledge of Defect Life Cycle and Tracking the Defects (Jira).
• Good knowledge of cloud computing tool like: AWS.
• Working experience with MS office tools like - Excel.
• Experience in writing test plans and Test cases.
• Used Agile Methodology during my test experience.
• Good experience in performing different validations like Structure, Data, Count.
• Good knowledge in ETL Testing Process and DWH concepts
• Designer, Mapping Designer, Transformation Developer, Workflow Manager and Workflow Monitor
• Extensive knowledge in mappings from varied transformation logics like Router, Aggregator, Joiner, Filter and Normalizer Transformations

TECHNICAL SKILLS

Operating System: Windows, Unix

Languages: Unix Shell Scripting, Sql, Hql, Query Surge

Database: Hive, Teradata, Oracle, Sqoop

Project Management tool: Jira, Bedrock, Putty, Winscp

ETL Tool: Informatica 9.1x

Testing Methodology: Agile

Big Data Tool: Sqoop,Hive,Pig

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester

Responsibilities:

• Preparing Test Scenarios and Test Cases.
• Performed incremental validation process.
• Validating data integrity and data correctness of the migrated data.
• Raising defects where discrepancy found in the database and reporting in the concerned team.
• Performed incremental data validation process.
• Documented test cases, test scripts and validation based on designing specifications for testing.
• Involved in test Design, Review, Defect Reporting and Tracking until it gets to closure.
• Involved in functional study of the application
• Interacting and gathering the information to understand the application and logics and resolve the issues
• Verifying the data in target database by ETL process
• Verified column mapping between source and target.
• Did extensive work with ETL testing including Data Transformation & Data Quality for various data feeds coming from source
• Maintain the Requirement Traceability Matrix (RTM)
• Reviewing and executing Test Cases
• Defect Management (Tracking and Reporting)
• Preparing & Sharing the Status Report as applicable.
• Used Unix Shell Scripting for automating the Comparison.

Environment: - Bedrock, Hive, Oracle, SQL, Jira,,HQL,Unix shell Scripting

Confidential

Responsibilities:

• Requirement Analysis.
• Preparing Test Plan and Test Strategy.
• Preparing Test Scenarios and Test Cases.
• To differentiate complex views and base views.
• To compare structure between tables and views.
• To get common records from different Tables.
• Performed incremental validation process.
• Validating data integrity and data correctness of the migrated data.
• Raising defects where discrepancy found in the database and reporting in the concerned team.
• Performed incremental data validation process.
• Documented test cases, test scripts and validation based on design specifications for testing.
• Involved in test Design, Review, Defect Reporting and Tracking until it gets to closure.
• Also prepared the weekly report for each application which was sent to the clients.
• Designed Test Scenarios (Including test data) of the Application/ETL
• Involved in Identifying Test Cases for Regression Testing as per the impact analysis report.
• Performed Build Verification (Smoke) Testing and Impact Analysis.
• Worked with Development Lead to ensure testing issues are resolved.
• Coordinated with onsite manager and delivery managers for the project release.
• Prepared & Updated Test data as per Client requirements and comments.
• Preparing Status Reports and communicated the same to Manager regularly.
• Performed DB testing with the help of database designers.
• Used Unix Shell Scripting for automating the Comparison.

Environment: Teradata, Hive, Oracle, SQL, Jira, UNIX Shell Scripting, Informatica, Winscp, Putty, Database.

Confidential

Responsibilities:

• Involved in sprint planning meeting
• Involved in functional study of the application to understanding the story cards
• Running the jobs/Workflows for ETL process
• Involved in Testing mainly ETL testing.
• Involved in developing the test cases of smoke, regression and end to end scenarios.
• Prepared and ran SQL queries to verify Dimensional and Fact tables to have correct computed values.
• Verifying the data in target database by ETL process.
• Verified column mapping between source and target.
• Involved in daily scrum meetings and updated daily status report.
• Involved in review test cases and participated in review meetings.
• Involved in execution of smoke, Regression, and end to end scenarios for each release.
• Maintain the Requirement Traceability Matrix (RTM)
• Involved in defect tracking, management and reporting activities.
• Involved in sprint retrospective meeting to prepare sprint retrospective documents.

Environment: Oracle, SQL, UNIX Shell Scripting, Informatica, Data warehouse