We provide IT Staff Augmentation Services!

Etl Lead Resume

Chandler, AZ

PROFESSIONAL SUMMARY:

  • Over 8+ years of experience in the Information Technology industry, involving analysis, both Manual and Automated testing of Client Server and Web applications.
  • Proficient in writing Test strategies, Test plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing.
  • Hands on expertise in Data ware housing concepts and tools.
  • Expertise in the ETL processes where in the organizations were using Data stage, Informatica, Abinitio and Autosys tools.
  • Extensive experience in ETL/ Data warehouse backend testing and BI Intelligence reports testing.
  • Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Blackbox, Integration Verification and Validation End to end and User Acceptance testing.
  • Experienced in Agile Methodology, Proficient in Black Box and White Box testing methodologies.
  • Created test plans and performed unit testing for the Ab Initio graphs.
  • Possess specific experience performing Regression and Functional Testing using Quick Test Professional.
  • Proficient in Mercury’s Test Director and Quality Center for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.
  • Proficient in Rational Clear Quest and Quality Center for Defect Tracking Defined and Implemented Processes and Procedures for QA Departments.
  • Expertise in writing SQL Queries using Oracle, SQL Server, and Tera Data in validating data into Data Warehouse.
  • Experienced in testing full and Incremental loads through ETL tools on different environments.
  • Expertise in Defect management, Bug tracking, Bug Reports and generating the graphs using Test management tools like such as Quality Center, MS Visual Studio and TFS.
  • Strong working experience in the Data Analysis, Data Verification and Validation of an ETL Applications using Backend/ Database Testing.
  • Experience with working tools like TOAD, MS SQL Server Management studio, Win SQL for creating and executing SQL Queries.
  • Experienced in complete Software Development Life Cycle (SDLC), Software Testing Life Cycle and Bug Life Cycle.
  • Testing ETL applications in relational databases and flat files using Informatica and involved in the report generation of BI systems using Crystal Reports.
  • Experienced in using UNIX shell scripts for automation of ETL process.
  • Experienced and good track record of testing the ETL, Data, Reporting, and End to End testing.
  • Involved in testing of Business Objects reports by executing the SQL Scripts.
  • Ability to work independently or in a team environment or in a rapid pace environment.
  • Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

TECHNICAL SKILLS:

ETL tools: Informatica 9.1/8.x/7.x, SSIS 2005, Ab Initio, Data Stage

Operating Systems: UNIX, Linux, Windows.

Database: DB2 8/7/5.1, Oracle 10g/9i, SQL Server 2008/ 2005/2000, Teradata

Scripting: Javascript, C, Shell Scripts

Programming Languages: PL/SQL, T - SQL, C, C++, Java, SQL

Utilities: MS Word, MS Excel, MS Power Point, MS Visual Studio

Bug Reporting: Quality Center, JIRA, Rational Clear Quest, Test Director, Bugzilla

PROFESSIONAL EXPERIENCE:

Confidential, Chandler, AZ

ETL Lead

Responsibilities:

  • Analyzed Business Requirements and Identified documents required for system and functional testing efforts for all test scenarios.
  • Used TOAD and SQL Plus for testing execution of ETL processes, PL/SQL procedures, and packages for business rules.
  • Developed all the necessary documents for testing like Test strategies, Test Plan which includes all test items and Test cases and User Documents etc.
  • Maintain, backup and restore the Informatica ETL repositories for the QA team.
  • Test the complete user experience for all assigned products, including input, calculations, user interface screens, payroll tax filing, quarterly reconciliation, electronic tax return filing, and tax forms printing functionalities.
  • Validated the daily and monthly reports in against the data in Oracle databases.
  • Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts.
  • Performed SQL validation to verify the data extracts and record counts in the database tables.
  • Extensively used Informatica tool to extract, transform and load the data from DB2 to Oracle.
  • Extensively worked on debugging ETL process graphs.
  • Conducted Functional testing, Regression testing, Integration testing, User Acceptance testing and Data Validation Testing.
  • Used Agile testing methodology for achieving deadlines in UAT.
  • Created Test Procedures and Test cases to perform the system testing and Regression testing.
  • Worked on generating reports using SQL and PL/SQL and on tuning SQL statements.
  • Worked closely with users and Application developers to ensure that application development meets to user’s expectations.
  • Maintained client database, working closely with team to relationship-manage customers and maximize referrals and sales opportunities.
  • Enhanced test scripts by inserting synchronization and checkpoints.

Environment: Oracle, SQL, SQL Server, Windows, Manual testing, Java, Java script, Rally, Jenkins, DB2, Data warehouse, TOAD, Quality Center, HTML, Oracle, SQL Server, Windows.

Confidential, NJ

ETL QA Engineer

Responsibilities:

  • As part of QA team, is involved in implementation of ETL best practices.
  • Tested data models and data maps (extract, transform and load analysis - ETL analysis) of the data marts and feeder systems in the aggregation effort.
  • Involved in providing production support to various Ab Initio ETL jobs and Oracle Database programs.
  • Worked on a variety of scheduling tools like Argent, Autosys and Control M.
  • Analyzed and verified the flat, Mainframe IMS and xml data using Ab Initio Data Profiler.
  • Tested various ETL process flow graphs using TOAD to meet the Business rules and Technical Requirements.
  • Divided the graphs into various phases and used checkpoints to avoid Dead locks.
  • Tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Tested the application for web functionality and verified the online modules for broken links.
  • Used Rational Clear Case to maintain the versioning and change management for the test documentary repository.
  • Extensively used Oracle/ Teradata to write SQL Queries to verify and validate the Database Updates.
  • Performed SQL validation to verify the data extracts and record counts in the database tables.
  • Developed and tested transformation functions and record formats for various input data files.
  • Identified the requirements and arranged peer reviews, walk throughs and sign off meetings.
  • Conducted weekly batch testing to in corporate changes in new builds.

Environment: ETL, Ab Initio, LoadRunner, Quality Center, Clearcase, DB2, Data warehouse, Control M, SOAP, XML, TOAD, FTP, HTTP, Pracle, JAVA, SQL, Windows, MS OFFICE, MS Outlook Express, SQL SERVER, PL/SQL, UNIX, Linux, Windows.

Confidential, CA

ETL QA Engineer

Responsibilities:

  • Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
  • Experience in ETL Data Warehousing, database testing using Ab Initio for ETL process.
  • Tested data models and data maps (extract, transform and load analysis) of the data marts and feeder systems in the aggregation effort.
  • Installation of DB2 and IBM Products and Fix packs on AIX/Linux environment and Designing and configuring Client Server on AIX platform.
  • Execute SQL queries in TOAD to validate back end information and compare it with the information retrieved from Data ware house Ab Initio.
  • Automated and scheduled the Informatica jobs using UNIX shell scripting.
  • Analyzed business rules to generate consolidated (fact/ summary) data identified by dimensions using Informatica ETL (Power Center) tool.
  • Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and source to Target Mappings.
  • Monitor security batch processing jobs in multi-platform shop via Control M and Tidal Schedulers.
  • Expertise in using Configuration Management tools like Clear Case, Clear Quest.
  • Performed version control of files using Clear Case.
  • Expertise in using Configuration management tools like Clear Case, Clear Quest.
  • Performed version control of files using Clear Case.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Automation of the job flow and scheduling the jobs in Control M.
  • Have tested several complex reports generated by Cognos, including dashboards, summary reports, master detailed, drill down and score cards.
  • Tested Cognos Reports according to the business requirements.
  • Imparted and organized training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
  • Prepared Test cases with the complete description of requirements, uploaded test cases and report results into Test Director.
  • Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
  • Participated in weekly status meetings, conducted walkthroughs, documented proceedings, and mentored new team members in test documentation and test case execution.

Environment: Oracle, SQL, Server 2005, SQL/PL SQL, Informatica, HTML, .NET, Javascript, VB script, Crystal, XML, HTML, SSIS/SSRS, QC, MS Word, Excel, PowerPoint, Outlook, MS Visio, MS Project.

Confidential, GA

ETL Tester

Responsibilities:

  • Execute SQL queries in TOAD to validate back end information and compare it with the information retrieved from Data Warehouse Ab-Initio Metadata graphs from legacy source system to target.
  • Used MS Access and Mercury Quality Center as test management tool to manage and organize Requirements Coverage, Test case management, Test Execution and Defect Management.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance testing and Data validation testing.
  • Conducted weekly batch testing to in corporate changes in new builds.
  • Automated and scheduled the Informatica jobs using UNIX Shell scripting.
  • Attended the Requirements reviews, Design reviews, Code reviews to understand the overall process flow and Source to Target Mappings.
  • Used Agile testing methodology for achieving deadlines in UAT.
  • Executed and managed test cases and reported bags in Quality Center.
  • Performed Verification, Validation and Transformations on the Input data (Text files, XML files) before loading into target database.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance testing and Data Validation Testing.
  • Used Agile testing methodology for achieving deadlines in UAT.
  • Validated data in between source and target after running Mappings by the Informatica developer team.
  • Prepared scripts, running tests, Analyzing results in Load Runner for Performance testing.

Environment: Control M, Ab Initio, Cognos, FTP Power Center, Power Plug, Power Connect, Windows, Oracle, SQL Server, Java, PL/SQL, Visual Basic, Java Script, Crystal, XML, HTML, QC, Outlook.

Confidential, NJ

ETL Tester

Responsibilities:

  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing).
  • Experience in writing System test plans, defining test cases, developing and maintaining test scripts and Documenting all phases of QA process
  • Set up and Executed FTP sessions with the remote server using Filezilla as FTP Client.
  • Responsible for System testing of Ad-Hoc Query Packages in Cognos which involved developing and execution of Ad-hoc reports and corresponding Test SQLs based on various join conditions and filters and calculations.
  • Create test plan, test cases and do the Unit testing, SIT and UAT and send them to projects lead for approval.
  • Maintained various versions of the documents generated during the project using Rational Clear Case
  • Troubleshoot UNIX and Database related problems.

Environment: ETL, Ab inito, Control M, Cognos, Performance Center, DB2, Toad, Oracle, Mainframe, MQ Series, Unix, HTML, DHTML,XML, QTP, IIS, Apache, Quality Center.

Hire Now