Production Support Informatica Developer

Location:

Schaumburg, IL

Posted:

July 16, 2024

Contact this candidate

Resume:

Vela Suganya Rethinam

Email : ***********.*****@*****.***

Mobile: 224-***-****

Career Objectives

* ***** ** ********** ** complete Software Life cycle right from requirement analysis, development, integration, final testing (SIT, UAT) of enterprise application, implementation to production support.

Extensive Technical Knowledge on Informatica-Powercenter, SQL, PL/SQL and UNIX.

oHave worked on Session partitioning to handle multiple frequency file generation

oAchieved dynamic parameter file generation using Normalizer

oUsed SQL transformation for performance tuning and unique key generation (from a database sequence) across many simultaneously executed mappings

oUsed Transaction Control Transformation to generate variable number of target files in accordance with the source data from a single mapping

oWorked on reusable transformations, Mapplet, Email task, Command task, Session task to achieve reusability

oWorked on Update strategy transformation for Type 2-dimension mapping for version control

oWorked on Data extraction from web-service XML response (tags) using XML parser transformation to populate downstream target tables

oHands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions

oE-mail notification set up was done to notify success or failure execution of production cycles to the entire team

oCreated a Workflow execution tool (using shell script) to execute certain workflows for n number of times across various environments. After a failure, when the tool is rerun, it executes from the point (workflow number and loop count) where it stopped. The tool also generates an error log for invalid inputs, filenames and file path

oUsed PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time

oExtensively used Informatica Debugger to figure out the problems in mapping

Extensive knowledge on Informatica BDM tool

oWorked on end to end development on BDM tool

oWorked as the lead developer – interacting with business for requirement, upstream/downstream co-ordination, deployment and warranty support

oUse Github as source data management tool – release level code maintenance, deployment and versioning

HHave good Functional knowledge on Banking and Insurance domain

Demonstrated leadership skills on managing the development team including communication set up, task distribution, peer review and release management

Prepared and presented Design specification, Technical specification, Maestro schedules and Data mapping documents to clients and production support teams

Excellent communication skills, quick learning ability and good team player with excellent technical and interpersonal skills

Executive Profile

9 Years of experience in complete Software Life cycle right from requirement gathering analysis, development, integration, final testing (SIT, UAT) of enterprise application, implementation to production support.

Technical Competencies

Programming Language

: UNIX shell scripting

DataBase

: Oracle 10g, DB2, Cassandra

: Windows

Skills

: Informatica Powercenter 7.1/8.6/9.1/10.1, Informatica BDM 10.4/10.5.3

Tools

: Toad, QMF, HP Quality center v11, Rational Rose Clear Quest, IBM Tivoli,

workstation

CA workstation, Putty, Winscp

Experience Summary

Project Name

Batch Middleware Interfaces

Organization

Oracle Financial Services

Client

Mashreq Bank

Duration

Mar 10 – Jun 12

Environment

Informatica Powercenter 9.1.0, UNIX, Oracle 10g

Share Point 2010, ASP.NET, Java script, PDF, MS Office

Role

Informatica Developer

Description of Project:

The Dubai-based Mashreqbank is the oldest private owned bank in the United Arab Emirates. The assignment is to develop batch interfaces of various frequencies, modules and systems to extract, transform and load data from FLEXCUBE tables. Mashreq bank has a chain of downstream systems which require data in various formats from about 300+ interfaces. Worked with third party scheduler ‘Tivoli’ to achieve frequency. The interfaces were executed for 8 different regions.

Responsibilities:

Worked on the session partitioning to achieve the different frequencies (daily, monthly, bimonthly)

Worked on dynamic parameter file generation using transaction control transformation and Normalizer transformation. About 300+ parameter files had to be generated on every EOD

Variable number of files will have to be generated based on the source data from the same mapping. This was handled using transaction control transformation

Data was loaded into files of various formats like delimited with a variety of delimiters, files with header, footer, files with cumulative values calculated within the file data, fixed width files etc.

Used UNIX to perform intraday execution and file combinations

Used event wait task to achieve execution order across systems

Used E-mail task to achieve requirements on notification

UNIX scripting was used in pre and post session commands to handle complex file structures, intraday execution

Worked on third party scheduler ‘Tivoli’ to achieve session execution order and frequency handling

Project Name

Commercial Lines Underwriting Workstation

Organization

Cognizant Technologies

Client

Hanover Insurance

Duration

Jul 12 to Mar 13

Environment

Informatica Powercenter 9.1.0, UNIX, DB2

Share Point 2010, ASP.NET, Java script, PDF, MS Office

Role

Informatica Developer

Description of Project:

The assignment is to develop a data mart for the underwriting process. The sources were tables and web services. The task was to build ODS tables. Data from certain sources were loaded every hour and data from others were loaded once in a day. Data from web service were extracted as XML using Java transformation. This XML response was interpreted using XML transformation and loaded. Data validation, system level data checks, no data cycles were handled. Data versioning was also done. Multiday handling, duplicate versions, false versions were also handled in data versioning. UNIX scripts were used to handle worst case scenarios on data feeds.

Responsibilities:

Received ‘Star of the month’ award from Cognizant technologies for active contribution towards this project

Created an automation (on UNIX) to run certain workflows in an order across many environments. This automation was used to load ODS in the development and test environments without much of manual effort. The automation was also used by other projects. The workflows can be executed for any number of loops without any manual intervention. And if there was a workflow failure, when the script is rerun the execution starts from the point (loop number and workflow number) where it had stopped. Error log for every failure was also maintained

Worked on Java transformation to retrieve data as a XML response from web service

Worked on XML transformation to interpret the XML tags to extract data

Handle ‘no-data’ cycles, extra cycles, invalid data and irrelevant data

