Candidates About

 

Mangala Inti

·         12 years IT experience in Design, Development, Maintenance, Enhancements and Production Support of Business Intelligence Enterprise Applications.

·         Hands on experience in Informatica Power center, Informatica Power Exchange, Informatica TDM Tool. Limited experience in informatica IDQ.

·         Experience in implementing projects using Agile Scrum methodology/Waterfall methodology

·         IT Experience in various industries like US-Insurance, Banking & Finance, and US-Healthcare.

·         Experience in developing Enterprise BI solutions applications using Informatica Power Center, Oracle, DB2, SQL Server, Teradata and Unix Shells scripts.

·         Experience in identifying Performance Bottlenecks and tuning Informatica load for better performance and efficiency.

·         Production support experience under the application warranty period that are moved to live systems. 

·         Experience in working Informatica CDC

·         Experience in scheduling tools like Mastero and Tidal.

·         Experience in working with HP QC - Quality Center Systems, BMC Remedy - Ticketing &Change Request Management applications.

·         Knowledge and experience in data warehouse development life cycle, requirements analysis, dimensional modeling, Repository management and administration, implementation of STAR, Snowflake schemas, fact and dimension table modeling of data, Incremental loads/Change Data Capture (CDC) and slowly changing dimensions across projects.

·         Experience in working Congos reporting tool.

·         Experience in preparing UTP/UTR’s for business team.

·         Experience in Teradata utilities -Fastload, Multiload, BTEQ, SQL assistant

·         Knowledge on Erwin Data modeler.

·         Experience in converting the Store Procedures logic into ETL requirements. 

·         Experience working with different functional team such as vendor support team, business users, support teams, and offshore team.

Educational Summary

Bachelor of Technology (BTech- EIE) from Jawaharlal Nehru Technological University – Hyderabad

Technical Skills:

ETL Tools - Informatica Power center 9.x, Power Exchange, Informatica ILM, Informatica IDQ

Databases - Oracle, DB2, MSSQL, Teradata

Operating Systems - UNIX, Windows 2000/XP, Z/OS

Languages- SQL, PLSQL, UNIX, Shell Scripting, COBOL, JCL, VB

Scheduling Tools- Mastero, OPCC,Tidal

Defect Tracking Tools- JIRA, QC

Other Tools TOAD, SQL Developer, WIN SCP, PUTTY, SVN, MS-OFFICE, MS POWER POINT, VISIO, MS Excel , MS Access

 

 

 

 

WORK EXPERIENCE

 

 

Sr Informatica Developer /ETL Lead

Tiffany, NJ,USA

Dec 2016 to till date

 

·         Involved in gathering and analyzing the requirements and preparing business rules. 

·         Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping. 

·         Prepare the design documents

·         Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.

·         Design & develop  Mappings, session & workflows based business rules

·         Implemented performance tuning in mappings and sessions.

·         Importing Cobol copybooks to power exchange.

·         Mask PII columns using informatica TDM tool

·         Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0. 

·         Involved in Performance Tuning of mappings in Informatica. 

·          Good understanding of source to target data mapping and Business rules associated with the ETL processes. 

·         Unit Test the TDM workflows verify the data is being masked correctly

·         Schedule the workflows in ESP

·         Import DB2 tables, Mask DB2 tables

 

Environment: Mainframe, Informatica Power center, Informatica Power Exchange9.6, ESP Scheduling Tool, WINSQL DB2, Oracle, WINSCP, UNIX Shell scripting , TSO/ISPF, JCL, Sort Utilities,IEBGENER, VSAM, Informatica ILM,  SQl Server, Rally tool to track the tasks

 

 

Sr Informatica Developer /ETL Lead

MetLife – Somerset NJ

April 2015 to Nov 2016

 

This project will get several feed files from NSF as mainframe flat files. We load them into DB2 & Oracle DB   creating transformations to make the data available to downstream reporting team via database

Responsibilities

·         Analyzed the source data coming from Oracle, SQL server, and flat files, DB2, VSAM in ETL tool.

·         Understanding BRD, Interact the Business users prepare Low level design documents.

·         Design & develop  Mappings, session & workflows based business rules

·         Implemented performance tuning in mappings and sessions.

·         Prepare estimates for ETL tasks  

·         Work with ETL Architects /ETL Admins & DBA’s  on various tasks

·         Extensively designed, developed, tested complex Informatica mappings, Mapplets and to extract data from external flat files, XML files, oracle tables using Informatica

·         Conduct walkthrough on TSD with ETL team & other stake holders

·         Write Unix shell scripts to schedule  the Informatica workflow

·         Fixing the new changes in ETL developed mappings.

·         Involving in code reviews.

·         Created Unit test cases & provided Test results to business & get their sign off

·         Worked extensively on Unit Testing and preparing efficient unit test documentation for the developed code to make sure the test results match with the client requirement.

·         Worked closely with QA team during the testing phase and fixed bugs that were reported

·         Worked with DBA team to fix performance issues in ETL programs. Coordinate with off-shore resources

·         Used Teradata SQL Assistant for data analysis and SQL queries. 

