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.