We provide IT Staff Augmentation Services!

Etl Test Lead Resume

New, YorK

SUMMARY:

  • Cross - industry experience in Financial, Insurance, Health, and Telecommunication in Global environment.
  • Extensive hands-on experience in each phase of Waterfall Life Cycle as well as Agile Methodology.
  • Successfully delivered top-notch applications within aggressive timeline, limited budget - on scope, on cost, on time, on quality. In-depth knowledge and experience in time management, risk management and integration management.
  • Highly organized in creating/maintaining test plan, test strategy, testing standards, testing framework (manual/automation), business requirements, process improvements, preparing and reporting test metrics, effort estimation and implementing quality assurance practices to reduce defects and improve the software product quality.
  • Extensive experience in establishing successful partnership with business users, understanding objectives, defining/clarifying business rules and functional requirements, coordinating, driving, conducting effort to ensure full testing coverage of all application functionality.
  • Proactive, reliable, dynamic, motivated, adaptive to new technologies, fast learner, friendly, well-balanced, creative, intuitive and flexible.
  • Energetic, competitive achiever who can inspire and motivate team members, successfully manage multiple priorities, and perform under pressure in a fast-paced, rapidly changing environment.
  • Good interpersonal, analytic and communication skills. Excellent team player who listens, thrives on collaborating with diversely talented team members, and integrates their divergent thoughts, opinions, and perspectives into meaningful action.

TECHNICAL SKILLS:

ETL INFORMATICA: Powercenter, ODI, Golden Gate, SSIS

Business Intelligence: OBIEE, SSRS, Tableau

Databases: ORACLE, SQL SERVER, VERTICA, TERADATA

Database Tool: SSMS, SQLDeveloper, TOAD, ERWin, Visio, SQL*LOADER

Programming Language: PL/SQL, T-SQL, Unix Shellscript, XML, VBScript

Test Management Tool: QC, JIRA, Jira Confluence, RALLY, SHAREPOINT

Methodology: AGILE, WATERFALL

OS: UNIX, WINDOWS

Utility Tortoise: SVN, WinSCP, Putty, Lync, MS Office

PROFESSIONAL EXPERIENCE:

Confidential, New York

ETL Test Lead

Environment: SQL Server, Oracle, Informatica Powercenter, SSIS, SSRS, HP ALM, Visio, SharePoint, Agile, Linux, Windows.

Responsibilities:

  • Writing complex SQL queries, stored procedure to automate data validation based on ETL mapping documents.
  • Reviewed, analyzed FDR, DD documents, developed strategies, test plans, and executed the test cases.
  • Responsible for Analysis and Execution of the pre-implemented new release.
  • Analyzed and maintained requirements and created Test Data, Traceability between Requirements and Test Cases.
  • Wrote SQL Statements to extract Data from Tables and to verify the output Data of the Reports.
  • Participated in Peer Review and bug logging using Bug tracking tool- Quality Center.
  • Work closely with business users to gather requirements, define project specifications, develop implementation and test plans for the projects & enhancements.
  • Designed, created and tested reports to meet business requirements.
  • Documented business workflows textually as well as in UML diagrams for the stakeholder review.
  • Produced the visual models for the application to create use cases, state charts, sequence diagrams and activity diagrams.
  • Documented and maintained RTM to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan.
  • Performed Data Analysis, writing SQL Queries for Testing and Troubleshooting against Data Warehouse.
  • Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
  • Maintained documentation related to difficulties, complexities and anomalies that may arise during the ETL process.
  • Ability to analyze root cause of a problem and demonstrate good sense when handing the problem over to development.
Confidential, New York, NY

ETL Test Lead

Environment: Vertica, Oracle, OBIEE, Informatica Powercenter, Tableau, Toad, Sqldeveloper, QC, Jira, TortoiseSVN, Visio, SharePoint, Agile, Linux, Windows.

