Bsc with 3+ years Exp in Informatica

GOPAL Mobile: +91-934*******

(ETL Developer) Email:*********@*****.***

SUMMARY OF EXPERIENCE

• 3+ years of experience in the field of Information Technology with 3.5 years of experience in development of Data warehouse using Informatica.

• Excellent skills in ETL Tools – Informatica

• Exposure to Data Warehousing Design development, implementation and Implementation of data warehousing projects.

• Efficient in Performing data cleansing, scrubbing and validating the data before loading the data into Data warehouse.

• Expertise in analyzing customer needs and taking appropriate steps to implement them in the application development.

• Efficient in ETL Procedures, Star Schema, Snow Flake, Dimensions and Fact tables.

• Having experience on Oracle and UNIX.

• Good communication and presentation skills and ability to quickly adapt to the technical environment as a developer

EDUCATION

• Bachelor of Science (BSc) from SV UNIVERSITY, ANDHRAPRADESH.

TECHNICAL SKILLS

Operating System Windows NT, Windows 2000

ETL Tools Informatica 8.X/7.X

OLAP Tools Cognos 8.4

Database Oracle 9i/10g, MS SQL Server

Languages SQL/PLSQL,UNIX

PROFESSIONAL EXPERIENCE

Organization Designation Duration

Hexaware Technologies Software Engineer June’ 2010 – Till Date

Terminus Global IT Solutions ETL Developer Mar’ 2008 – June’ 2010

Project #1:

Project, Customer Risk Management (RM), Barclays loan System.

Role Software Engineer

Duration June’ 2010 – Till Date

Technology Informatica 8.6, Oracle 10g

Team Size 12

Description:

A global investment bank serving the financial needs of corporations, institutions, governments and high-net-worth investors worldwide. Unlike normal banking this provides payday loans i.e. Small loans for a short period. They have a system in place called Advantage which captures data into flat files. Each location at the end of the day has to pump data into central zones. Each location daily generates reports for different purposes (loan portfolio, non sufficient fund portfolio etc).

They needed a Data Warehouse so that they could maintain historical data at central location for integration, analyze business in different locations, according profit areas, which could server a purpose of a DSS for decision makers.

Responsibilities:

• Mainly involved in ETL developing Creating the mappings and transformations using Informatica.

• The data from the staging area was transformed and loaded to the target on Oracle using Informatica Tool.

• Responsible for the development of Meta data transformations and establishing load schedule

• Optimizing/Tuning mappings for better performance and efficiency.

• Extensively used transformations like Filter, Aggregation, Joiner, Expression, Lookup, Router, and Update Strategy.

• Creating validation and loading the rejected records into the relevant tables and send to the users for re-submitting.

• Involved in designing the maplet and reusable transformation according to the business needs.

• Knowledge of slowly changing dimension tables and fact tables.

• Used the mapping parameter to make the mapping more flexible.

• Involved in Unit testing.

• Checked the output according to the specifications.

Project #2:

Project, Customer GI Reports, Gerling Insurance

Role ETL Developer

Duration Sep’ 2009 – June’ 2010

Technology Informatica 8.6/7.1.5, Oracle 9i

Team Size 12

Description:

Sales Agents, customer and transactions will organize the data according to the requirements of the organization. The main process that is performed is Extraction, Transformation and Loading. This system is used to perform Policy formulating, claim processing. The console application, which is part of this system, does the month-end and the day-end processes apart from performing regular database maintenance.

The reporting tools provide on-demand reports to business users who use the information to study service usage patterns, design more competitive, cost-effective services, and improve customer service.

Responsibilities:

• Developed data Mappings between source systems and warehouse components using Informatica

• Develop and test extraction, transformation, and load (ETL) processes for the EDW.

• The objective is to extract data stored in different databases such as Oracle, SQL Server and to load finally into a single data warehouse repository, which is in Oracle.

• Performed turning in Database and Informatica mappings.

• Used the Workflow Manager, to create the session, worklets.

• Preparing Unit Test Case document.

• Checked the output according to the specifications.

Project #3:

Project, Customer Health Care System, Redmond Technologies, Australia

Role ETL Developer

Duration Mar’ 2008 – Sep’ 2009

Technology Informatica 7.1.5, Oracle 9i

Team Size 8

Description:

First health is national, full service health Benefits Company with three major lines of business. Group health, Workers compensation, and public sector. The primary objective of the project is to develop healthcare system making extensive use of Data marts. The objective is to extract data stored in different databases and load into oracle system.

Responsibilities:

• Developed data Mappings between source systems and warehouse components.

• Cleansing and processing data from stage to data marts using Informatica transformations.

• Developed and test all the backend programs, Informatica mappings and update processes.

• Optimizing/Tuning mappings for better performance and efficiency

• Managed the Metadata associated with the ETL processes used to populate the data warehouse.

• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.

• Extensively used Update Strategy and Lookup transformations for updating the target tables.

Contact this candidate