Informatica Developer Data Warehousing

Suresh

****, *********** **, *******, *****

945-***-**** (cell)

***************@*****.*** Senior Informatica Developer

Linkedin- www.linkedin.com/in/suresh-a-670397182

Objective:

To leverage my 11+ years of experience in data warehousing and ETL development to contribute to a dynamic team as a Senior Informatica Developer, driving innovative solutions and organizational growth.

Summary:

Experience: 11+ years in IT, specializing in Data Warehousing and ETL processes..

Worked with various clients in the Banking, Financial, HealthCare and Insurance industries.

Involved in Understanding client Requirements, Analysis of Functional specification, Technical specification preparation, Review of Technical Specification.

Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs and redesign the existing mappings for improving the performance.

Developed Informatica Mappings/Mapplets to extract data from multiple sources, transform data, and then loaded into Operational Data Store (staging area) and then load into Data Warehouse.

Expert knowledge in working with Informatica Power Center 8.x/7.x,Cloud (IICS) versions (Designer, Repository manager, Workflow manager, workflow monitor).

Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer.

Extensively worked on Informatica Cloud and Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Sorter, Sequence Generator, and Normalizer.

Highly experienced in developing, designing, reviewing and documenting Informatica work products like Mappings, Mapplets, Reusable transformations, Sessions, Workflows, Worklets, Schedulers and experienced in using Mapping parameters, Mapping variables, Session parameter files.

Extensive experience in supporting Informatica applications, data extraction from heterogeneous sources using Informatica Powercenter.

Extensive experience in error handling and problem fixing in Informatica.

Designed Complex Mappings and expertise in Performance Tuning.

Experience in troubleshooting by tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings, and session.

Involved in Implementing Slowly Changing Dimensions, Star Schema modelling, Snowflake modeling, FACT tables, and Dimension tables.

Proficient in using Informatica workflow manager, Workflow monitor, pmcmd (Informatica Command line utility) to create, schedule and control workflows, tasks, and sessions.

Experience in different data bases like Oracle, SQL Server, Teradata, PostgreSQL, Red shift, Azure, MY SQL

Good Experience in UNIX and excellent knowledge of Windows Operating system.

Extensively used SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.

Having Experience in Support projects providing 24/7 Production Support

Excellent overall software Development life cycle (SDLC) experience, Conceptual and Logical Thinking, Goal oriented, self-motivated and able to work independently and as a member of a team.

Experience in using different database tools like SQL Developer, DBeaver, and DBVisualizer.

Experience using different file system like CSV, Excel, XML, Json and Flat Files

Quick learner and adaptive to new and challenging technological environments

Education:

Bachelors in computer science and engineering at JNTUK in 2012

Technical Expertise:

Data Warehousing

Informatica Cloud, Informatica Power Center (9.x/8.x/7.x), Power Exchange, OLTP, OLAP

Data Modeling

ERWIN 4.0, Logical and Physical Modeling, Dimensional Modeling (Star Schema, Snowflake)

Databases

Oracle, Teradata, MS SQL Server, Redshift, PostgreSQL, Azure

Programming

SQL, PL/SQL, SQL Plus, Unix Shell Scripting…

Environment

Windows, DOS, UNIX, LINUX

PROFESSIONAL EXPERIENCE:

Project 1:

Sun Smart Duration: July 2020 – Feb 2024

Client: Sun Life Malaysia. Role: Senior Informatica Developer

Company: KGISL

PROJECT DESCRIPTION:

Sun life Malaysia is a life insurance project, which has different channels create Quote and submit the application for the customers. They are web-based applications for Agents & Brokers, Online for Direct customers. Important modules in this project are CFF, Sales illustration and e-App

Roles &Responsibilities:

Worked with Business analysts and the DBA for requirements gathering, business analysis and designing of the data warehouse

Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval

Created Complex mappings using Unconnected, Lookup, and Aggregate and Router transformations for populating target table in efficient manner.

Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Normalize, and sequence generator

Created Mapplet and used them in different Mappings

Used sorter transformation and newly changed dynamic lookup Created events and tasks in the work flows using workflow manager

Developed Informatica mappings and also tuned them for better performance

with PL/SQL Procedures/Functions to build business rules to load data

Developed mappings for policy, claims dimension tables.: Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies

Environment:

Informatica cloud, Oracle 11g, SQL Developer, ERWIN, Autosys, PVCS-Version Management tool, Unix shell scripting, Windows NT, Cognos 8.3

Project 2:

AML Duration: Oct 2019 – June 2020

Client: RHB Bank, Kuala Lumpur, Malaysia. Role: Senior Informatica Developer

Company: KGISL

Project Description:

Anti-money laundering refers to a set of laws, regulations and procedures intended to prevent criminals from disguising illegally obtained funds as legitimate income. Anti-money laundering laws and regulations target criminal activities including market manipulation, trade in illegal goods, corruption of public funds and tax evasion.

RHB AML is a rule driven, risk based approach to solving Anti Money Laundering compliance obligations across multiple Jurisdiction. AML upgrade project is to ensure all the business requirements and specifications are as per business requirements that are generates to evaluate the accuracy of the application/product CDD, WLM, AML are the three main modules in RHB AML upgrade which assess customer Risk and generate alerts with respect to modules which helps to multiple and investigate customers.

Roles &Responsibilities:

Creating Low/detailed level mapping design Documents based on High-level design documents.

Developing mappings using Power Exchange Registration and Data map sources.

Creating Power Exchange Registration maps to capture changes from DB2 tables.

Creating Power Exchange Data maps to get data from Mainframe Datasets.

Used Workflow Manager for creating workflows and Sessions.

Reviewing mappings, workflows and UNIX scripts.

Monitoring the scheduled workflows.

