Informatica Developer

Summary:

**+ Years of IT experience, working in all phases of Life Cycle of Data Warehouse like Analyzing Data from Various Sources, Data Modeling, ETL Process of data, and Data Presentation to Business Intelligence for Analysis.

Experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 9.X/8.x/7.x .

Have experience with PostgreSQL, Teradata, Oracle 12c/11g/10g/9i, MS SQL Server 2008/2005, DB2, Sybase, Erwin 4.0, SQL, PL/SQL, SQL* PLUS, SQL* Loader, TOAD, Stored procedures.

Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, and FACT and Dimensions tables.

Strong work experience in DWH and Data Mart life cycle development, performed ETL procedure to load data from different sources into data warehouse and data marts using Power Center Repository Manager, Designer, Workflow Manager, and Workflow Monitor.

Experience in Installation and configuration of Informatica PowerCenter & in integration of various data sources like Oracle, SQL Server, Flat files into the staging area and design ETL processes that span multiple projects.

Thorough and detailed understanding of Informatica software architecture, administration and mapping development.

Experience on Realtime Messaging ETL loads like Swift Msgs from MQ, JMS Q’s.

Worked with Type I & II Slowly Changing Dimension and created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and Unconnected Lookups, Filters, Sequence Generator, Router and Update Strategy.

Expertise in implementing complex business rules by creating re-usable transformations, Mapplets, Mappings, Mapping, Session and Workflow Variables.

Implemented Version Control for Informatica workflows, Unix Scripts, Autosys JIL’s, using Perforce/SVN tool and deployed into DEV, STG, UAT, PROD environments using Automic deployment tool by creating respective tags.

Developed Informatica sessions and batches and Automation and scheduling of UNIX shell scripts according to SLA’s using Autosys and Informatica Scheduler.

Implemented ETL/DB Performance Tuning techniques on Targets, Sources, Mappings and Sessions.

Involved in critical migration projects like migrating Informatica 9.1 to 9.6, Oracle 11g to 12c

Experience in Project LifeCycle implementation, Leading Projects, and Postproduction support.

Experienced at creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.

Experience in B2B integration with 3rd party vendor i.e Banks and also generated EDI 810, EDI 820, EDI 827, EDI 997 documents for Banks using Altova Mapforce from their respective XSD’s.

Good experience in creating reports using OLAP tools like Business Objects.

Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.

Technical Skills:

ETL Tools

Informatica PowerCenter 9.X/8.x/7.x.

OLAP/Reporting Tools

Business Objects, Cognos (Impromptu, PowerPlay)

Databases

Oracle 12c,10g, 9i, MS SQL Server 2008, DB2, Sybase,Teradata

Data Modeling

Erwin Designer. 4.0

Methodologies

E-R Modelling, Star Schema and Snowflake Schema

Languages

SQL, PL/SQL, UNIX Shell Scripting

Web Technologies

HTML, XML, Java, JavaScript, PHP, C, C++

Tools/Packages

Toad, MS Word, MS Access, MS Excel, MS PowerPoint

Operating Systems

UNIX, Linux, Windows 2002/ XP/NT

Visa Status : Citizen

Qualification : Bachelors of Technology, JNTU, India – 2002 to 2006

Professional Experience:

Verizon Wireless, NJ Jul 2018– till date.

Sr. Lead Informatica Developer

CCRA (Consumer Commerce Reporting Appl.) receives customers orders data from Point of Sales Database does ETL using Informatica and delivers the extracts to various downstreams EDW, REVO, etc. for Reporting needs .

Responsibilities:

Responsible for new Informatica Server setup for US West region.

Successfully implemented the generalized automated scripts to be used across all workflows for all 4 US regions with environmental variables setup.

Responsible for developing and maintaining development standards like Parameterization, configuring Mail alerts, etc.

Responsible for integrating data from Postgresql, Teradata, Oracle, MS SQL Server and addressing performance load issues.

