VIJAY JAT– ETL Developer

Phone: 201-***-****

Email: add4xd@r.postjobfree.com

Proficiency -

Primary Skills - Informatica Power Center 9.x, 10.x, Informatica Power Exchange 10.x, Oracle Insurance Policy Administration.

Domain - Retail, Insurance.

SDLC Methodologies - Waterfall, Agile

Operating Systems - Windows 2000/XP/2007,2010,Windows 7,8,10,Windows Server 2012,Unix/linux.

Database - MS SQL Server 2017/2014, Oracle 11g/10g/9i,12c, DB2, PL/SQL,Teradata

Education –

Post-Graduation - Master Of Science (MIS) at FDU in the year 2017, NJ, USA

Under-Graduation - Bachelor of Engineering (CS) at RGPV University in the year 2011, MP, India

SKILLS INVENTORY –

Around 5 yrs of extensive experience of Informatica Power Center and data migration.

Designed and developed Complex mappings from various Transformations like re-usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s, Normalizer.

Involved in designing and implementing Data Mart / Data Warehouse applications using Informatica 9.x/10.x (Designer, Workflow manager, Workflow monitor and Repository Manager).

Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.

Experience in Performance tuning of targets, sources, mappings and sessions.

Experience in using SQL, PL/SQL, Dynamic SQL, Stored procedures/functions, and Packages, Complex Joins, Correlated Sub-Queries, Aggregate functions, Analytic functions, Views, Materialized Views, Indexing, Partitioning and Performance tuning the same using explain plan.

Experience in data extraction from Mainframe server from DB2 database and VSAM files using Informatica Power Exchange.

Experienced in creating registration groups in Informatica Power Exchange and extracting the data from DB2 for CDC implementation.

ETL experience in development of mappings and tuned existing mappings for better performance using Informatica Power Exchange, Informatica Power Center as per the business rules.

SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.

Expertise in writing DDL, DML, DCL, and TCL commands.

Ability to achieve project goals within project constraints such as scope, timing and budget. Allocating work and managing the resource planning. Day to day monitoring of the deliverable and meeting the expectations of the business clients.

Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.

CHRONOLOGICAL SUMMARY OF EXPERIENCE

Client: Nationwide Insurance Duration: March 2019 to till date

Project: Annuity Enhancement Initiative

Location: Columbus, Ohio

Role: Informatica Developer

Environment: Oracle 12c, Unix, Teradata

Tools: Informatica PowerCenter10.2, Rules palette v11, OIPA, Putty, Toad, ServiceNow, Quality Center 12, RTC, SOAPUI,Github, Jenkins, ESP.

The Annuity Enhancement Initiative is a strategic initiative to assess current state processes and technology to determine an optimal future that will enhance the service experience.

CALIPSO - Consolidated Annuity and Life Individual Policy System OIPA.

CALIPSO is OIPA Software used to manage Immediate Annuities.

SPIA: single-premium immediate annuity. An immediate annuity is always purchased with a single-premium because benefit payments begin soon after purchase.

iCAS is a policy administration system used for administering contracts for NF's immediate annuity product

Roles/Responsibilities and Skill set

Configuring OIPA(Oracle Insurance Policy Administration) v10.2 tool, using XML,SQL in Oracle, that acts as back-end to the insurance product being developed.

Configuration and testing of web-based policy administration systems using XML languages.

Implemented Functions and PL/SQL Stored procedures in order to improve the performance

of application.

Product Configuration and integration in life cycle of life insurance and annuity products as

part of Feature Implementation in OIPA based on technical design document.

Establishing communication between third party systems and OIPA through SOAP UI Web

service calls.

ETL design, development, optimization and support, creates and implements scheduling strategy, and develops error handling processes.

Design, develop, and test processes for extracting data from source applications.

Performed tuning of SQL queries for speedy extraction of data to resolve and troubleshoot issues in OLTP environment.

Performed integration of various data sources with Multiple Relational Databases like Oracle, Teradata, MS SQL Server and Worked on integrating data from XML files, flat files.

Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets) with various transformations.

Client: Prudential, Plymouth, MN Duration: June 2018 to Feb 19

Location: Minnesota

Role: Informatica Developer

Domain: Insurance

Environment: MS SQL Server 2014/2016, DB2, Oracle, Windows 2012 R2 SP1.

Tools: Informatica Power Center 10.1, Github, Jira

Prudential underwrites a wide range of insurance policies but is perhaps more known for its payroll deduction insurance coverage, which pays cash benefits when a policyholder has a covered accident or illness. The objective of the project is to get data from multiple admin systems, new business systems and integrate the data loading into Enterprise Data warehousing and Claims Data mart. Finally, create the reports based on claim paid to date, policy issue date and other criteria.

Roles/Responsibilities and Skill set

Requirements gathering through table level and column level mappings and knowing client’s data element fields and their data structures.

Writing the transformation rules based on the column level mapping discussions.

Development of transformation rules as per the column level mapping document using various transformation techniques in Informatica.

Good experience in writing various complex SQL queries using joins at the Informatica Source qualifier level to increase the performance of huge data set mappings.

Expert in using various transformations like Joiner, Aggregator, Expression, Router, Look up, Union in Informatica.

Designed and developed the mapping which generates the parameter file dynamically.

Experience in performance tuning of Informatica mappings at both session and workflow level.

Experience in creating the incremental load mappings to capture the change data in the target tables.

Involved in data cleansing to see that accurate data is being loaded in the target.

Data validation by wring the SQL queries after the data has been converted into target tables.

Data scrambling and encryption of identified PII columns in the data base to ensure the data Security.

Identifying and resolving the defects raised by the clients during UAT.

Morgan Stanley Duration: Jan 2018 to May 2018

Project: Wealth Management EDW

Location: New York, NY

Role: Informatica Developer

Domain: Retail

Environment: MS SQL Server, Oracle 11g/10g, Unix and LOTUS NOTES

Tools: Informatica Power Center 9.5

Morgan Stanley is a leading global financial services firm providing investment banking, securities, wealth management and investment management services. Aim of this project is to set up the infrastructure for Data warehouse Application, Design the application modules and components within the proposed infrastructure framework to design and develop the application components, testing and deployment of application.

Roles/Responsibilities and Skill set

Worked and coordinated with Data Architects, Business Analysts & users to understand business and functional needs and implement the same into an ETL design document.

Worked on Source Analyzer, Mapping & Mapplet Designer and Transformations, Informatica Repository Manager, Workflow Manager and Workflow Monitor.

Develop mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings.

Understanding the data structure and load the data into each client’s region every week after the application build releases.

Data cleansing of any unstructured data.

Writing several complex sql queries which will be used for validation purposes which helps in client’s UAT testing.

Performance tuning of Informatica mappings at mapping, session and workflow level.

Experienced in using several re-usable mapplets.

Scheduling the weekly jobs and monitoring of the jobs at the session and workflow level.

Used Error handling strategy for trapping errors in a mapping and sending errors to an error table.

Fixing the defects/bugs raised by client’s UAT testers.

Experience in production support and Front-end application support to the users.

Magnaquest Technologies Limited Duration: August-2013 to Dec 2015

Project: Retail

Location: Hyderabad, India

Role: Informatica Developer

Environment: MS SQL Server, Oracle 11g/10g

Tools: Informatica Power Center 9.0

Project deals with the Sales and financial Analysis that helps the decision makers to analyze the sales patterns using the various business angles or dimensions. The designed data warehouse is based on Star Schema to accommodate future addition to warehouse without affecting the existing structure and the applications developed.

Roles/Responsibilities and Skill set

Requirement gathering and then develop and design ETL solutions as required.

Understanding the requirement and Data model to develop the mappings accordingly.

Creating High Level Design and Low Level Design documents.

Designed and Developed Informatica Mappings from Scratch to Load the Data from Source System to Staging system and Warehouse System.

Developed many complex Full/Incremental Informatica Objects (Workflows / Sessions, Mappings/ Mapplets) with various transformations.

Writing ETL codes, SQL queries to check the desired results.

Delivering the code on time as per schedule.

Provided technical leadership to the team in order to produce system designs for the framework and code that are scalable, robust, reusable and flexible.

Involved with the Data Modelling team and provided suggestions in creating the data model.

Provide inputs to Project Manager for project planning, providing robust estimates for development tasks.

Contact this candidate