Informatica DW Developer with 15+ Years Experience

Professional Summary:

• **+ years of Experience as Developer and coordinator in the Data Warehouse Domain working with Informatica 10.2/9.0x/8.6x/7.x (Source Analyzer, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer, Repository Manager, and Workflow Manager/Server Manager).

• Implementation of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD and Dimensional Modeling.

• Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools, Task Developer, Workflow & Worklet Designer.

• Extensively worked with different data sources non-relational databases such as Flat files, XML files, and other relational sources such as Oracle, Redshift, SQL Server, DB2, and Teradata.

• Extensively used AWS services like S3, Redshift, IAM.

• Comfortable in both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.

• Expertise in creating mappings, mapplets and reusable Transformations using Informatica Designer.

• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.

• Expertise in doing Unit Testing, Integration Testing, System Testing and Data Validation for Developed Informatica Mappings.

• Involved in supporting production roles fixing data discrepancy or mapping issues.

• Excellent Analytical, Communication skills, working in a team and ability to communicate effectively at all levels of the development process.

• Extensively worked with different Teradata utilities like Bteq, Fastload, Fastexport, Mload

Technical Skills:

Domain Skills

Healthcare, Insurance, Pharma, Banking

Functional Skills

Requirement gathering

Designing the ETL frameworks

Reviewingcode, debugging and troubleshooting the application

Providing post-implementation, application maintenance and enhancement support to the client

Consulting Skills

Business Process Improvement and Workflow Reengineering

Requirements analysis, business analysis, scoping, planning and implementation roadmap development

Technical Skills

Tools: Informatica: Power Center 8.1, 8.6. & 9.6.1, 10.0, 10.2

Database: Redshift, Teradata, Oracle PL/SQL, DB2 SQL

Teradata UTILITIES (Fast Load, mload, Tpump)

AWS Services: Redshift, S3, IAM

Others: Rally, Reporting Tools (BO, Qlikview, Qlik), MS Office (Visio, PowerPoint, Word, Excel, Onenote)

TOAD, HP-QC & QA Center, Service Now, Control-M, Autosys

Operating Systems

Windows 9x/2000/XP, Linux, UNIX

Professional Experience:

Bank of America, Jersey City, NJ Dec 2022 – Present

Project 1- Client Data Capture

Responsibilities:

Analyze the risk and financial impacts related to different sectors client data.

Gather data which can help in developing Client information dashboard

Discuss different metrics/implications with Product Owner and Consumers

Prepare technical specs and develop process for Data warehouse loads

Work on ETL process to integrate data for different sectors like Cement, Aviation etc. and different use cases like FE, EUT

Implement data controls and quality checks on Client data

Performance tuning of the ETL process for efficient data pipelines.

Created triggers to load Emission related data into the History tables from the Application tables that are being loaded from the UI

Created views on the history, fact and dimension tables for the Business Team

Created Procedures and Packages to load the Dimension and Fact tables

Automated the process to load the respective Fact tables and Business views to handle the existing use cases and for the future use case to come.

Project 2- Target Management

Responsibilities:

Created Oracle Table Functions, Stored Procedures, Materialized Views to read data from the API and perform calculations of the Sector level values and Scope level values. This helped the Business Users to perform ‘What-If’ scenarios for the Auto, Aviation, Energy, Cement portfolios.

Coordinated with Business Users, API Teams, UI Teams for different levels of Performance Testing, Integrated Testing

Project 3- Climate Risk

Responsibilities:

Analyzed the feed coming into ADS via various source systems

Designed and Implemented various controls for Job Framework

Designed and Implemented CTRL2 process that would keep in check the SLA of various feeds coming into ADS system using iXp, UNIX, Autosys, Oracle

Implemented CTRL8 File Layout for various file feeds using UNIX, Oracle, Informatica

Implemented CTRL6 checks for various feeds coming into ADS

Designed and Implemented Downstream SLA process using PL/SQL Stored Procedures, Oracle to track the SLA of the files coming from various source systems and also track down the timeline when they are being loaded into the Stage and also the time line when the data should be available to the Downstream in turn.