Follow ups with teams progress on the daily tasks and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Worked with source teams to resolve data quality issues raised by end users.

Created complex mappings using Unconnected Lookup, Sorter, Joiner, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.

Nomura Securities Int’l, NY Jan 2013 – Jun 2018.

Sr. Lead Informatica Developer

Operations IT receives Reference and Transactional data from different source like Broadridge, IMPACT, Bloomberg, NTAPS etc. where it does ETL using Informatica maintaining Datawarehouse, there by building datamart for Reporting needs.

Responsibilities:

Project life cycle - from analysis to production implementation, with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into different targets

Created Reusable Transformations and Mapplets, used them in Mappings to develop the business logic for transforming source data into target.

Developed Realtime Workflows to load MQ messages, parse through XML parser and in turn publish XML messages using XML generator after applying business logic.

Created complex mappings using Unconnected Lookup, Sorter, Joiner, Aggregator, dynamic Lookup, Filter, Update Strategy, and Router transformations.

Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.

Developed post and pre session shell scripts and scheduled Event based sessions at the Informatica workflow manager.

Implemented performance-tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions.

Responsible for identifying the missed records in different stages from source to target and resolving the issue.

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

Used parameters and variables (sessions/mappings) extensively for incremental loads.

Wrote shell scripting for informatica Pre-session, Post-session Scripts using PMCMD command line.

Unit Testing is done at various times to check the validity of the data at each stage.

Analyzed data with discrepancies through Error files and Log files for further data processing and cleansing.

Designed SQL Queries and excel sheets for each mapping of their test scenarios.

Also involved in production support along with designing and development of jobs.

Setting up tasks to schedule the loads at required frequency using Autosys.

Worked with source teams to resolve data quality issues raised by end users.

Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Environment: Informatica PowerCenter 9.1, Oracle 11g, Toad, Windows 2008/SP3, LINUX 5.3

Bank of America, NJ Oct 2011 – Nov 2012.

Lead Informatica Developer

Economic Sanctions Entity Scanning Solutions (ESESS) of the AML technology team will implement the ETL/DQ tools to ingest the Customer data into Customer database, this customer data will be supplied by all the SOR systems on a periodic basis via ftp’ed flat files.

The core functionality of scanning the Customer list and the Watch lists, and performing the matching process will be delivered by Oracle Watchlist Solution (OWS).

Designed and developed complex Informatica mappings to load the Historical data and incremental data from source system to Oracle Server database.

Performed Unit testing and verified the data.

Used Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target in Informatica.

Developed Unit test cases for the jobs .

Written PL/SQL stored Procedures and Functions for Stored Procedure Transformation.

Extensively worked in the performance tuning of ETL mappings and sessions.

Involved in developing Adhoc reports using Business Objects.

Supported Business Objects end-user in areas including software (Designer, Reporting, Web Intelligence, and Publisher) and creating reports.

Environment: Informatica PowerCenter 8.6, Oracle 11g, OWS 8.1, Toad, Windows 2008/SP3, LINUX 5.3

Barclays Capital, NJ MAY 2009- Sep 2011.

Senior Informatica Developer

Regulatory findings compelled Barclays Capital and Barclays Wealth to retain Deloitte to perform an assessment of the effectiveness of its current Anti Money Laundering(‘AML’) Surveillance program. As a result of its analysis, Deloitte recommended new Payment and Trade data feeds, sourcing controls and processes from upstream data providers to be utilised for AML Surveillance by Compliance IT. This AML optimisation project has HORNET DWH and SAM Datamart, which process large number of Actimize feeds from different divisions (US, EUROPE, ASIA etc.) of bank. This will be driven through central ETL architecture and run through real-time, daily, ad hoc batch cycles.

Responsibilities:

Designed and developed ETL strategies and mappings from source systems to target systems. ETL strategies were designed to cater initial and incremental load.

Mappings were developed in informatica employing transformations like SQL, XML, Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router.

