Informatica ETL developer

JYOTSNA MOHANTY

ETL/Informatica Developer

Phone: 832-***-****

Email: ************@*****.***

PROFESSIONAL SUMMARY:

Have been in IT since 2007 and having 8+ years of IT experience in Analysis, Design, Development and Implementation of Enterprise Data warehouse projects using ETL processing tool Informatica7.x,8.x and 9.x in various domains like Telecom, Commission system and retail and exposure with OLAP reporting tool Business Objects and Cognos.

Currently working as Senior System Analyst.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business community and developers across multiple disciplines.

Experience in managing ETL Developers (Includes: Assigning Task, Review of work progress, Guiding with Technical issues, Project Issues, etc…)

Proficient in understanding business processes, requirements and translating them into technical requirements and test strategies.

Experience in coordinating and collaborating with onsite development and Business teams.

Experience in Design, development and Deployment of business application for Dealer Commission System and centrally Managed Sales Portal.

Deliver project road-map including initial source data definition, mapping, detailed ETL development specifications and documentation of all operations.

Extensively worked on post-production support and resolving any issues, using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the session logs

Experience in Callidus (Truecomp 5.1 Version).

Expertise in using Informatica (Repository Manager, Mapping Designer, Workflow Manager, Workflow Monitor, Transformation Developer, Source Analyzer) .

Strong knowledge of Data warehouse concepts - Star Schema, Snowflake schema and Slowly Changing Dimensions.

Involved in Full Project Life Cycle for building Data Warehouse.

Developed complex mappings using various transformation logic like Source Qualifier, Router, Filter, Expression, Sorter, Aggregator, Joiner, Union, Connected/Unconnected lookups, Update Strategy and Normalizer.

Experienced in Performance of Mapping Optimizations in Informatica.

Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.

TECHNICAL SKILLS:

ETL: Informatica, Power Center 9.0.1/8.6.1/7.x.

Languages: SQL, PL/SQL, C, C++.

Databases: Oracle 11i/10g/9i/8i, SQL Server, MS-Access, SQL, Teradata.

OLAP Tools: Cognos 7.0/6.0, Business Objects.

Operating System: UNIX, Windows (98, 2000, NT, XP).

EXPERIENCE HIGHLIGHTS:

Worked as Senior System Analyst for Dell Account from Feb 2015 to till March 2016

Worked as Senior Developer for Affine Analytics from Mar 2011 to Feb 2015.

Worked as Senior Informatica Developer for Capgemini India Pvt.Ltd from April 2010 to March 2011.

Worked as Informatica Developer for IBM India Pvt.Ltd from June 2007 to March 2010.

PROFESSIONAL EXPERIENCE:

Project 1

Project : Dell Print NAOM.

Client : Dell IT India

Operating System : Unix

Tools : Informatica Power Center 9.1, Teradata, Control-M

Team Size : 15

Role : Senior Developer

Period : Feb 2015 till date

Project Objective:

The purpose of the Dell Print NAOM project is to create Data Warehouse with a more integrated level for analysis of sales, finance and profit. The main aim of the project to extract OMAR data from OMEGA and decommission the legacy system.

Project Description:

This application is developed to consolidate various SALES and Order related information coming from different sources based on different regions like APJ, EMEA, OMAR, GLOBAL AR into Teradata Base tables from which it is loaded to Package tables.

There are various views which extract the data from Package tables based and from them business reports are generated.

Responsibilities:

Interacting with Business Analyst to understand the business requirements.

Analyzing requirements to refine and transform into functional specifications.

Analysis of the specifications provided by the clients.

Review of mapping documents to start development.

Extracting data from sources like Oracle and Flat Files using Power center designer and transforming them using the business logic and loading the data to the target warehouse.

Developing mappings as per the business requirements Using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.

Coordination of system/Integration/UAT testing activities with other teams involved in project and review of test strategy.

Fine tuning mappings and sessions to improve performance.

Coordinating with business and EST teams for closure of UAT defects and creating

adhoc reports for end users.

Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.

Project 2

Project : Sonic BI

Organization : Affine Analytics

Client : Sonic Automative

Operating System : Windows NT

Tools : Informatica Power Center 9.1

Team Size : 10

Role : Module Lead

Period : Mar2011 – Feb 2015

Project Objective:

The purpose of the Sonic BI project is to create Data Warehouse with a more integrated level for analysis of sales, finance and profit.

Project Description

Sonic Automotive is one of the largest automotive retailers in the United States which operates in various states with multiple dealerships representing several different brands of automobiles. These dealerships provide numerous services, including sales of new and used cars, sales/service of replacement parts, vehicle maintenance, warranty service, painting, and collision repair services; arrangement of extended warranty contracts, financing, and insurance for the company's customers.

The project was mainly divided into two phases. The first phase involves loading the data from DMS systems and other External systems into staging through ETL Tool Informatica and then to DWH which is used by BI reporting teams to generate several critical Monthly, Quarterly and Yearly reports.

