ETL test lead/Â ETL tester Resume

SUMMARY

8 Years of IT experience in the field of ETL testing (Data Warehousing testing), Big data Testing and Report testing
Very well knowledge in domains such as insurance, communication, Healthcare and Banking & Finance Services
Proficient in writing Complex SQL Queries and procedures in Oracle PL/SQL, MS SQL Server 2012, Teradata, Netezza and Hive
Well - versed with concepts of extract, transform, and load (ETL) processes, including capturing, reporting, and managing data from diverse sources
Have development knowledge in ETL tools such as Informatica 9.x and Cognos
Experience in analyzing large amounts of data sets using Hadoop, Hue & Hive queries
Worked in methodologies like Waterfall and Scrum Agile methodologies
Excellent Leadership and interpersonal skills and capable of work independently or in a team
Possess a great Analytical Skills to identify the root cause for the failures
Have good exposure in Test cases preparation and reviews, Test plan preparation, Test data preparation, Test Summary Preparation, Test Dashboard Preparation, Test Estimations and Defect management
Possess a good communication skill to convey my ideas
Working as a T shape Abinitio developer in the current project and successfully created graphs on my own
Work closely with Development team and SMEs for the successful completion of the project

TECHNICAL SKILLS

Database: Oracle 11g, SQL server 2012, Netezza, Teradata 14.1, Informix and MS Access

ETL tool: Informatica 9.x, Abinitio

Reporting tool: Cognos, Tableau

Big data: Hadoop, Hive, Hue, Sqoop and Spark frame work

Job scheduler: Tivoli, Autosys, Oozie and control M work automation

Test Management tool: HP Quality Center

Agile tool: JIRA

Automation tool: Query surge and Excel macros

Scripting languages: SQL, PLSQL, T-SQL, Unix, python, Java, C and C++

PROFESSIONAL EXPERIENCE

ETL test lead/ ETL tester

Responsibilities:

Worked closely with the business for requirement understanding
Prepared the test estimates, test plan and test cases based on the requirement and got sign off after reviewing with the clients
Mocked up the own test data based on various business and technical scenarios
Prepared the test scripts in SQL or PLSQL language
Loaded the data using Workflow manager in Informatica, Graphs or control M automation tool in Abinito
Performed the test execution with below validations
Data profiling of Source data
Target table structure verification
Count validation between source and target
Duplicate check in the target
Data validation using Minus query between the source and target tables by applying all transformation logic
History capture validation such as SCD1, SCD2 and SCD3 using Lead or lag functions
Excel data comparator between Source file and target table or vice versa
Referential integrity checks across the data mart
Reconciliation validation between source and target for amount, policy or loan columns for daily, monthly or yearly
Functional validation of each table or module
Business scenario validation on target tables
Integrity validation between the columns in target tables
Regression validation for each cycle or defect fixes
Automated the regression testing using PLSQL stored procedure or Query surge automation tool
Captured the defects and test status in the HP Quality center
In Agile, every piece of work is captured as a story with the points
Triaged the identified defects with Business, Clients and Developers
Prepared the daily status report in the required format and shared it to all stake holders
Prepared the test summary report and got sign off from the stake holders before moving the code to production
Mentored the new resources joined to our project and helped them to solve the issues

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship