ESWAR
CONTACT NO: 976-***-**** EMAIL ID:k8x2oe@r.postjobfree.com
Career Objective
To work in a challenging work environment with opportunities for professional growth and excel in work towards the growth of the organization.
Summary:
Having Around 2 years of experience in Data warehousing using Informatica Power center 8.6/7.1.
Extensively worked on Designer, Workflow Manager and Workflow Monitor using Informatica.
Excellent experience in Design & Implementation of ETL processes, Transformation, mappings and loading using Informatica Power center 8.x/7.x
Extensive experience in creation of ETL mappings and Transformation to reflect business rules using Informatica Power Center to move data from multiple sources into target area.
Most of the transformations were used like the Source qualifier, Update strategy, joiner, lookup, Filter and Sequence generator.
Configured the mappings to handle the updates to preserve the existing records using Update Strategy Transformation.
Experienced in integration of various relational and non-relational sources such as Oracle Tables, and Flat Files.
Having Good Knowledge Dimensional Modeling like Star /Snow Flake Schemas.
Good Knowledge on Data warehousing techniques using different Data Warehouse Schemas, SCD Dimensions and Fact tables etc.
Used Workflow manager to create sessions, batches (Sequential & concurrent) to run with logic
Good Knowledge in Oracle.
Has knowledge in Normal load and Bulk load.
EXPERIENCE DETAILS:
Working as an Associate Consultant in Sierra Atlantic, Mumbai January 2010 to till date.
EDUCATION DETAILS:
B.Tech From J N T University Passed Out 2010.
TECHNICAL SKILLS:
ETL : Informatica Power Center 8.6/7.x
Database Languages : SQL Server 2005, Oracle 9i
Operating Systems : Windows Family and UNIX
PROFESSIONAL EXPERIENCE:
Project#1:
Title : National Commercial Bank
Client : NCB, Jamaica.
Role : ETL Developer
Duration : April 2011 to till date.
Description:
National Commercial Bank (NCB) is one of the leading banks in Jamaica. NCB has a strong record of growth and profitability. There are total 11 branches across the island. Information sits on various platforms. The aim is to migrate oracle-based platform.
The goal of the project is to provide ETL process to extract all orders from CI systems that require Emerald lookup as part of NCB project and send the report to Business community. The load process is scheduled to run twice a month. Business object is tool used for generating reports.
Responsibilities:
Understanding the Functional Team requirements & specifications
Documenting Test cases and reviewing
Tuning of the mappings to enhance the performance
Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
Extracted source data from flat files, Oracle and loaded to an Oracle.
Developed mappings in Informatica Power Center Designer to load data from staging environment to warehouse.
Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
Created and Monitored Informatica sessions.
Checked and tuned the performance of Informatica Mappings.
Involved in Creating Sessions, Workflows Using Workflow Manager
Involved in testing the mappings (UNIT testing).
Environment: Windows NT, Informatica Power Center 8.6.1 Oracle 9i, UNIX.
Project#2:
Project : Life insurance data warehouse.
Client : American Skyline Insurance Company
Role : ETL Developer
Duration : Feb2010 to March 2011.
Description:
American Skyline Insurance Company (ASCI) is one of the world’s respected players in Health Care Insurance industry. This conceptual enterprise Data Warehouse model provides Enterprise wide solution, which deals with several treads of the business like Audit& IT Analysis, Billing & Payment Analysis, Disability Claim Analysis, customer Profile Analysis, Customer Service Analysis, Financial Analysis, Human Resource Analysis, Marketing Analysis and Sales Channel Analysis. It also supports the Operational Reporting Strategies Development from which it is extracting the data through Flat Files, Oracle then Transforming, and Loading into Oracle target database. We first constructed the Data Marts according to the identified subject areas and then integrated them into Data Warehouse.
Responsibilities:
Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica Power Center.
Extensively used ETL to load data from Oracle, flat files to Oracle.
Extensively used aggregator, expression, lookup, and update strategy, transformation
Involved in Creating Sessions, Workflows Using Workflow Manager
Analyzed Mappings and Sessions for better performance.
Environment: Informatica Power Center 8.6.1, Oracle 9i, Windows NT.