We provide IT Staff Augmentation Services!

Etl Tester Resume

Irving, TexaS

SUMMARY

  • 9+ years of experience in IT industry and currently working as a Data Warehouse & ETL and BI Report Tester at Confidential
  • Worked closely with software developers/project owners and BAs to develop and execute test suites in all phases of the software development cycle.
  • Good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture, tools and testing
  • Developed test strategy, test plan/design, execute test cases and logged the defect for the ETL & BI systems.
  • Strong database experience in Oracle 10g/11g/12c, SQL Server, IBM DB2 and Teradata, extensive Backend Testing by developing, modifying, and executing SQL queries for data validation and data verification on database
  • Developed and executed detailed ETL related functional, performance, integration and regression test cases and documentation
  • Strong in ETL data validation developed by multiple ETL tools such as DataStage/Informatica /Ab - initio/SSIS
  • Worked with Program Managers, Requirement Analysts, Mappers, Developers, and other testers to resolve issues with requirements/mapping transformations
  • Created UNIX shell scripts to access and move data from production to development environment
  • Planned, documented and tested extensive data integration process with Oracle PL/SQL, Stored procedures, Functions, and Triggers on financial security reference data
  • Implemented white and black-box test efforts and analyzed requirements for software design, development, and validation.
  • Experienced in leading a team of 7 (3 Onshore + 4 Offshore)
  • Good at management and multitasking skills, which help in conducting project meetings, reviews, walkthroughs, and customer interviews according to the varied needs of the people involved.

TECHNICAL SKILLS

ETL Tools: DataStage / Informatica / Ab-initio / SSIS

Testing Tools: Toad/PL SQL developer/SQL Plus, Q-Test, Perfecto, Version One, Azure, TFS, Lean kit, Squids, KANBAN, HP Quality Centre ALM, HP Quick Test Professional 11.0

Language: SQL, PL/SQL

Script: Unix Scripts

Back End: Oracle 12c, DB2, Teradata, Netezza

Processes: Agile

Packages: MS Office: Excel (Formulas), Word, Access, PowerPoint

PROFESSIONAL EXPERIENCE

Confidential - Irving, Texas

ETL Tester

Responsibilities:

  • Actively contributed in requirements gathering and analyzing the Business requirements
  • Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
  • Validated the data files from source to make sure correct data has been captured to be loaded to target tables
  • Tuned ETL Oracle procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
  • Developed test data to introduce additional reports, reverse engineer data models to the business meaning, and instruct users on the account management and implementation process advantages derived from the system.
  • Experienced in automating ETL testing processes

Confidential

ETL Tester

Responsibilities:

  • Participated in all meetings planned for release and obtain necessary technical automation requirement. Such meetings include, design review, test execution timeline
  • Direct interaction with clients on daily basis and resolve issues
  • Identified, defined and completed all testing deliverables and milestones for one or more simultaneous technical projects
  • Closely worked with data management team to get test data for the required tests
  • Created test plans & test scripts, executed test scripts, and generated test report
  • Performed data validation testing with SQL queries. Tested ETL batch processing using UNIX
  • Worked on data mapping, warehousing tools, unit testing, process documentation and data mapping.
  • Verified DB elements using SQL queries - Involved in Functional and Regression testing
  • Exposure to Automation of ETL testing processes

Confidential

ETL Tester

Responsibilities:

  • Created test plans & test scripts, executed test scripts, and generated test report
  • Validated the data files from source to make sure correct data has been captured to be loaded to target tables
  • Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
  • Developed SQL Stored Procedures and Queries for Back end testing.
  • Hands-on experience in preparing Regression test suite

Hire Now