Involved in unit testing and UAT support.

Creating scripts to execute workflows and providing scripts to Maestro scheduling group.

Involved in performance tuning with finding bottlenecks.

Involved in performing full and delta loads.

Leading the production support team with helping team members on critical production issues.

Mentoring team members in developing critical mappings.

Involved in creating flows to perform SCD1, SCD 2 and SCD 3.

Involved in creating complex designs.

Worked on Java Transformation wherever needed.

Project 3:

RPP Duration: May 2018 – Sep 2019

Client: Am Bank, Kuala Lumpur, Malaysia Role: Informatica Developer

Company: SDrops Solutions SDN BHD

Project Description:

Real-time Retail Payments platform (RPP) is a platform, which provides real-time payment services, target at low to medium value payments an available 24x7, responds to the demands of an increasingly online, interconnected world.

Roles &Responsibilities:

Extracted the data from Oracle, Flat files and loaded into Data warehouse.

Developed complex mappings using multiple sources and targets in different databases.

Developed the transformation logic to load data into data warehouse

Used Informatica Designer to create complex mappings using different transformations like filter, lookups, stored procedure, joiner, update strategy, expressions and aggregator transformations to move data to a Data Warehouse.

Scheduling the sessions to extract, transform and load data in to warehouse database, based on Business requirements.

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

Used Informatica for migrating data from various OLTP servers/databases.

Developed reusable mapplets using Mapplets Designer.

Used Triggers, PL/SQL Procedures, Packages and Shell Scripts to apply and maintain the Business Rules.

Scheduled the Sessions and Mapplets using Server Manager to load the data into Target Oracle database.

Involved in 24/7 production support

Conduct UAT with user community and get sign off.

Environment: Informatica Powercenter 7.1, UNIX, Oracle 9i, SQL, PL/SQL, TOAD, Java

Project 4:

EHCRF Duration: June2016 – April 2018

Client: Genpact, Hyderabad, India Role: ETL Developer

Company: Prog9 Soft Tech pvt.lmt

Project Description:

The Developed Application is Electronic Head Count Request Form called EHCRF. The Developing application is EHCRF (electronic Head Count Request Form) which mainly deals in Approval of a Contract / Permanent / Trainee / Temporary / Transfer of Human Resources for all the Departments.

Roles &Responsibilities:

Involved in creation & maintenance of Decision Support System (DSS)

Responsible to develop and testing the software to maintain the data warehouse.

Designed and developed complex Look up, Sequence Generator, Aggregator, Joiner, Router, Rank, External Procedures and Update transformation rules (business rules).

Writing PL/SQL procedures for processing business logic in the database.

Tuning of SQL queries for better performance.

Worked on database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Responsible for monitoring all the sessions that are running, scheduled, completed and failed. If the session fails I have to debug the Mapping.

Involved in testing of Stored Procedures and Functions, Unit and integration Testing of Informatica Sessions, Batches, fixing invalid Mappings

Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.

Involved in writing UNIX shell scripts for Informatica ETL tool to run the Sessions.

Used SQL*Loader to load the data into the table.

Used FTP to transfer the files between UNIX and Windows.

Documented processing times for each module, developed test cases and used them to run through each process.

Environment: Informatica Powercenter 5.1, Oracle 8i, SQL, PL/SQL, SQL*Loader, Shell Scripts, Windows 2000.

Project 5:

Digital Sales Analysis Duration: Jan 2013 – May 2016

Client: Digital Sales Corporation, USA Role: ETL Developer

Company: Prog9 Soft Tech pvt.lmt

Description:

Digital Sales Corporation put its transaction data online using an OLTP system. The transactions are captured at the point of sales, one row of transaction table is used for each purchased item. Digital sales Corp. has 100 stores in different regions of USA, with average of 1000 customers per store. Each customer averages 5 items per transaction. Thus, 500000 rows added to the digital sales database every day. Digital sales turn the data into decisions and launched a data warehouse project

The transaction system and data warehouse are using Oracle 8i as RDBMS. Informatica is used to extract data from non-store data that was stored in the flat files. The star schema model consists of Transaction Fact table with Dimensions namely Customer, Product, Store, Region and Time

Roles &Responsibilities:

Involved in requirement gathering from clients and analysis.

Designed / Developed tables, views, synonyms, indexes, aggregate sqlscripts, Stored Procedures, Functions, Database Triggers, Packages for ETL Processes.

Involved in the code review, unit testing and peer review and documentation.

Involved in the deployment of code in QA and Production Environment

Designing and developing the ETL Mapping Specification based on the Business requirements & specifications and designing the ETL process.

Designing & Developing the ETL mappings using Informatica Power Center Designer as per the requirements

Data extraction from source systems, cleansing & transforming the data in staging and finally loading the data into warehouse schemas.

Performed efficient testing of the ETL mappings and the transformed & cleansed data in Dev and SIT environments to match the user requirements and the data quality in the warehouse.

Designing the mapplets, Reusable Transformations and documentation.

Analyzing the job running time and improving the performance.

Involved in reviews, performance testing and Unit Testing.

Extensively used Expression, Filter, Joiner, Lookup, Router, Aggregator and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs.

Created Sessions, Workflows, Link Tasks, Controls and Command Tasks using Workflow Manager and monitored the workflows using Workflow Monitor.

Designed Business Objects Universes from identified data providers and external cubes based on reporting requirements specifications

Created contexts and aliases to resolve conflicting multiple match paths in universe model

Documented universes, Objects and reports

Performed Unit tests and validates results with Business Analyst and end users

Environment: Informatica Powercenter7.1.1, Business Objects 6.5, Flat Files, Oracle 8i, Windows 2000, UNIX, TOAD, SQL, PL/SQL.

Contact this candidate