Informatica Developer Resume

Title
Informatica Developer

Primary Skills
Informatica, SQL, UNIX, Data warehousing concepts, MRM/HM

Location
India-Noida (will consider relocating)

Posted
Aug-12-09


Experience Summary
I am an associate with Tata Consultancy Services for the last 3 years and 5 months and worked in several projects during this period. My primary skill set includes Informatica Powercenter. I have worked in support, enhancement and development projects primarily in Informatica. My other skills include SQL, UNIX and data warehousing.

Other Skills include
Good Communication Skills, both Verbal and Written.
Experience to tackle the Client and end-Users.
Maintaining good relationship with the people.


Technology
Below is a list of important hardware, software products, tools and methods that I have worked with.

Hardware Software Products Tools
IBM PC Compatible
HP
Apple PC Windows XP/NT,
Macintosh,
DOS,
Unix,
Oracle 9I (PL / SQL )
Informatica Power Center 7.1.5,
Informatica Power Center 8.1.1
Informatica Power Center 8.1.5,
Hyperion,
Rational Clear Case, Clear Quest,
Master Reference Material/Hierarchy Manager, Quality Center



Qualifications

Degree and Date Institute Major and Specialization
Bachelor Of Technology, July 2005 Galgotia's College Of Engineering and Technology, Greater Noida, U.P. Affiliated to Uttar Pradesh Technical University, Lucknow. Information Technology
Senior Secondary, March 2000 St. Aloysius College, Pilibhit, U.P. Science Stream
Higher Secondary, March 1998 St. Aloysius College, Pilibhit, U.P. All Subjects







Assignments

The details of the various assignments that I have handled are listed here, in chronological order.


Project Master Reference Material
Customer ELI LILLY and Company
Organization Tata Consultancy Services
Period Sep-08 -- till date
Description Eli Lilly & Company wants its data to be moved to a new Oracle database from MVS database to carry its operations and to be at par with the new applications. The existing database will be obsolete once the new system would be in place.
The Overall responsibility is to create a new application that would cater to the needs of the Business.
Role ·1 Working in the Project as a Module Lead.
·2 Developed the mappings and workflows as per the Business logic using Informatica 8.1.5 version.
·3 Development of new system for Eli Lilly & Company.
·4 Sorted out the issues that arise during unit testing.

Solution Environment Windows OS, HP Unix, Oracle 10g
Tools Informatica 8.1.5, Toad, MRM/HM, Quality Center


Project GODW EDW Core to Semantic
Customer Apple Technologies, Inc.
Organization Tata Consultancy Services
Period April 2008 -- July 2008
Description Apple Technologies, Looking for the EDW(enterprise data warehouse) instead of GDW(global data warehouse) to carry its operations and load data to this EDW(teradata database) with source as SAP BW. From here the data has to be send to the target(flat files).
The Overall responsibilty was to have an EDW instead of a Global operational data warehouse that would cater to the needs of the Business.
Role ·5 Worked in the Project as a Module Lead.
·6 Worked on Design documentation, SIA(System interface agreement).
·7 Developed the mapppings and workflows as per the Business logic using Informatica 8.5 version.
·8 Development of new system for Apple Technologies Inc.
·9 Sorted out the issues that arises during unit testing.
·10 Worked on creating the views on the tables in the staging area.
·11 Worked on SAP BW which acted as a source to the new application.
Solution Environment Macintosh OS, HP Unix, Teradata
Tools Informatica 8.1.5


Project CM2
Customer Agilent Technologies, Inc.
Organization Tata Consultancy Services
Period Feb 2008
Description Project was taken up to test the inventory data (in Data Warehouse) flowing correctly after the modification in the Agilent's operations. Agilent wants to have a single inventory at Switzerland instead of having it at various places like Malaysia, Singapore etc.
Role ·1 Worked in the Project as a Team Member.
·2 Functional Technical Consultation on behalf of TCS to Agilent project
·3 Repository Administration
·4 Data loading from Source to target in the Test environment.
·5 Fixing the issues while loading the data

Solution Environment Windows 2000/NT/XP, HP Unix, Oracle 9i
Tools Informatica 8.1.1 SP4


Project GDW Support
Customer Agilent Technologies, Inc.
Organization Tata Consultancy Services
Period Apr 2006 -- Jan 2008 and March 2008
Description Agilent needs this Global data warehouse for an enterprise view of functional data. This warehouse is a trusted source for key enterprise analytical and management reporting.
The project involves maintaining this Global warehouse. Data flows in to this warehouse through OLTP & OLAP source system (Relational Database and Flat File) and ETL process is governed through Informatica power center. Monitoring these ETL processes and maintaining the integrity of data through various source systems is the key task of this project.
Role ·1 Resolving technical issues related to ETL through Informatica to maintain data integrity
·2 To study the mapping and workflows thoroughly and know the data relationships and data flows.
·3 Requirement gathering and requirement Analysis
·4 To prepare the detailed Low level design document for the bug fixing
·5 Code creation
·6 Test case preparation.
·7 Performing Independent Unit and Integrated Testing
·8 Monitoring Informatica jobs

Solution Environment Windows 2000/NT/XP, HP Unix, Oracle 9i
Tools Informatica 7.1.5.and 8.1.1 SP4, Hyperion, Toad, MSVSS


Key Competencies & Skills
My Competency Profile includes the following:
OS/Environment DOS, UNIX, Windows XP/NT and Macintosh
Business Intelligence Data Warehousing, Informatica, Hyperion
Languages & Tools Visual Source Safe, Rational Clear Case, Rational Clear Quest
DBMS Oracle-9i, Oracle-10g, PL/SQL.


Career Profile

Dates Organization Role
Since 06-Feb-2006 TATA Consultancy Services Analyst Programmer


Training / Continuing Education Summary

Program or Course Coverage Dates
.Net Training Complete 04-04-2006 to 19-04-2006
AS/400 training Complete 18-03-2006 to 31-03-2006
ILP Trivendrum Complete Feb--Mar 2006


Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Noida, India | Resumes in India

View other Informatica Developer resumes, Programmer / Developer resumes