ETL Informatica Developer

S.MADHUSUTHANAN

Contact no – 469-***-****

mailto:ac0unw@r.postjobfree.com

9.6 years of IT experience in Analysis, Design, Development, Implementation, Testing of Data Warehousing and Data Integration Solutions using Informatica Power center and in Solaris server Administration & in Shell scripting.

Strong business understanding of verticals like Banking, Insurance, Retail and Healthcare.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources systems into data warehouse using Informatica Power Center.

Extensively worked in Performance Tuning, Error handling, Oracle query optimization, Product support on various Platforms.

Documentation: Expertise in preparing the ETL Design Documents like High Level, low level Design documents, Technical design documents and Source to Target Mappings.

Broadly worked in different debugging techniques like the Informatica debugger, creating temporary tables and session logs to resolve complex issues.

Experience in working with PDO [Push down Optimization] and Partitioning.

Experienced in debugging and performance tuning of sources, targets, sessions and map level bottlenecks in Informatica.

Implemented CDC for mappings so as to capture the changes and maintain history.

Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

Proficiency in developing SQL with various relational databases like Oracle, SQL Server.

Experience in developing UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Comprehensively worked in scheduling the workflows through Job scheduler using UNIX scripts and for automation purpose and information gathering.

Independently perform complex troubleshooting, root-cause analysis and solution development.

Experience in developing UNIX scripts Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.

Experience in creating the Dashboard and Report level prompts.

Comprehensive technical, oral, written and communicational skills.

Extensively worked in planning, organizing, prioritizing multiple tasks in order to meet the deadlines.

ETL Tools : Informatica Power center 9.6.1/9.5/9.1/8.x/7.x

Operating Systems : UNIX, Windows 98/ NT/2000/XP, Solaris 9, 10.

Database : Oracle 10g/9i, SQL Server.

Database GUI Tools : TOAD

Web Development : HTML

Programming Languages : SQL, UNIX Shell Script.

Supporting Tools : Microsoft Visio

Software Engineering Tools : Toad, Putty, Remedy, Tivoli.

Kaiser Permanente Oakland, California, U.S

Informatica Senior Developer Feb 2015 - May 2017

Project: The purpose of the project is to build a Data Warehouse for analysis, dashboards, reporting and exploration that transforms massive amounts of data into intelligence reports and effectively to make information available to KAISER Permanente customer who needs it.

Environment: Oracle 11G/R12, Informatica 9.1.1/9.5.0 SQL, TOAD, AIX, AS 400, UNIX, Business Objects 6.5, TOAD, IBM TIVOLI.

Responsibilities:

Involved in requirement Gathering and analysis of source data as data comes in from different Source systems.

Development of ETL mapping using Informatica 8.6 & 9.1 & 9.5.

Data integrity between the various source tables and relationships.

Check for missing data, negatives and consistency. Field-by-Field data verification can be done to check the consistency of source and target data.

Applied slowly changing dimensions like Type 1 & 2 effectively to handle the history loads.

Prepared various mappings to load the data into different stages like Landing, Staging and Target tables.

Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.

Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Oracle for optimal performance.

Prepared the error handling document to maintain the Error handling process.

Created Test cases for the mappings developed and then created integration Testing Document.

Developed Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results using workflow monitor.

Prepared SQL Queries to validate the data in both source and target databases.

Prepared scripts to email the records that do not satisfy the business rules (Error Records) to the uploaded business users.

Prepared the UNIX Shell Scripts to process the file uploads, one of the SOURCE for the data that process the uploads into different stages (Landing, Staging and Target tables)

JCPenney, Plano, Texas, U.S.

Informatica Senior Developer Feb 2014 - Feb 2015

Project: The project was to build a Data warehouse for operational and strategic reporting. The project was to design, develop and maintain Enterprise data warehouse. The objective is to integrate different source systems into homogeneous environment to build Enterprise Data Warehouse. The goal of the project is to better decision making with appropriate data views.

