Sign in

Informatica Developer

Springfield, Massachusetts, United States
September 26, 2018

Contact this candidate



802-***-**** /


* ***** ** ********** ** design, analysis, development, documentation, coding and implementation including Databases, Data Warehouse, ETL Design, Oracle, PL/SQL, SQL, SSIS, Informatica 9.x/8.x/7.x

Experienced in all phases of the Systems Development Lifecycle- Analysis, Design and Modeling, System Implementation, System Testing, Acceptance and Maintenance

Involved in the migration from Oracle to Teradata Database using Informatica power center

Experienced in performance tuning of mappings, sessions and workflows including partitioning using Informatica Power Center

Working experience on Informatica installation & configuration, up gradation and hot fixes patches and maintaining Informatica software Power Center 10.x in support of business processing requirements.

Experienced in Profile Analysis Standardize Clean Integrate Score Carding Marge Match Reference Data from various source systems using Informatica Data Quality IDQ Toolkits.

Cleansing and processing data from stage to data marts using Informatica transformations.

Performed all Informatica administration functions such as user access accounts, roles, privileges and LDAP configuration.

Experience in Performance Tuning and Query Optimization.

Monitored ETL workflows and logging, providing job reports and status as required.

Performed ETL failure recovery when required

Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas using Ralph Kimball Methodology.

Experience in BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files

Involved in the migration from Oracle to Teradata Database using Informatica power center

Experience in Database Development, Data Warehousing, Design and Technical Management, Involved in functional and technical Systems Analysis & Design, Systems architectural design, Presentation, process data flow design system impact analysis, Gap analysis and documentation

Understanding of Ralph Kimball approach and experience in Dimensional data modeling, Star schema modeling, Snow-Flake modeling, identification of fact and dimension tables, Normalization.

Developed and tested all the backend programs, Informatica mappings and update processes.

Used Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status.






Data Mining / Reporting Tools

MS Excel, SAS, R, Tableau, Informatica, SAP, SSIS, SSAS, SSRS, OBIEE


Agile, UML, SDLC, Waterfall

Modeling Technique:

Predictive Modeling and Linear Regression


Salesforce, Bugzilla, HP ALM, Quality Center 9.2, JIRA 4.1/4.0


MS SQL Server (2012/2008/2005/ 2000), Oracle 10g, 11g

Process/Model Tools:

MSOffice 365, MS Project, MS Visio, MSWord, MS Excel, MS PowerPoint, Rational Rose, Requisite Pro, Clear case, Clear quest


MassMutual Life Insurance - Springfield, MA Aug 16 – Till Date

Informatica Developer/Admin

Broker Dealer Migration

Massachusetts Mutual Life Insurance Company (MassMutual) is an American mutual life insurance company serving five million clients.

MassMutual acquired Metife's Premier client group which has almost a Million new customer base and I was part of Broker Dealer Migration which involves more than 37 Million Customer records.

Interacted with business users and team leads for better understanding of business specifications and requirements, Identifying data sources and development strategies.

Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, and Source Qualifier.

Responsible to monitor and keep the health of Informatica services, OBIEE services

Worked with data analyst to figure out the business logic that needs to be implemented in the warehouse day to day load.

Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure and Sequence generator, Joiner, Union and Normalize.

Optimized and implemented the complex business rules by creating re-usable transformations.

Extensively worked in the performance tuning of programs, ETL procedures and processes.

Developed multiple ETL processes to synchronize data between Legacy and New systems, moving in both directions (Old to New and New to Old).

Wrote Optimized SQL queries, PL/SQL procedures and Shell Scripts.

Generated various reports using Business Objects 6.5 functionalities like Queries, Slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and Formulas as per client requirements.

Developed complex reports, multi-query reports and sub selects queries to meet the client requirements.

Building dashboard and reports to check any job failure in ETL front.

