MANI TATA acw604@r.postjobfree.com

Informatica Consultant 416-***-****

Toronto, ON

Around 6 years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care and Financial sectors.

Strong experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.

Proficiency in developing SQL with various relational databases like Oracle, SQL Server.

Strong experience in Data Warehousing and ETL using Informatica Power Center 9.6.

Knowledge in Full Life Cycle development of Data Warehousing.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Strong with relational database design concepts.

Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).

Experience in bug tracking tools like ALM & Remedy and Source code management tools like CVS and SVN.

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.

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

Keep myself abreast with the emerging Internet technologies and their applications to business solutions.

Quick learner with good analytical and communication skills.

TECHNICAL SKILLS

oInformatica (Power Center 8.6, 9.1, 9.6)

oOracle 9i, 10g, 11g

oSQL, PL/SQL

oTOAD, SQL Developer

oCVS, SVN, ALM, TIDAL

oWindows 2000/XP, Windows 7, Unix

EDUCATIONAL:

Bachelor’s Degree (B. Tech.) in Electronics and Communications Engineering.

Work Experience

Informatica Consultant

Deutsche Bank – CGI, CA

June 2016 to Present

Description: CGI technical team delivering high-quality, innovative, and secure solutions to the Deutsche Bank Capital Market.

Responsibilities

Developed reusable code, mapplets which are being used in various projects.

Delivered highly parameterized code forecasting future modifications and expansions.

Communicated with business customers to discuss the issues and requirements.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Environment

Unix, Window S/w: Oracle 10g, Tools: Informatica 9.6.1, Tidal Scheduler, Toad for Oracle, Lotus Notes, ALM

Informatica Consultant

Tufts Health Plan – CGI, Halifax, CA

Feb 2013 to May 2016

Description : Tufts Health Plan, a leader in healthcare information systems integration and healthcare solutions provides analytics, decision support, process automation and related information technology solutions that help governmental and commercial healthcare payers to improve patient outcomes, enhance market position and reduce costs. This provides direction and technical guidance for the administration of the Federal effort to plan, develop, manage and evaluate health care financing programs and policies to perform validation of payment requests from Medicare Part D Plans to the Retiree Drug Subsidy (RDS) program in releasing payments for validated requests, complete drafts of zero dollar emails.

Responsibilities

Developed ETL programs using Informatica to implement the business requirements.

Communicated with business customers to discuss the issues and requirements.

Created shell scripts to fine tune the ETL flow of the Informatica workflows.

Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.

Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.

Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.

Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.

Performed unit testing at various levels of the ETL and actively involved in team code reviews.

Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment

Unix, Window S/w: Oracle 10g, Tools: Informatica 9.5.1, Tidal Scheduler, Toad for Oracle, Lotus Notes, ALM

Informatica Developer

Mahindra Satyam Computers., Hyderabad, India

Client: CMC Sales & Distribution - Financial Services

Jan 2010 to Sep 2012

Description: Sales & Distribution Analysis Module - an application module for supply chain management and operational performance management.

To develop a Decision Support System that enables better analysis of the data by the business and contributes to the effective growth of the company with the help of the ETL process. Participated in design sessions where decisions are made involving the transformation from source to target.

Responsibilities:

Responsible for developing various data extracts and loading routine using Informatica, Oracle stored procedure (PL/SQL), packages, triggers and UNIX.

Managed and compiled documentation for all ETL processes.

Created detailed process flow designs and drafted high-level Standard Operation Procedures

Performed tuning of PL/SQL procedures, views, and Informatica objects.

Monitored data warehouse month-end loads to ensure successful completion.

Extracted data from various sources like Flat files, Oracle and loaded it into Target systems using Informatica 8.6.

Tuned mappings and SQL queries for better performance and efficiency

Performed Unit testing and validated the data

Created & Ran shell scripts in UNIX environment

Environment:

Informatica Power Center 8.6.1, Oracle 10g/9i, Toad, Windows NT,Unix.

Contact this candidate