ETL Test Lead Resume

SUMMARY

A multiskilled, highly adaptable Information Technology professional with 11 years of experience spread across varied cutting - edge technologies, roles and domains.
Over 5 years of dynamic career reflecting experience and high performance in Requirement Analysis, Design, Mapping, and System testing of ETL jobs and implementation of Data Warehousing Systems.
Immense exposure to all stages of Software Development Life Cycle (SDLC) and Software Testing Lifecycle (STLC).
Familiar with ETL methodology for Data Extraction, Transformation and Loading process to/from various databases and files
Proficient in writing complex SQL queries for data retrieval/manipulation, SQL query tuning and performance optimization using Teradata
Proficient in Unix shell scripting, automation of processes through shell scripts and Perl.
Knowledge and Experience in Agile Scrum.
Quick learner, excellent team player, ability to meet tight deadlines.

TECHNICAL SKILLS

LANGUAGES: C, C++, Pro C, Perl, Unix shell script

DBMS TOOLS: Teradata, MS SQL Server, Oracle

DEVOPS & AUTOMATION: Jenkins, Azure, UiPath

TEST MANAGEMENT TOOLS: HP ALM, DataStage

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, UNITED STATES

ETL Test Lead

Responsibilities:

Work with the Business and development team to understand and analysis the requirements of various sourcing, extract and reporting projects in Datawarehouse.
Represent Testing team in project governance meetings and Daily Stand Up/Scrum, Retrospectives and Sprint Review sessions using Azure.
Manage and timely communicate escalations and project updates to Product Owner/Scrum Master appropriately using Azure.
Accountable for test estimates and resource allocation for assigned Projects/Sprints.
Involved in testing the risk satisfaction engine of care management and validate real time lab results data in health care.
Effectively handle time sensitive work assignments while consistently delivering high quality of work.
Process and maintain large volume of data using DataStage and Teradata.
Generate defect reports during testing and provide accurate test status to project stakeholders using HP ALM
Created test automation tools in Perl which ease SIT activities.
Responsible for maintaining and designing test scenario.
Responsible for writing and peer review of complex SQL scripts in Teradata and Oracle.
Accountable for project testing sign offs.
Identify and implement process improvement opportunities.
Manage a team of 8 offshore testers.

Confidential

ETL Test Lead

Responsibilities:

Ensured that data is processed successfully as per Business process in the Datawarehouse projects which are created in both ETL and ELT frameworks.
Run the data profiling tool for the source files and share the result with stake holders.
Written complex SQL queries to match business transformation rules for the source files which are loaded using mload scripts.
Familiar with star and snow flake schema and worked in both SCD1 and SCD2 tables.
Used DataStage director to trace the log files for any job aborts.
Created simple DataStage jobs for SIT activity if the source is a database.
Involved in end to end testing of many applications and ensured that the data is processed successfully without any truncation
Prepared Test Artifacts based on FRD and mapping documents.
Able to work independently and drive issues to closure.
Use HP ALM to log the SIT defects, execute the test cases and generate and share the defects reports with all stakeholders

Confidential

Systems Analyst

Responsibilities:

Development and maintenance of application using UNIX shell script and proc with SQL queries and stored procedure.
Coordinate with Onsite Lead and BSA for Requirement analysis, development and unit testing of Incidents.
Address production job abends and fix it.
Offshore team lead role to coordinate end to end delivery activities.
Provide training for new employees on existing system and play a role of mentor.

Confidential

Senior Software Consultant

Responsibilities:

Design and development of application and submit to client as per the scheduled hours of work
Responsible for Unit testing and System level testing for developed application.
Prepare UTP documents.
Provide training for new employees on existing system and play a role of mentor.
Coordinate with Onsite Lead for Requirement analysis, design & development of CRs.

Confidential

Senior Software Developer

Responsibilities:

Requirement Analysis, Design, development and unit testing of application.
Prepare High level, Application Design and UTP documents.
Responsible for planning, processing and performing all jobs in an efficient manner with no assistance from the supervisor
Troubleshoot the code using gdb.
Establish or expand relationships with key individuals
Ensure high quality of work products and processes
Assist others in completing their work
Maintain positive client interactions
Coordinate the team and deliverables