ETL Developer Informatica
Resume:
Jeffrey Joseph Mattam
*******************@*****.***
Mattathil House, Kuthukuzhy P.O, Kothamangalam
PIN - 686691, India
Profile Summary
High Potential Data Integration Solution Developer (Informatica PowerCenter 9x) with about 2.7
years in the IT industry, experienced in all aspects of architecture, design and delivery of ETL
Solutions.
Well versed in DW & BI concepts : Dimensional Modelling STAR and Snow flake Schema,
Change Data Capture, Incremental Aggregation, SCDs, handling late arriving dimensions & facts
etc.
Experienced in working with onshore and offshore technical teams with diverse skills, mentoring
team members and working on multiple concurrent projects, adhering to pressing deadlines.
Proven ability to communicate effectively at different levels of abstraction, with stakeholders,
business, management and technical teams to design and build solutions compliant with the
governance, risk, security, performance and availability parameters.
Over 2.7 years of experience in data integration from multiple sources and platforms, employing
ETL (primarily using Informatica PowerCenter, Oracle utilities, Unix shell scripts ).
Experienced in working with IT Enterprise Architects and technical leads to define the overall
technical landscape at a major blue chip client of TCS. This includes setting up of processes and
best practices and conducting project feasibility reviews for data movement, integration and
business intelligence requirements
Solid SQL skills (Oracle ) and well versed in Unix Shell scripting ( sh,ksh etc), to create param
files, pre and post session commands, error handling etc.
Understanding of Abinito, another ETL tool while working in many migration projects : Migrating
already developed ETL architecture from Abinitio to Informatica PowerCenter
Conceptual understanding of Master Data Management (MDM), Map Reduce, Data Governance
and Service Oriented Architecture (SOA)
Tools & Utilities
DW & BI Informatica PowerCenter 9.1, Abinito, Unix Shell Scripting, SAP
Business Objects, Oracle 11g
IT Service Management Manage Now, Service Now
Job Scheduling BMC Control M
Quality Management HP Quality Center
Office MS Word, Excel, Visio
1
Selected Achievements and Highlights
Reduced development lifecycle times and delivery overheads for many critical projects while
migration existing ETL architecture from Abinito to Informatica PowerCenter by simplifying and
rationalising the existing complex ETL data movement architecture.
Increased data availability in Audit log tables for Business users by tuning the performance of
ETL framework, removing bottlenecks in minimum time and won appreciation from peers,
module leads, senior managers and stakeholders.
Key deliveries at a Major large Financial Services Provider include implementing Data Integration
solutions using Change Data Capture mechanism to provide data from more than 30 countries for
Fraud analytics and enabling the client to capture fraud transaction
Have received on the spot awards and appreciations from Senior Managers on many occasions
for Agility, Negotiation skills, providing ad-hoc support activities during Product Launches etc.
Professional Experience - Activities and Responsibilities
June 2012 – Ongoing
Tata Consultancy Services, India
TCSL, is a world leading provider of Information Technology Consulting and Business Solutions. I worked
in the capacity of a DW&BI Technology specialist, analyst, designer and developer for a US Based
Financial Services Provider client and internal projects for TCS.
June 2012 – Ongoing
Client : A Multinational Financial Services Corporation listed in Dow Jones Components
Designation: Systems Engineer Role : ETL Developer Team size : 15 (peak)
Design ETL Solutions for Business and presents it to the Architects, Offshore and Onshore
Managers, Stakeholders etc in Design Forums.
Extensively works with complex PowerCenter mappings to extract, transform and load data
from/to various sources/targets (RDMS, flat files, Cobol copy book, MQ, XML files etc ) .
Development of ETL Solutions using Unix Shell scripts and Informatica PowerCenter; Unit testing
and review of code; SIT and UAT Support
Performance tuning of Informatica mappings which won me appreciations from the TCS Offshore
Delivery Managers for quickly picking up the necessary skills and dedication to work.
Key deliveries include migration of multiple ETL projects build in Abinito to Informatica,
Change Request to promote deliverables to QA and Production environment
ETL application warranty support to all deliverables which includes work around implementation,
root cause analysis, permanent resolution etc.
2
Education & Training
Degree: Bachelor of Technology (B. Tech) in Electronics Engineering (2012) from Cochin
University of Science and Technology, Kerala, India.
Training Business Intelligence & Performance Management from ILP, TCS in June 2012
Service Now ( ITSM Tool ) in February 2014
Teradata Architecture, January 2015
Languages
English : Fluent
German : Elementary
Personal Details
Nationality: Indian
References
Available on request
3
Contact this candidate