Error handling was a major task. A separate error policy/quote table had to be maintained. Some policy/quote which did not retrieve data from web service were processed on every cycle to check if the data was available

Project Name

Commercial Lines Underwriting Workstation-RDSA

Organization

Cognizant Technologies

Client

Hanover Insurance

Duration

Mar 13 - Nov 13

Environment

Informatica Powercenter 9.1.0, UNIX, DB2, Oracle 10g

Share Point 2010, ASP.NET, Java script, PDF, MS Office

Role

Informatica Development Lead

Description of Project:

The project requirement was to build a data mart for ODS tables with history data. The source data was from DB2 ODS tables which contains only current version of policy/quote. The versioning of this data had to be maintained in target Oracle tables. Versioning needed to handle additional and missing data from the previous versions. Further scheduling was done in accordance with the schedules of the ODS loads to avoid partial loading and deadlock failures.

Responsibilities:

Involved in client discussions on requirements and design

Worked on the table structure design for the ODS RDSA tables

Took various training sessions on Informatica for Freshers and Peers

Worked on versioning, duplicates handling, invalid data handling

Used E-mail task to achieve requirements on notification

Developed mapplets for error handling and balancing

Worked on UNIX shell scripting to handle multiday loads

Created stored procedures for transformations on transactional data

Project Name

Data Layer Auditing and Quality Management - DLAQM

Organization

Mphasis Corporation

Client

AT&T

Duration

May 18 – Dec 19

Environment

Informatica Powercenter 10.1.1, UNIX, Oracle 10g, Cassandra, MSTR

Share Point 2010, ASP.NET, Java script, PDF, MS Office

Role

Informatica Developer and Data Analyst

Description of Project:

DLAQM is an independent auditing application validating data flows on the client’s data layer. For the existing data flows and newly developed data flows between various systems, audits were developed to audit data consistency. The audit reports were generated thru MSTR and data discrepancy were reported to the respective team as defects.

Responsibilities:

Involved in client discussions on requirements and design

Designed Informatica jobs for data comparison from various data sources

Co-ordinated with various teams to get data flow logic between systems and interpretation of the same to build audits

Worked on data extraction logic from message router, API, Oracle DB, Cassandra DB and file sources

Designed reporting logic and reporting tables

Designed reusable scripts to load data from any source to stage table

Validated data discrepancies based on data flow logics and analyzed data

Worked on UNIX shell scripting for data extraction and cleansing from Message Router

Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy, Union, SQL and Sequence generator

Worked closely with the portal team on their requirements on data. Modified table structures and loads based on these requirements

Worked on UNIX shell scripting for data extraction and cleansing from Microservices

Carried out end to end testing of audit jobs post deployment

Handled First Production Run of audits, validation of reports, and result publish

Worked on end to end defect management

Project Name

Campaign Datamart Data Provision

Organization

Infosys Pvt. Ltd.

Client

Truist Bank

Duration

Dec 20 to Nov 2021

Environment

Informatica BDM 10.4, UNIX, files

Informatica Powercenter 10.1.1

Share Point 2010, ASP.NET, Java script, PDF, MS Office

Role

Lead Developer

Description of Project:

This project mainly aimed at building the Campaign datamart from various application data across the bank. Data from heterogeneous databases, external and internal files were loaded onto a source based EDL cluster for the provisioning. This included new ingestion build, existing ingestion enhancements and corrections. The build also had to determine the data sources from legacy systems from the 2 banks which merged as one. Data provision migration had to be taken care when one of the data center was sunset.

Responsibilities:

Involved in client discussions on requirements and design

Designed Informatica jobs for data provision based on client requirements

Co-ordinated with various teams to understand the data availability to data provision map

Worked on data extraction logic from heterogenous db’s, external and internal files

Validated data discrepancies based on data flow logics and analyzed data

Collaborated with data transmission team on provisioning data thru data centers and with the datacenter

Set up scheduling of jobs based on source and downstream requirements thru scheduling tools

Worked on UNIX shell scripting for data extraction and cleansing from external files with inconsistent data

Handled source code using Git. Worked on end to end process from data check in to deployment thru Git.

Worked on conversion data load from legacy systems during the merger process

Worked on end to end defect management

Trained other teams and client on Gitlab end to end process

Handled workshops on team building and leadership skills

Worked on creating powercenter mappings to source data from external files

Worked on building sql queries for downstream applications and business data needs

Project Name

Credit Card Conversion

Organization

Infosys Pvt. Ltd.

Client

Truist Bank

Duration

Dec 2021 to July 2024

Environment

Informatica BDM 10.5.3, UNIX, Mainframe files

Share Point 2010, ASP.NET, Java script, PDF, MS Office

Role

Lead Developer

Description of Project:

The project is to build a data layer for the Credit Card data for the bank on Enterprise Data Lake (Hive). It involved the credit card vendor provisioned mainframe files to be transformed and loaded into Hive. And legacy system from the former 2 banks is also converted into the current vendor accounts.

Responsibilities:

As the lead developer, worked on requirement gathering, development, work assignment, peer review and release management

Worked with source teams to understand the nature of the data and strategizing the data quality checks

Data layer structuring and grouping of associated data baed on downstream requirements

Develop conversion specific code to handle conversion data from legacy vendors

Work on conversion from legacy systems and sunset jobs for the same

Worked on source code management thru Git

Handled release management documentation, KT calls, review and approvals. Warranty support and enhancements from PROD learnings

PROD incidents analysis and break fixes

Co-ordinated with data transmission team to provision files from the bank to external vendors

Demonstrated strong leadership and interpersonal skills – working on a onshore/offshore model

Worked on Agile framework – maintaining rally tasks, backlog management and daily stand up’s

Developed code to handle special patterns on external files frequency and data

Worked on complex SQL statement framing for data load validation

Contact this candidate