Informatica Administrator Resume

SUMMARY:

Currently working as an Informatica Administrator (Team size: 11) for a major. I am working for a Confidential ( Confidential ) providing platform support for Informatica in a shared environment. Our Informatica Shared services environments caters to about 170 projects across 65 operating companies, having more than 50 physical servers.
Overall in my career spanning close to 8 years in IT industry, I have acquired Data warehousing (ETL tool Informatica) proficiency, working mainly in Banking & Capital Markets, Media & Entertainment and Pharmaceutical Domain.
I've worked in all the phases of SDLC in different roles as a designer, administrator, developer, tester, reviewer and onsite coordinator. I’ve also worked on projects based on Agile software development methodology.
In the past, I’ve worked as an Team Lead/Onsite coordinator(Team size: 5) at client location(Amsterdam, Netherlands) for 1 year( )
I have gained expertise in RDBMS like DB2, Oracle and data warehousing solutions like Teradata.
I am acquainted with UNIX as an operating system as well as scripting language.
I have a considerable experience of direct communication with clients as my current and previous project involved direct communication with clients.
I've also been part of multiple project implementations to production environment.
As part of aftercare for the projects, I’ve worked on performance tuning and incident resolution.
I am a Good team player and have worked with teams of different sizes and skills.
I possess excellent communication skills and all my projects were based on Onsite - offshore model.

TECHNICAL SKILLS:

ETL/BI Tools: Informatica 7.3/8.6/9.1/9.5.1/9.6.1

B2B Tools: Informatica DT

Databases: Oracle 9i/10g/11g,DB2,Teradata

Programming Languages: Academic exposure to C, C++, Java, HTML, ASP and VB Scripting.

Operating systems: Windows, Unix, Linux Red Hat, SLES10, SLES11

Business Domain: Banking and Finance, Media and Entertainment and Pharmaceutical.

PROFESSIONAL EXPERIENCE:

Informatica Administrator

Technology and Tools: Powercenter 8.6/9.1 HF2/9.5.1 HF3/9.6.1,Oracle 11g, Teradata 13.

Confidential

Responsibilities:

Analyze requirement and gather requirement for missing pieces.
Provide effort estimation based on the finalized requirement.
Creating design documents from requirement
Prepare test cases.
Get the design document and test cases signed off from client.
Developing mappings and scripts according to design document.
Perform unit testing and update UTP.
Regression testing in case of change requests.
Get the code and UTP signed off from client.
Create confluence page for application support team.
Setup Handover call and transfer knowledge to application support team.
Performance tuning.
Peer code review.

Senior Informatica Developer

Technology and Tools: Powercenter 9.1, B2B DT, Db2, Oracle, Sybase, Unix.

Confidential

Responsibilities:

Review and approve production changes.
Fix production Incidents(Low, Middle and High priority)
Process improvements and automation.
Get agreement from all involved groups and implement solution for production problems.
Create changes for implementation of components to production environment
Root Cause Analysis for production Incidents
Weekly status meetings with Functional Team and project team.
Stake holder in project release implementation approval (GO/NO GO) meetings.

Programmer Analyst

Technology and Tools: Powercenter 8.6, Db2,Teradata,Unix, Mainframes.

Confidential

Responsibilities:

Client interaction to gather requirements.
Perform Impact Analysis for new project requests.
Development of jobs/mappings based on Business rules.
Performance tuning.
Creating Implementation related documents.
Perform BAT and FAT run on different environments.
Regression testing for change requests.
Deploying components to different environments.
After support for components deployed to production environment.

Developer/Onsite coordinator

Technology and Tools: Powercenter 8.6,Db2,Teradata,Unix, Mainframes(Job scheduling).

Responsibilities:

Perform Impact Analysis for new project requests.
Development of jobs/mappings (using Informatica 8.6) based on requirements.
Creating Implementation related documents.
Creating System Test Plan.
Perform system testing using STP.
Regression testing for change requests.

Developer

Technology and Tools: PowerCenter8.6, Db2, Unix, Mainframes (Job Scheduling).

Confidential

Responsibilities:

Perform Impact Analysis for new project requests.
Prepare project estimates.
Analyze SSA’s and preparing design documents.
Creating Unit Test Plan(UTP).
Development of jobs/mappings (using Informatica 8.6) based on design documents.
Perform unit testing and update UTP’s.
SQL tuning.
Regression testing for change requests.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship