Resume

Sign in

informatica developer

Location:
United States
Posted:
February 28, 2018

Contact this candidate

FENA KANSAGARA

ac4nig@r.postjobfree.com * 972-***-****

PROFILE

* ***** ** ********** ** development of Data warehousing solutions using Informatica.

Experience in all the phases of Data warehouse life cycle involving Design, Development & Analysis and Testing of Data warehouses using ETL Concept and Informatica 9.X

Excellent technical and analytical skills with clear understanding of data architecture, metadata, data lineage docs, DW artifacts, design goals of ER modeling using ER/Studio for OLTP and dimension

Modeling for OLAP

Practical understanding of the Database schemas such as Star Schema and Snow Flake Schema used in relational and dimensional modeling.

Strong knowledge of Entity-Relationship concept, facts, dimensions tables and slowly changing dimension.

Experience in working with various data source like SQL Server, MySQL, Oracle, TOAD, IBM Netezza, XML, Excel, Flat Files and CSV files.

Experience in database scripts such as SQL queries, PL/SQL Stored Procedures, Indexes, Functions, Views, Materialized views and Triggers.

Hands on experience in tuning mapping, identifying and resolving performance Bottleneck in various levels like sources, targets, mappings and sessions.

Experience in creating effective test data and development through unit test cases to unsure successful execution of data.

Highly skilled at communicating ideas to superior executives and working in a cross-functional team while building cohesive relationships with both internal and external partners.

Committed with an unwavering passion for company growth through proactive, methodical, persuasive, and people management skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center Version 9.X

Database: Oracle, SQL Server 2012/2008, IBM Netezza 7.0, TOAD.

Operating System: Windows 2000/Xp, Unix

Data Modeling: ER-Win v 4.0,

Supporting Tools: SQL * Loader, Red gate, Putty, WinSCP, Remedy

PROFESSIONAL EXPERIENCE

Project: Anaplan, Clients and Distribution System April 2016 - Sep 2017 Client: XL Catlin

Role: Informatica Developer

Project Description:

XL Catlin is an insurance and reinsurance companies, which provide property, casualty, professional and specialty products different industries. This project included various subject areas such as finance, claim, underwriting and billing. On the basis of different business rules, we need to prepare test data for each of the report.

Responsibility:

Adequately taking responsible for requirement gathering and low-level design document creation.

Consistently involving in development and enhancements of mappings, sessions and workflows as per business requirements.

Efficiently develop Informatica mappings using various transformations like Source qualifier, Expression, Update Strategy, Lookup, Filter, Router, Joiner, Aggregator, Normalizer and mapplet.

Fully maintain the log tables using Pre-source load and Post-target load SQL commands.

Effectively working with various source/target systems like relational, flat file and CSV files. Also worked with dynamic source files using the concept of indirect file.

Successfully implement logic for validating and processing the input files and depending on the session execution status moving them to the appropriate folders.

Actively optimize performance of code through performance tuning and push-down optimization.

Effectively create standard review document and performed review of code to check if it maintains the coding standards and meets the business requirements.

Consistently testing data between Source and Target through minus query and preparation of Unit Test case documents.

Adequately creating and labeling Deployment groups and preparing Release document for the same.

Environment:

Informatica Power Center Version 9.X, IBM Netezza 7.0, Microsoft SQL Server 2008 R2, Jira, Unix, MS Office 2010. Excel

Project: Combined Operational Data Store, Closed Efficiency July 2014 – April 2016

Client: Catlin

Role: Informatica Developer

Project Description:

Catlin is an insurance and reinsurance companies, which provide property, casualty, professional and specialty products different industries. This project included various subject areas such as finance, claim, underwriting and billing. On the basis of different business rules, we need to prepare test data for each of the report.

Responsibility:

Involved in requirements gathering phase, low-level design, build and unit testing of ETL mappings.

Code optimization and performance tuning of the Informatica mappings. Adhering to the Informatica build standards and best practices.

Creating mappings, workflows, sessions and analyzed the source s, targets, transformed the data, mapped the data and load the data into the targets using Informatica.

Transformations like Expression, Router, Joiner, Lookup, Update Strategy, and Sequence Generator are mainly used.

Creating the reusable mapping using mapplet designer and those mapplet are used in mapping.

Creating the parameter files and the list files, which is used by the workflows.

Unit testing for every component worked upon.

Major successive enhancements post deployments part of Quality control.

Communicating with the Designers, Quality Analysis team for technical and functional issues.

Involved in the code review for optimization and the defect prevention.

Involved in the peer Reviews of the Mappings.

Monitoring all the jobs related to Informatica and UNIX.

Worked on production support issues and activities.

Environment:

Informatica Power Center Version 9.X, IBM Netezza 7.0, Microsoft SQL Server 2008 R2, Jira UNIX MS Office 2010. Excel

PROFESSIONAL EXPERIENCE CONT’D

Project: Customer Experience Dashboard March 2013 – July 2014

Client: CISCO

Role: Informatica Developer

Project Description:

Customer Experience Dashboard, based on customer feedback; customer sentiments, satisfaction and expectation are tracked which help the organization to grow in right direction based on preset goals and threshold.

Responsibility:

Made creation of Tidal Jobs for scheduling packages and data manager job.

Developed package to automate process of loading production tables.

Monitored and scheduled daily ETL jobs handle failure and provide production support.

Involved in the incident Management, Ticket/Tag Escalation, Completion and Closing.

Identified the change requests and modifying the code in a precise manner.

Worked on Job failure as well as Data Issues and resolve the issues within the SLA.

Worked on Stored procedure used to execute to load data for production tables on daily basis.

Maintained an issue log along with status tracker and providing daily updates.

Handled the break fixers and enhancement as a part of releases and change request tasks.

Environment:

Informatica Power Center Version 9.X, Oracle-10g, SQL Server 2008, TOAD, Unix, Putty, Wincp, Remedy, Tidal, Windows 2000/Xp, MS Office 2010. Excel.

Project: PRM (Public Record Maintenance) July 2013 - March 2013

Client: Wolters Kluwer- CTLien Solutions

Role: Informatica Developer

Project Description:

Wolters Kluwer-CTLien solution is an industry in providing solutions for claims on assets for lending and financial services. At its core, its assets are public records. i.e. history. Public records are obtained from several sources, mostly directly from the state, the default recoding agency and s from external data providers.

Responsibility:

Involved in designing and building data marts for provider division.

Loaded data to the stage tables in oracle from multiple data sources using Informatica.

Designed data transformation from staging to fact and dimension tables in the warehouse.

Implemented variables and parameters in transformations for incremental data extraction and complex transformation logic.

Created mappings between source and target using Informatica power center designer.

Used mapping and mapplet designer to generate different mappings for different loads.

Created transformations like source qualifier, joiner transformation, filter, update strategy, lookup transformation, rank transformations, expressions, aggregator and sequence generator to load the data from staging area to ODS and to DW in oracle.

Created, scheduled and monitored sessions and batch process based on demand and run only once using Informatica server manager.

Environment:

Informatica Power Center Version 9.X, Oracle-10g, SQL Server 2008, TOAD, Unix, Putty, Wincp MS Office 2010. Excel.

EDUCATION

Bachelor of Information Technology

Bharati Vidyapeeth College of Engineering, Pune, India

REFERENCE

AVAILABLE UPON REQUEST



Contact this candidate