ETL application support Resume

SUMMARY

Having 8+ years of experience in Development, Production support, Requirement gathering, Design, Functional Testing, User Acceptance Testing, Migration and implementation of business applications in various domains.
An ETL developer(Informatica, Datastage) with nearly 8+ years of very strong professional background in Data warehouse and solid industry experience in teh software engineering, processes and methodologies.
Expert in Informatica Power Center 10.x, 9.x.
Strong experience in gathering Business requirements for Enterprise Business Intelligence Team, understand client issues and data challenges and translate into functional requirement.
Around 4+ years of experience in ETL application support having multiple operating systems & multiple upstream/downstream applications.
Around 2+ years of experience in Informatica Administration such as deploying Informatica objects across environments, User creation etc.
Work extensively on Data Extraction, Transformation and Loading from various Data sources like Teradata, Oracle, DB2, XML, Flat files using Informatica PowerCenter
Experience in Performance tuning/optimization of Informatica objects, identifying and resolving bottlenecks at various stages of ETL.
Perform complex troubleshooting of production issues and providing teh recommendation for teh long run.
Good experience in Unix shell scripting and handling files in Unix systems.
Hands on experience in scheduler tools TWS Maestro and Autosys.

TECHNICAL SKILLS

Technology Domain: Data Warehousing.

Tools: / Applications: Informatica 8.x/9.x/10.x, TOAD, Putty, IBM DataStage, Ipswich, SAP SAP Business Objects (BO).

Operating System: Unix AIX, Linux & Windows.

Databases: Oracle 9i/10g/11g.

Languages: UNIX Shell scripting, PLSQL.

Job Scheduler: TWS Maestro & Autosys.

PROFESSIONAL EXPERIENCE

Confidential

Informatica developer/ ETL application support

Skill sets - Informatica 9x,10.1, Unix, Oracle, Maestro

Responsibilities:

Work as onsite coordinator to participate in Technical Analyisis, design and implementation of ETL process using informatica.
Work with business analyst for teh requirement gathering
Use Dynamic lookup.
Performance tuning of teh complex informatica jobs.
Use Pushdown optimization.
Design and review of complex informatica mappings and workflows.
Extensive use of persistent cache to reduce session processing time.
Perform code review, Unit testing and providing signoff for deployments.
Develop SCD type 2 dimensions.
Develop shell scripts for file transfers.
Involve in Oracle Query Optimization.
Develop Autosys JIL scripts to schedule teh batch.
Partitioned sessions for concurrent data load.
Coordinate activities across team to ensure delivery of assigned work as per teh schedule.

Confidential

Informatica developer/ ETL application support / Deployment support

Skill sets - Informatica 9x,10.1, Unix, Oracle, Maestro

Responsibilities:

Responsible for enhancing and optimizing ETL mappings in production system.
Responsible for preparing unit test cases and system test cases documents and also analysis and Solution Approach documents.
Creat Informatica mappings, sessions and workflows.
Level 3 support for teh production problems.
Resolve critical production bugs by giving hot code fix and workaround procedures to support team.
Schedule meetings with business partners to identify existing bugs in production data and providing solutions.
Highly contribute in teh deployment of Informatica mappings and participated in release management, CAB meetings.
Involve in enterprise Informatica upgrade from version 9.x to 10.1. Reviewed existing production components compatibility and created implementation plan.
Create production support transition document for new code deployment.
Document teh Risks and discuss with Business
Provide warranty support post releases

Confidential

Datastage developer/ ETL application support

Skill sets - Datastage 7.x, Unix, Oracle, Autosys

Responsibilities:

Requirement Analysis of Datastage to Informatica re-write project and actively involved in part of teh design phases.
Analysis and design verification.
Fix teh bugs at data/environment level
Responsible for enhancing and optimizing ETL mappings in production.
Responsible for preparing unit test cases and system test cases documents and also analysis and Solution Approach documents.
Create Informatica mappings, sessions and workflows.
Level 3 support for teh production problems.
Resolve critical production bugs by giving hot code fix and workaround procedures to support team.