Responsibilities:

Leading 4 members team as Module Lead.

Interacting with Business Analyst to understand the business requirements.

Analyzing requirements to refine and transform into functional specifications.

Analysis of the specifications provided by the clients.

Preparation of HLD, project plan based on the business functional spec.

Review of ETL Detailed design documents for Mapping and DDL specification document for creation of tables, defining keys/constraints on tables and data types.

Analysis of Data model to check table constraints and columns in Data mart.

Extracting data from sources like Oracle and Flat Files using Power center designer and power exchange and transforming them using the business logic and loading the data to the target warehouse.

Designing mappings as per the business requirements Using Transformations such as Source Qualifier, Aggregator, Expression, Lookup, Filter, Sequence generator, Router, Union, Update strategy etc.

Coordination of system/Integration/UAT testing activities with other teams involved in project and review of test strategy.

Fine tuning mappings and sessions to improve performance.

Coordinating with business and development teams for closure of UAT defects and creating adhoc reports for end users.

Helping the team in fixing the technical issues if any and Tuning of Database queries for better performance.

Keep track of all CI list, maintaining versions and Change requests.

Increasing client confidence by proactively addressing production support issues and providing recommendations for performance/process improvement.

Project 3

Project : World Wide (CRM)

Organization : Capgemini Consulting India Ltd

Client : HP IT (Infrastructure)

Operating System : Windows NT

Tools : Oracle 9i, Informatica ETL (7.1), Toad, DAC, OBIEE.

Team Size : 12

Role : Senior Informatica Developer

Period : April 2010 to March 2011

Project Objective:

Hewlett-Packard (HP) is a leading global provider of IT products, technologies, solutions, and services to consumers and businesses. This is HP's worldwide Siebel Implementation to unit its sales force, marketing personnel, call center professionals, and partner network through a single, comprehensive business customer information system.

Project Description

This Project mainly deals with the loading the data into the EDW in all the 3 regions (Asia Pacific, EMEA and US). Informatica is used for creating the mappings and workflows.Data is loaded into the tables on daily, Weekly and Monthly basis. Scheduling is done through DAC and Informatica based on the volume frequency of the loads.

Responsibilities

Gathered and analyzed requirements by meeting business stakeholders and other

technical team members prior to the design of ETL.

Understanding High Level ETL Requirement specifications to develop LLD.

Created the mappings using different transformations like Source Qualifier, Expression, Filter, Router and Lookups based on the requirements.

Preparation of Unit test Cases, System Test Plan and System Test Cases.

Involved in more than 3 code MTP’s (Move to Productions).

Project 4

Project : Dealer Commission System (Callidus)

Organization : IBM India Pvt. Ltd

Client : Vodafone Australia (Telecom)

Operating System : Windows NT

Tools : Oracle 9i, Callidus Truecomp (5.1), Informatica ETL (7.1),

True Information/Actuate Reporting.

Team Size : 15

Role : Business Analyst / Application Developer

Period : Oct2007 to Jan2010

Project Objective:

The Project Dealer Commission system (Callidus) is one of the very few green field project, developed and support by IBM for Vodafone. This is to create a commissions system which will have the responsibility for calculating both external and internal commission payments for Vodafone Australia business parterners known as Dealers. This is implemented using a package which is specialized in computing commissions in various industry segments known as Truecomp. The project uses True Integration (Informatica ETL tool), Truecomp rules engine and TrueInformation/Actuate reporting tools.

Project Description:

This system will process the incoming data feeds (Data Integration), run a batch processing job to calculate commissions (Truecomp Pipeline), extract the operational data (Report ETL) into a reporting repository (Data Mart) and produce data extracts for downstream systems.

Responsibilities:

Interacted with business community and gathered requirements based on changing needs.

Developed standard ETL framework to enable reusability of similar logic in all data operations.

Involved in System Documentation of Dataflow and methodology.

Performed Configuration Management to migrate Informatica mappings, sessions and workflows from development to test to production management.

Involved in Preparation of high level Design document for Data Integration

Prepared Micro Design documents for DI Interfaces.

Created and executed sessions using Workflow Manager.

Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.

Understanding existing business model and customer requirements.

Used Transformation Developer to create the Joiner, filters, Router, lookups, Expressions, Aggregation transformations, Update strategy, Stored Procedure Transformations used in mappings.

Interaction with VF AU directly and assisting them in all issues and enhancement work.

Unit testing and System testing the mappings.

Preparation of Unit test Cases, System Test Plan and System Test Cases.

Fixing defects for the coding while integration testing.

TRAINING & CERTIFICATIONS:

Master in Computer Application (India).

A level (Advanced Diploma in Computer Science (India)).

Bachelors in Science (India).

Received star performer certificate from Vodafone AU, at IBM India Ltd

Received recommendation from customer.

Contact this candidate