Responsibilities:

  • Involved in Business analysis and requirements gathering.
  • Implemented a full-manual and automated testing framework, Testing standard, testing guidelines, test plans for Database migration, Data warehouse/ETL, BI Testing.
  • Validating data files from source to make sure correct data has been captured to be loaded to target tables.
  • Extensively used Informatica to load data from Flat Files to Vertica, Vertica to Flat Files, Oracle to Vertica and Vertica to Vertica.
  • Executing and monitoring jobs through Control-M.
  • Reviewed Informatica mappings and test cases before delivering to Client.
  • Written Test Cases for ETL to compare Source and Target data, Ensured that the mappings are correct and conducted data validation testing.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Written UNIX shell scripts for file transfers, error log creations and log file cleanup process.
  • Preparing test deliverables and updated the same to senior staff for review.
  • Handled the tasks of supporting staff in data post implementation stage and in handling project life cycle phase.
Confidential, New York, NY

ETL Test Lead

Environment: Oracle, ODI, OBIEE, SQLDeveloper, HP QC, MS Office

Responsibilities:

  • Identifying field and data defects with required information in ETL process in various jobs and mapping.
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Created the test environment for Staging area, loading the Staging area with data from multiple sources to test E2E data flow.
  • Validated the data in the OBIEE reports by writing simple to complex SQL queries in the transactional system
  • Oversaw the historical loads in UAT and PROD environments.
  • Prepared the test cases after thorough analysis of each requirement.
  • Prepared test data by modifying the sample data in the source systems, to cover all the requirements and scenarios.
  • Conducted and actively participated in reviews, walkthroughs of test cases.
  • Reviewed the ETL mappings (ODI) to ensure the transformation rules are applied correctly.
  • Performed testing for DATA COMPLETENESS, VALIDITY, UNIQUENESS, DATA INTEGRITY, DATA TRANSFORMATION, DATA QUALITY, INITIAL AND INCREMENTAL LOAD TESTS
  • Tested the entire data reconciliation process for multiple source and target systems.
  • Involved in creating the test data for generating sample test reports before releasing to production.
  • Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
Confidential, Philadelphia, PA

ETL Tester

Environment: Teradata, SQL Server, Informatica Powercenter, Golden Gate, SSIS, SSRS, OBIEE, Erwin, QC, Rally, Agile, Citrix, Windows, Linux.

Responsibilities:

  • Responsible for testing of complete life cycle of OBIEE reports, testing OBIEE repository at three layers (Physical, Business model and Presentation Layers), Interactive dashboards and drill down capabilities using global and Filters and security setups.
  • Responsible for testing Informatica mappings/mapplets using various transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with work lets & tasks and scheduling using workflow manager.
  • Reviewed, analyzed FDR, DD documents, developed strategies, test plans, test data, executed the test cases, traceability between requirements and test cases.
  • Developed test cases using design documents, use cases, and Functional Requirements.
  • Responsible for Analysis and Execution of the pre-implemented new release and version.
  • Participated in Peer Review and bug logging using Bug tracking tool- Quality Center.
  • Generated Reports, Graphs and live analysis graphs in Quality center for weekly status meeting.
  • QTP Framework design with automated mail reporting using outlook application, database connectivity, excels datasheets, custom libraries and environment files.
  • Performed analysis, assessment, task distribution, scheduling, Reporting, meeting scheduling, etc. using Outlook, MS Project, MS Power point, MS word, MS Excel.
  • Distributed or assigned tasks among Testers, other team members and Development related personnel.
Confidential, Bridgeport, CT

ETL Tester

Environment: Oracle, OWB, Waterfall, Windows.

Responsibilities:

  • Backend data validation.
  • Write test plan - encompassing test strategy, resource allocation and QA deliverables.
  • Work with project manager, business analysts and technical development team on fine tuning master project plan.
  • Responsible for creating test data for testing TSYS (mainframe) to validate the transactions occurred by web interfacing to MasterCard.
  • Major responsibility in testing area was in System, Functionality, Integration, Regression testing.
  • Help writing many SQL queries to retrieve/storing data and testing source to target data storage.
  • Responsible for testing of the application prior to release as a final part, keeping the bug trackers status maintained perfectly.
  • Involved in manual, negative, positive, system, functionality, integration, regression, back end testing during the various phases of the application.
  • Extensive hands on working with TD utilizing this tool most of the time in daily routine work.
  • Worked as Team player, involved in daily Agenda, interaction with Managers, Business Analyst, Leads and others, involved in walkthroughs, vendors meeting, testing issues and defects review meetings.

Page 6 of 6

Hire Now