Cognizant Technology Solutions Apr 2012 – Oct 2022

Company: CTS Client: The Hartford, Hartford, CT (Remote) Jun 2020 – Oct 2022

Role: DW Lead

Environment: Informatica 9.6, Informatica 10.2.1, Oracle, PL/SQL, ServiceNow, Autosys, JIRA, UNIX, Shell Scripting Linux Environment, Talend, GitHub, Jenkins, UDeploy, Snowflake, TOAD, Talendcloud, Putty, WinScp, Microsoft Visio

Responsibilities:

Study and Analysis on existing process for Group Benefits.

Capture Business Requirements from meetings with users and data management

Designed the Functional Design Specification document, test cases, test data characteristics and scenarios

Lead the team in ETL Design and development of Mappings, Sessions, Worklets, Workflows

Developed and Supported Procedures & Functions in Oracle to support Data Mart load.

Developed PL/SQL scrips in Oracle & Db2 to perform ETL operation for claim management.

Created Implementation-plan and replicated code changes in Oracle Stored Procedures as part of data mart load.

Created Packages to deploy the codes in Oracle server to support the ETL framework and invoked the Procs through crontab.

Onshore -Offshore co-ordination for all project related activities like ETL design and reporting co-ordination for warehouse Modelling.

Performed Procedure changes for ETL data load and integrated with Informatica to facilitate Life claim management migration.

Migrated Informatica objects from Development Environment to Testing Environment and then to Production Environment.

Involved in Performance tuning and optimization. Used Push down Optimization.

Created Implementation-plan and were in alignment with code migration team during production implementation

Engaged the code with Job scheduler using Autosys

After successful warranty support for 90 days, handed over code to support team giving Knowledge transition.

With the issue faced during warranty support created issue log and their resolution for future reference.

Done over project documents and user manual for support team for clear understanding.

Identified performance bottlenecks and provided inputs on best practices on ETL and across applications to benefit Customers and help account teams to resolve technical challenges.

Extensive experience in SDLC process and Strong proficiency to convert business requirements and challenges into deliverables with value add

Company: CTS Client: Novonordisk, Plainsboro, NJ Oct 2017 – Jun 2020

Role: DW Lead

Environment: Informatica 9.6, Informatica 10.2.1, AWS Redshift, AWS S3, GreenPlum, ServiceNow, Autosys, JIRA, UNIX, Shell Scripting Linux Environment, Putty, WinScp, Microsoft Visio, Erwin

Project 1: InfluenceRx

This interface is related to data exchanges between the Commercial Data Warehouse and Adobe Campaign where HCPs are ranked based in brand/class/sub-class driven numeric threshholds and strategies calculated in CWD from incoming IMS data. The Commercial Data Warehouse will send the list of HCPs that qualify per the rank calculation, to Adobe Campaign on a monthly schedule. The Business impact of an interface failure would be that HCPs writing prescriptions for NNI and competing brands will not receive timely communication designed to further HCP engagement and loyalty and increase script volumes.

Project 2: Relevate

This interface is related to data exchanges between CDW and Relevate. On daily basis, CWD will send standard import files of event and event attendees to Relevate.

Project 3: MINE (Marketing Insight Engine)

MINE is a DW/BI application that integrates and visualizes the AHM Interface program data, and the data that resides in the internal environment of Novo Nordisk, including organization, rep calls, and customer information etc. MINE enables the HCP engagement team to monitor and improve the performance of the various speaker programs

Project 4:: Modern Datawarehouse – AWS Migration

The scope of the project was mainly ETL Development/Migration activities as part of DB migration from Greenplum to Redshift. The ETL’s where executed as DB function in Greenplum which had to be converted to Informatica ETL mappings to populate respective tables in Redshift. The Project gave an opportunity to get a real time hand-on exposure to AWS tools like Redshift and S3.

Responsibilities:

Gathering and tracking the business requirements

Designing the ETL framework which loads the data from flat files to AWS stage tables and then to the integration layer in Redshift

Used AWS copy command to load data from files to stage tables.

Review of all the deliverables to ensure quality

Defining and Designing the ETL Process

Coordinating between the BI teams and ETL developers