Environment: Informatica Power Center/ Power Mart 8.5.1/7.1.4, Oracle 11g/10g/9i, SQL,

AS 400, Solaris 10, Business Objects 6.5, TOAD, IBM TIVOLI.

Responsibilities:

Developed ETL programs using Informatica to implement the business requirements.

Communicated with business customers to discuss the issues and requirements.

Developed ETL mappings, transformations using Informatica Power center 9.1 / 9.6.

Worked with power center tools like Designer, Workflow Manager, Workflow Monitor and Repository Manager.

Extensively worked in migration projects from Sybase database to Oracle database.

Extensively used Various Data Cleansing and Data Conversion Functions in various transformations.

Extensively used Informatica Transformation like Source Qualifier, Rank, SQL, Router, Filter, Lookup, Joiner, Aggregator, Normalizer, Sorter etc. and all transformation properties.

Performance tuning was done at the functional level and mapping level. Used relational SQL wherever possible to minimize the data transfer over the network.

Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.

Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Created automation shell scripts to fine tune and process the file uploads during ETL flow of the Informatica workflows.

J.P. Morgan Credit Card, New York, NY, U.S

Informatica Developer Feb 2012 - Jan 2014

Project: The international payment card associations, MasterCard and Visa, release business operations and system processing modifications for card issuers, acquirers and processors. Each release details processing standards to which issuers/acquirers and their processors must adhere in order to remain compliant with association rules and regulations for the acceptance of credit/debit cards.

Environment: Informatica Power Center 8.x (Meta-Data Repository, Designer, Server Manager), Oracle9i/8i, Teradata, SQL,UNIX Shell Script, IBM AIX, Win 2000/NT. TOAD, IBM TIVOLI.

Responsibilities:

Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.

Implemented Slowly Changing Dimensions to maintain current information and history information in dimension tables.

Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.

Broadly worked on parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.

Identified the aggregate levels for measures and created dimension hierarchy sources for each level of aggregates for performance enhancement.

Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.

Created E-mail notifications tasks using post-session scripts.

Performing UAT in delivering the Product.

Created procedures to drop and recreate the indexes in the target Data warehouse before and after the sessions.

American International Group (AIG) Treasury, New York, NY

Informatica Developer Jan 2009 - Jan 2012

Project:

AIG Insurance is one of the largest life insurance companies in United States in providing diversified financial solutions, including life insurance, disability income insurance, retirement services, employee benefits, and investments. As a part EDW/BI team, we were responsible for creating analytics warehouse for OBIEE reporting.

Environment:

Informatica PowerCenter 7.x, Oracle 8i, SQL, shell scripts, Sun-Solaris and Windows NT.

Responsibilities:

Involved in Designing the specifications, Design Documents, Data modeling and design of data warehouse.

Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.

Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner and Connected and Unconnected lookups, Filters, Sequence, Router and Update Strategy.

Worked on Riskless Principal Model and generate the Alerts.

Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).

Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.

Involved in the development of Informatica mappings and also performed tuning for better performance.

Extensively worked on tuning (both Database and Informatica side) and thereby improving the load time.

Extensively worked on parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.

Created Mapping Parameters and Variables.

Automated the entire processes using UNIX shell scripts.

Tested the target data against source system tables by writing some QA Procedures.

CITI Bank INC, New York, NY, U.S Oct2007 - Dec 2008

Solaris Administrator

Platform - Solaris 9 & 10, Linux .

Responsibilities:

Responsible for UNIX server administration and support, including scripting of various tasks to streamline administrative functions and automate system management.

Maintained and obtained production web environment availability and systems security.

Created and maintained documentation for critical systems and procedures.

Maintained and obtained recoverability and backups.

Installed, configured and supported Solaris and application servers.

Communicated and worked with the individual application development groups, DBAs and the Operations.

Assigned to selected projects and successfully defined hardware and software needs to complete them.

Provided root cause analysis of incident reports during any downtime issues.

Contact this candidate