Designed and developed complex Informatica mappings to load the Historical data and incremental data into the Hornet DWH and to SAM Datamart from the Legacy Systems to MS SQL Server database.

Implemented CDC (Change Data Capture) through Type II Slowly Changing Dimension methodology for accessing the full history of data.

Experience in migrating the Informatica Objects from Development environment to Test, Stage and Production environments.

Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.

Wrote SQL statements and stored procedures in Oracle for extracting as well as writing data.

Used Informatica Power center workflow manager to create sessions, batches to run with the logic embedded in the mappings.

Wrote Shell Scripts for Informatica Pre-session, Post session Scripts.

Performed Unit testing and verified the data.

Designed and developed a strategy for a specific and vital reporting need.

Environment: Informatica PowerCenter 9.1, Oracle 11g, SQL Server, DB2, Toad,

Erwin, Business Objects 6.1, Windows 2008/SP3, LINUX 5.3

NY Department. Of Finance, NY Aug 2007-April 2009.

Informatica Developer

NY-DOF is undertaking a transformative initiative, known as the Citywide Payments & Receivables Program, to make the entire payment process easier for any individual or entity making payment to the City and optimize the City’s management of the full life cycle of accounts receivable, from origination through to settlement. The goal of this project is Citywide Payments and Receivable Repository integrate agencies receivables and send remittances from PSP to the agency. CPRR also integrates with NYC Financial Information System (FISA/FMS) to send consolidated remittance information on behalf of agencies.

Responsibilities:

Extracted data from sources like DB2, SQL server, and Fixed width and Delimited Flat files, EDI 810,820,827,997doc’s. Transformed the data according the business requirement and then Loaded into Oracle database.

Experience in B2B integration with 3rd party vendor i.e Banks and also generated EDI 810, EDI 820, EDI 827, EDI 997 documents for Banks using Altova Mapforce from their respective XSD’s.

Implemented Type II Slowly Changing Dimension methodology for applying the disposition logic involving Inserts, Updates and dynamic Deletes.

Created and Monitored Workflows to run Session tasks using Informatica Server.

Created Worklets and setup Workflow and Tasks to schedule the loads at required frequency using Workflow Manager.

Used pmcmd commands for stopping and starting workflows and tasks.

Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.

Performed Performance tuning and optimization of mappings and session.

Created reports using Business Objects functionalities like queries, slice and dice, drill-down, cross-tab, master detail and formulas. Emphasis was on a design to support current reporting.

Environment: Informatica PowerCenter 8.x, Oracle 10g, SQL Server, Toad, Windows 2000, UNIX.

Infotech Enterprise Ltd., India. Jun 2006 – Feb 2007

Database/ETL Developer.

Infotech is a global IT services provider servicing Global 2000 clients in the Manufacturing, Insurance, Banking and Financial Services, Telecom, Retail, Energy & Utilities, Logistics & Transportation, Media & Entertainment industries. We developed MIS Package using Oracle Developer as software to maintain all the information starting from Raw material information to sales. This Package consists of five modules Inventory Management, Accounts, HRMS, Production and Sales Monitoring.

Responsibilities:

Involved in the coding of Stored Procedures and Triggers using PL/SQL for various Business Requirements.

Designed and developed all the tables, views for the system in Oracle.

Involved in Data Loading and Extracting functions using SQL*Loader.

Implemented various validation rules on the data by applying various integrity constraints as well as data validation rules.

Reducing the bottlenecks helping the query to execute by dropping or creating the indexes as per required.

Worked on Informatica – Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets, and Transformations.

Implemented Aggregate, Filter, Join, Expression, Lookup, Update Strategy, and Stored Procedure Transformations.

Involved in the development of Informatica mappings and also tuned them for better performance.

Creating and running sessions and batches using Workflow Manager to load the data into the Target Database.

Environment: Informatica Power Center 7.1,Oracle 8.0, SQL*Plus, SQL*Loader, PL/SQL, Windows NT.

Contact this candidate