Involved in creating and reviewing mappings/workflows in Informatica Power Center 10.2

Involved in the extraction, Transformation and loading of data from flat files and various databases

to target tables.

Created the mappings using transformations such as the Source qualifier, Aggregator,

Expression, Lookup, Router, Filter, and Update Strategy.

Extensively used transformations like connected and unconnected lookup.

Created reusable transformation and mapplets in the designer using transformation developer and

mapplet designer according to business requirements.

Worked on Informatica Power Center tool–Source Analyzer, Warehouse designer, Mapping and

Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Workflow

Manager

Slowly changing Dimension techniques like SCD Type1, Type2 are applied as per the business

need.

Created and scheduled Sessions, Jobs based on demand, run on time and run only once using

Workflow Manager.

Extensively used Informatica Workflow Manager and Workflow Monitor for creating and

monitoring workflows, worklets and sessions.

Used Debugger in troubleshooting the existing mapping.

Automation of manual efforts like Automatic mail alerts on workflow success, error log mail

trigger,etc.

Work closely with Business stake holders to understand their business needs and translate it to

technical solutions.

Company: CTS Client: Express Scripts, Franklin Lakes, NJ Apr 2012 – Aug 2017

Role: DW Developer / Lead

Project1: Specialty Distribution, Specialty MIgration

CSD produces extensive reporting for both its core LOB for Rare Disease Specialty Distribution to assist in making key business decisions to monitor the daily operation of the business, and for the customers and vendors to meet various financial and contractual obligations. CSD relies upon its Enterprise Information Warehouse(EIW) and Business Objects and Tableau reporting application to produce these reports. The data in the EIW does not currently support CSD’s reporting needs. The data is an incomplete representation of the source system and not structured in a manner which facilitates the rapid deployment of reports and data visualizations. The system also does not contain updated summary KPI data and inclusion of this type of data would materially improve the accuracy and timeliness of metrics reporting across the organization.

Environment: Informatica 9.6, DB2, Teradata 14.10.0.04, 15.10.02.10, ServiceNow, Autosys, JIRA, UNIX, Shell Scripting Linux Environment, Putty, WinScp, Microsoft Visio, Erwin

Responsibilities:

Involved in understanding the business requirements and Reviews of Technical Specifications

Preparing the design documents, logical and physical models

Coordinate with the DBA, Data Modeller to get the required tables created

Designed the high level and low level ETL architecture

Coding and peer reviews

Test cases and Unit testing

Migrating the code to the other environments for CAT and other testing

Actively involved in QA and Production bug fixes

Supporting IT group with performance tuning of ETL codes and DB issues

Involved in scheduling the batch jobs in Cron and Tivoli Workload Scheduler

Played the role of onsite coordinator and maintained the day to day activities between onsite and offshore teams. For this purpose, I have created issue logs, query logs to effectively identify the project progress

Project2: Wellpoint – Billing & Remittances – St Louis, MO

Support WLP and BCBSMA billing issues – specifically the withholding process. We deal with the Integration related tickets submitted by WLP.

Environment: Informatica 9.0.1, Oracle, Teradata 14.10.0.04, 15.10.02.10, ServiceNow, Autosys, JIRA, UNIX, Shell Scripting Linux Environment, Putty, WinScp, Microsoft Visio, Erwin

Company: Satyam Computer Services Ltd. Jun 2006 – Mar 2011

Location: Bloomington, IL (2009 – 2011), Hyderabad, India (2006 – 2008)

Role: Mainframe Developer

Environment: COBOL, PL/1, JCL, CICS, DB2

Project: ECRM Agent List Creation, ECRM Multi-wave Campaign

Responsibilities:

Analyzing and defining user requiremnts

Facilitating the development and conformance of system modifications

Life cycle analysis, cost/benefit studies

Providing interpretive analysis

Preparing flowcharts and associated diagrams/enhancement plans

Preparing system and acceptance test plans, conducting acceptance tests and confirm results and assisting in user training.

Education:

BACHELOR in TECHNOLOGY (Computer Science Engineering) from Jawaharlal Nehru Technological University – 2005 (year of passing)

Contact this candidate