Environment: Informatica Power Center 9.5.1/9.6.1, FLATFILES (Fixed width and Delimited), TOAD, Oracle 11g, UNIX, WinSCP, SQL, PL/SQL, MS Access, Teradata SQL Assistant.

Infosys Limited, Chennai, India Nov 10 – Jul 15

ETL Data Developer

Project 1(Discover Financial Services), FINACLE

When Discover Financial Services introduced the first cash rewards credit card in 1986, we committed ourselves to meeting the needs of our card members with the best possible customer service - and we still stand by that commitment today. We're building our company by listening to consumers and developing products and programs that help them get the most for their money. Beyond credit cards, our banking and payments businesses offer rewarding products backed by that same commitment to high-quality service that we have had from the start.

Created UNIX Shell Scripting for automation of ETL process.

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, lookup, Derived Column task and Script Task in SSIS Designer.

Coordinated and developed documentation related to ETL design and development, prepared the ETL best practices document.

Involved in Technical Documentation, Unit test, Integration test and writing the test plan.

Used SSIS to unite data from existing system and performed transformations on MS SQL 2008.

Experience in creating complex SSIS packages using proper control and data flow elements with error handling.

Designed Data flows, Workflows and jobs to load data from source to target in BO Data Integrator.

Enhancing and deploying the SSIS packages from development server to production server.

Designed and built OLAP cubes to meet reporting needs.

Performed Documentation for all kinds of reports and DTS and SSIS packages.

Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS). Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS).

Created complex SSIS packages using proper Control and Data flow elements.

Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.

Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages.

Involved in migration from SQL Server 2005 to SQL Server 2008.

Extensively used SSIS Import/Export Wizard for performing ETL operations.

Tracked and supported Agile project with daily stand ups, meeting minutes and Burndown chart.

Performed & tracked UAT of integrated modules and completed Logging & Tracking Defects in JIRA.

Scripted SQL queries for data analysis and data extraction during UAT to cross verify the database records.

Environment: Teradata Database, UNIX, Windows server 2003, Informatica PowerCenter 9.x, Automatic UC4, Unix shell programming, Teradata, DB2, Oracle 11g/10g, SQL, PL/SQL, SQL Developer.

Project 2 (Emirates NBD), FINACLE

Emirates NBD, the leading banking group in the region, formed in 2007 when the shares of Emirates NBD were officially listed on the Dubai Financial Market (DFM). The Emirates NBD 2007 merger between Emirates Bank International (EBI) and the National Bank of Dubai (NBD).

Designed ETL solutions and data conversion strategy and solutions for multiple systems.

Created end-to-end solution for ETL transformational jobs that involve writing Informatica workflows and mappings, and creating database procedures and functions.

Experienced with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using Control-M or Autosys.

Developed, maintained, and enhanced Informatica Mappings, Work-flows, and processes.

Supported proper functioning and performance tuning of Informatica platform.

Developed stored procedures and triggers using Oracle database to support ETL jobs.

Provided production support from development teams for existing systems, troubleshoot data and/or system issues.

Reviewing the ETL process design & ETL design documents with the business analysts, end users, data quality team and enterprise test team.

Worked extensively on Informatica transformations like Source Qualifier, Expression, Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure and Sequence generator, Joiner, Union and Normalize.

Worked with ETL team to perform Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for data loads and Data cleansing

Extracted data from various sources like Oracle 9i, DB2UDB and relational databases Developed complex mapping in order to implement Change Data Capture (CDC)

Performed Optimization of the mappings, sessions and used Debugger making use of Breakpoints to monitor data movement and troubleshoot the mappings.

Effectively documented all Development work done.

Extensively worked in the performance tuning of programs, ETL procedures and processes.

Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from and to different servers.

Extensively used PL/SQL Procedures/Functions to build business rules.

Environment: Informatica 9.1 (Designer, Repository Manager, Workflow Manager, Workflow Monitor), Teradata, UNIX, Citrix, Toad for Oracle, Tectia Client, PL/SQL Developer

Contact this candidate