Informatica,Oracle,Teradata, Unix

RAM.G

E-mail: ***.******@*****.*** Mobile: +91-994*******

Objective:

Aiming to be associated with a progressive organization that gives me the scope and apply my knowledge and skills to involve as part of team that dynamically works towards the growth of the organization.

PROFESSIONAL EXPERIENCE

2+ Years of IT experience in Data Warehousing tool Informatica and currently working as ETL developer.

Extensive knowledge in Informatica.

Worked on different phases of Data Warehouse development lifecycle from designing, development, testing and implementation.

Designed various Mappings for extracting data from various sources involving relational tables and flat files.

Created Re-Usable objects like Maplets & Re-usable transformations for business logic.

Created different transformations for loading the data into Oracle database e.g. Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank transformations, Expressions, Aggregator and Sequence Generator.

Good knowledge in Data Warehousing concepts.

Good Exposure to Informatica 8.6.0

STRENGTHS

Exposure to various schemas like Star schema and Snow flake schema.

Exposure to Datawarehousing and RDBMS concepts.

Strong interpersonal & organizational skills

Passion to fast & quality work, teamwork, technical capability, technology, work ethics, personal & team player.

TECHNICAL SKILLS

Operating System : Windows XP, Windows 2003, UNIX

ETL Tools : Informatica Power Center 8.6.0

RDBMS : Oracle 8i/9i/10g, Teradata

Languages : C, SQL and PL/SQL

Reporting tools : Crystal reports

EDUCATIONAL QUALIFICATION

B. Tech. (Electronics & communication Engineering), from J .N .T. University, Hyderabad.

PROFESSIONAL EXPERIENCE

Working as a Programmer Analyst for Steria India Pvt Ltd, Chennai May 2010 to till date.

Project #1

Project Name : Sales Information Reporting System

Client : Cisco Systems

Duration : March 2011 to till date.

Role : Team Member

Environment : Informatica 8.6.0, Oracle 10g, Teradata, Windows

Description:

Cisco systems is one of the leading electronic components companies of USA. The main objective of this project is to analyze the sales information. Currently CISCO system has over 300 distinct systems associated with orders and sales data. These instance are at various locations through out the global. The data mart gets data from different heterogeneous relational i.e Oracle and flat file sources. Design has been done to replace the existing code into Informatica. Logic has been designed through Informatica mappings to cleanse the data and load the data into the data mart. Cognos is used to develop the reports according to the client’s requirement. Autosys is used as a scheduler tool to coordinate the applications.

Responsibilities:

• Understanding existing business model and customer requirements.

• Programmer performing all development, documentation and troubleshoot the ETL(Extraction, Transformation, load).

• Analyzed requirement specifications, coding the program and developed test plans.

• Designed and developed complex Aggregate, Join, Lookup transformation, Stored Procedure to generate consolidated (fact/summary) data identified by dimensions using Informatica8.6.0

• Designing, Scheduling & Monitoring of workflows.

• Optimizing/Tuning mappings for better performance and efficiency.

Project #2

Project Name : Information Management System

Client : Cherry Electrical Products

Duration : May 2010 to March 2011

Role : Team member

Environment : Informatica 8.6.0, Oracle 10g, Windows

Description:

Cherry Electricals is an electrical product’s manufacturing organization. The Cherry has different vendors and customers. This project is provides complete historic information related with their inventory by developing the data warehouse that stores all the necessary data of last five years related with company. This data warehouse is built in Oracle DBMS.

Responsibilities:

• As Data Warehouse Developer developed various Informatica Mappings, Mapplets and Transformations for migration of data from various existing systems to the Datawarehouse using Informatica Designer.

• Used various Transformations like Expression, Filter, Joiner, Lookup, Stored Procedure, and Router to migrate and clean data.

• Designed the ETL code in Informatica 8.6.0 to populate the Data Mart from flat files and oracle source.

• Scheduling jobs to refresh the data from the transactional system using Informatica server Manager.

• Optimizing/Tuning mappings for better performance and efficiency.

Ram

Contact this candidate