·         Involved in creating the Teradata BTEQ scripts and used the Teradata tools (Fast load and multi load) to load the data.

·         Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart.

·         Performed tuning and optimization of complex SQL queries using Teradata Explain

·         Created complex mappings that involved implementation of Business Logic to load data in to staging area.

·         Experience in working with metadata Management

·         Effectively communicated with the Business Partners and team members, the problem and the expected time of resolution. 

·          Responsible for providing timely feedback and necessary help/cooperation to meet client expectations 

·         Ensuring standard practices are followed while project development

·         Participated in weekly status meetings and providing the status to the Project Manager on a daily basis. End to end project execution including

 

Environment: Mainframe, Informatica Power center, Informatica Power Exchange9.1, Maestro Scheduling Tool, AQT DB2, Oracle, WINSCP, UNIX Shell scripting, HP ALM, , TSO/ISPF, JCL, Sort Utilities,IEBGENER, VSAM, Informatica IDQ, Erwin Datamodeller tool, Metadata Manager.

 

ETL Technical Lead

Humana – Louisville, KY

March 2014 to March 2015

 

In TDM project we do Data Sub-setting is to reduce the size instead of having full Production copies to reduce the cost and maintenance of non-production systems.  The purpose of Data Masking is to product PHI data in the testing areas.  The Test Data Management project is working on data in the integrated SIT and UAT areas or TEST1 and QA1

Responsibilities

·         Analyze applications and needs on their groups for various releases

·         Translate the business processes/requirements into Informatica mappings.

·         Built the referential integrity (RI) with all constraints in Informatica TDM tool

·         Mask all the PHI columns as sensitive fields in informatica ILM workbench

·         Involved in implementation of Incremental and Full loads.

·         Extensively used Informatica to extract wide range of data from different sources like flat files, DB2, VSAM & Oracle into the ETL Process

·         Involved in Testing and Reviewing of the Mappings.

·         Built the mappings in Power center by using transformations like joiner, Expression, Lookup etc.

·         Create Data Masking for PHI fields in ILM

·         Export VSAM copybooks to Power exchange and import to power center for subset/Mask

·         Generate workflows and  execute the workflows in power center

·         Verify the results in target ( Mainframe VSAM file ) for correctness data

·         Troubleshooting the issues

 

Environment: Mainframe, Informatica Power center, Informatica Power Exchange, Mainframe, VSAM

Informatica ILM.

.

Sr Informatica Developer

Nationwide Insurance – Columbus, OH

Jan 2011 to Feb 2014

 Responsibilities

·         Extracted data from different sources like DB2, Oracle, Flat files and loaded into Oracle database. 

·         Involved in development of Informatica Mappings, Mapplets and Workflows for complex business rules. 

·         Created Parameter file for session parameters and called in the sessions.

·         Imported various Sources, Created Targets, and Transformations using Informatica Power Center.

·         Performed Unit Testing and verified the data. 

·         Tuned mappings and sessions for better performance of the data loads. 

·         Performed Error Handling on Sessions. 

·         Performed Informatica Code Migration from development to testing and testing to production systems. 

·         Involved in migration of Informatica mappings from Development to Production environment. 

·          Coordinated with the Informatica administration team during deployments. 

·         Provided the production support and solved the production issues immediately after they are noticed

·         Involved in Full Life Cycle Development of the Project. 

 

Environment: Mainframe, Informatica Power center, Informatica Power Exchange, AQT DB2, Oracle, WINSCP, UNIX Shell scripting, HP ALM,SPOT, Netezza.

 

 Informatica Developer/Mainframe Developer

Citigroup – Warren, NJ, India

Dec 2003 to Dec 2010

Responsibilities

·         Attend BRD discussion and design meetings with Business team and technology team

·         Coordinate and facilitate with Off-Site resources providing solution according to the client’s requirements.

·         Prepare efforts and estimates using Microsoft Project Plan (MPP)

·         Prepare technical design documents based on BRD &FRD

·         Designed the Data Warehouse/ ETL processes using Informatica Power Center 9.1 to extract, transform and load data from multiple input sources like SQL Server and text files to target Oracle database.

·         Created complex mappings using various transformations such as Rank, Joiner, Expression, Lookup (Connected/Unconnected), Aggregate, Filter, Update Strategy, Sequence Generator etc. to implement the user requirements.

·         Created Reusable Transformations and Mapplets in the designer using transformation developer and Mapplet designer according to the business requirements.

·         Created and scheduled workflows using Workflow Manager to load the data into the Target Database.

·         Performed Unit Testing and Integration Testing of Mappings and Workflows in ETL.

·         Responsible for error handling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor

·         Worked with mapping variables, parameters

·         Created and used different tasks like Decision and email tasks

·         Execute the mappings, validate the results in target

 

Environment: Mainframe, Informatica Power center, Informatica Power Exchange, Maestro Scheduling Tool, AQT DB2, Oracle, WINSCP, UNIX Shell scripting, HP ALM, , TSO/ISPF, JCL, Sort Utilities,IEBGENER, VSAM, COBOL, JCL,CICS, DB2, SUPFI, XML SPY