ETL Tester Resume

SUMMARY

Professional SummaryETL Tester/Developer wif focus on delivering results, troubleshooting/resolving problems and utilizing end - to-end project life cycle skills.
Adapt to new project environments andwork in teams and accomplish difficult tasks wifin time frames. Organized and disciplined to deliver on schedule.
Extensive experience in analysis, design, testing, implementation, maintenance, production support. Authorized to work in United States.

TECHNICAL SKILLS

Industry Experience: Healthcare, Banking

Databases: Oracle, Sybase, SQL Server, MS Access, Toad, SQL Plus

Software Tools: SQL, MS Office - Word, Excel, Access, Outlook, ALM, SharePoint, Live Meeting, WebEx

Environment: s: Informatica Power Center V9.5/10.2, Sybase, Flat Files, CA Workload Automation, Putty, WinSCP, AIX UNIX, HP ALM, Windows, 8x, DB2, Oracle 9i,Quality Center 9.2

PROFESSIONAL EXPERIENCE

Environment: Informatica Power Center V9.1/10, sql developer, Aqua Data Studio, HP ALM, Putty, WinSC

Confidential

ETL Tester

Responsibilities:

Developed Test Plan, Test Cases, Test Data and Test Summary Reports and followed Agile/Scrum process.
Prepared Traceability Matrices to track requirements wif test cases
Verified all workflows migrated to Informatica 10 from Informatica 9.1.
After running teh workflows, validated data load to target from source
Verified DB2 and Oracle are able to connect wif Informatica 10 ETLs
Checked table properties, constraints, indexes, sequences for critical tables
Materialized views are converted as tables in Oracle, verified whether those tables are working fine as per Materialized views
Documented and reported defects during Testing process
Retested resolved defects/issues after teh developers fixed defects
Coordinated and participated in User Acceptance Testing
Actively involved in daily testing status meetings to assign priorities and progress of defects
Provided status and progress of testing to QA manager and to Project Management team regularly
Effectively worked as onsite/offshore coordinator wif other members of QA and Development teams and managed efforts wif offshore team in improving teh processes, methods, effectiveness and efficiency.

Confidential

ETL Tester/ETL Developer

Environment: Informatica Power Center V9.5/10.2, Sybase, Flat Files, CA Workload Automation, Putty, WinSCP, AIX UNIX, HP ALM, Windows 7

Responsibilities:

Developed complex mapping logic using transformations Connected and Unconnected Lookups, Joiner, Filter, Sorter, Router, Sequence Generator to transform teh Data according teh business requirements.
Wrote SQL overrides in source qualifier according to business requirements.
Developed worklets using teh decision tasks to check teh re-startability of teh workflow to eliminate incorrect loading of teh data to teh database.
Wrote UNIX scripts to FTP files, cleaned data, provided other required functionalities, and placed data in proper source/target directories for processing.
Used CA Workload Automation to automate process of running jobs in QA & Production environment.
Performed peer review of teh code changes done by teh team members.
Implemented variables and parameters in teh mappings.
Worked wif session logs and workflow logs in doing error handling and troubleshooting.

Confidential

Environment: Informatica Power Center V9.5/10.2, Oracle, DB2, CA Workload Automation, UNIX, WinSCP

Responsibilities:

Designed and developed pre/post-session routines forInformaticasessions to drop and recreate indexes and key constraints for bulk loading.
Designed and created complex source to target mappings using transformations (Aggregator, Look Up, Joiner, Source Qualifier, Expression, Sequence Generator, and Router Transformations).
UtilizedETLto load data from Oracle database into DB2 database in accordance wif specifications.
Created Data Breakpoints and Error Breakpoints for debugging teh mappings using Debugger Wizard.
Used CA Workload Automation tool in scheduling and monitoring teh jobs in QA and PROD.
Involved in teh continuous enhancements and fixing of production problems.

Confidential

Environment: Informatica Power Center V9.5/10.2, Sybase, DB2, Flat Files, UNIX, WinSCP, Windows 7

Responsibilities:

Created transformations like Expression, Joiner, Lookups, Filters, Routers, and Update Strategy.
Developed different mappings and tuned for better performance.
Created workflows and worklets for designed mappings.
Generated UNIX shell scripts for automating daily load processes.
Designed and developed several ETL scripts usingInformatica, UNIX shell scripts.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship