Senior ETL Lead/Developer Informatica PowerCenter Expert

SATYA PRATYUSHA MATETI

SENIOR ETL LEAD/DEVELOPER

Mobile: +1-813-***-****

E-Mail: *****.******@*******.***

PROFESSIONAL SUMMARY

Over 15 years of technical experience in Informatica PowerCenter as ETL Lead, Business Analysis (Requirements, Impacts Analysis), and Computer Analysis (Data Analysis), design, development, maintenance, and production support of Data Warehousing and SQL.

Gathered the requirements from Clients and analyzed the requirements by involving various stakeholders. Analyzing the current data available, finding the gaps, and recommending solutions to resolve those gaps

Have Extensive knowledge in creating the requirements document, like Impact analysis document, HLD, and LLD

Responsible for design, development, maintenance, and documentation of modules as per the client’s business specifications. Created the Data/ETL architecture and provided strategy related to data cleansing, data quality, and data consolidation for various projects.

Have Extensive knowledge in developing Informatica objects (both reusable and non-reusable), Teradata scripts, and UNIX scripts.

Extensive knowledge in using SQL, UNIX, and Informatica PowerCenter.

Proficient in data analysis, writing complex SQL queries and performance tuning.

Actively participated in all client meetings for requirement gathering and proactively suggested improvements in existing tools and processes.

Well-versed in Systems Requirement Study, Analysis, and preparation of Test Case Documents, procedures, and Execution of Unit Test cases.

Have good knowledge of Mainframes.

Have knowledge on Reporting tools like Tableau and Pentaho Reporting tool.

Areas/Applications

o Customer Experience

Verizon Communication Inc.: Enterprise Product Catalog – Migration

Moddy’s Corporations: Issuer Focus

Moddy’s Corporations: CMS-SMART

AT&T: Alliance AIM (Analytical Informational Model)

AT&T: Enterprise Data Warehouse (EDW)

Bank of America: The ‘W’ Data Warehouse application - E-commerce

TECHNICAL PROFICIENCY

Programming Languages

Informatica ETL, Shell Programming, SQL, COBOL

Databases

SQL, Teradata

Reporting

Tableau

Special Software

Informatica PowerCenter, Amdocs C1, Jenkins, Putty, WinSCP, Jenkins

SQL Tools

SQL Developer

OS/Environments

Windows, UNIX, Mainframes

Change Management

JIRA

Project Management

JIRA

PROFESSIONAL EXPERIENCE:

Tata Consultancy Services – IN & US July 2020 – Till Date

Role: Senior ETL Lead Developer

Client: Verizon Communication Inc.

Project: Enterprise Product Catalog

Project Overview: Verizon is an American wireless network operator that previously operated as a separate division of Verizon Communications under the name of Verizon Wireless. In a 2019 reorganization, Verizon moved the wireless products and services into the divisions Verizon Consumer and Verizon Business and stopped using the Verizon Wireless name.

Enterprise Product Catalog Project is to modernize product catalog system by migrating from ATG BCC to Amdocs CatalogOne. This project will include the migration of the Product catalog data such as SIM Info, IOT, MCS, Accessories, Devices, Bundles, Plans, Promotions etc. This new Amdocs CatalogOne environment is one centralized environment which will reduce lot of transitions on the source DB's. Data migrated to Amdocs to be consumed by all channels (Mobile Apps, POS, Verizon Website etc). This EPC will interpret data from backend to front end channels. ETL / Informatica team works very closely with BCC system and develops mappings to extract the data from the source system. Java development team works on translating the flat files from source system to desired JSON format according to AMDOCS guidelines and push it to C1 UI with help of API's. This EPC-CatalogOne will allow users to enrich the data directly on the UI as well.

Responsibilities:

Gathering the requirement from Clients and analysing the requirement by involving various stake holders. Analysing the current data available and finding the gaps and recommend solutions to resolve those gaps.

Participating in all client meetings for requirement gathering and proactively suggested improvements in existing tools and processes.

Design and develop Informatica mappings to implement the business rules as per user stories.

Involved in client interaction and gathering of requirements and feasibility study

Analyze BRD – Business Requirement Document

Creating HLD (High Level Design), AD (Application Design Document) and Technical Specifications Documents.

Design Informatica mappings and maplets to implement the business rules as per table specification documents.

Work with QA and UAT team to analyze and resolve open defects.

Coordinated with the offshore and onsite team actively in analyst role of the Project, so that the delivery is completed on time.

Technology and Tools: SQL, Shell programming, Informatica PowerCenter, Amdocs C1, JIRA, Jenkins, SQL Developer, Oracle DB, Putty, WinSCP, Windows, UNIX.

Tata Consultancy Services – IN Jan 2019 – June 2020

Role: Analyst (Requirements, Impacts, and Data) & ETL Lead

Client: Moody's Investors Service

Project: Issuer Focus

Project Overview: Moody’s Issuer Focus is a Portal which is used by the Analyst and the Issuers to view and analyze

the Organizational (Issuer) related information which consists of the ORG level data, Peer comparison, financial data, Ratings data and Viewership data etc. This information is pulled and shown on the UI from the Issuer Focus Data Warehouse target tables which is populated from the Source system by Extract Transform and Load process using Informatica. Issuer Focus DW team is responsible for delivering end-to-end solutions starting from the Design, Developing, Deploying and Supporting the applications developed on Informatica. The primary focus in our project is to understand the business model, designing and developing the Data models to build the Datawarehouse and the ETL process to all the sources of Issuer Focus. It also includes ensuring data accuracy of the application.

Roles & Responsibilities

Gathering the requirement from Clients and analysed the requirement by involving various stake holders. Analysing the current data available and finding the gaps and recommend solutions to resolve those gaps.

Participating in all client meetings for requirement gathering and proactively suggested improvements in existing tools and processes

Creating HLD and Application design documents by mapping business requirements from business requirement documents in Agile methodology.

Design, develop and implement data models to build the Datawarehouse and the ETL process according to the Application design and business rules.

●Involved in client interaction and gathering of requirements and feasibility study

●Analyze BRD – Business Requirement Document

●Creating HLD (High Level Design), AD (Application Design Document) and Technical Specifications Documents.

●Design Informatica mappings and maplets to implement the business rules as per table specification documents.

●Work with QA and UAT team to analyze and resolve open defects.

●Coordinated with the offshore and onsite team actively in the lead and analyst role of the Project, so that the delivery is completed on time.

Technology and Tools: SQL, Shell programming, Informatica Power Center, Sybase, MSSQL, AWS DynamoDB

Tata Consultancy Services – IN July 2018 – Dec 2018

Role: Analyst (Requirements, Impacts, and Data) & ETL Lead

Client: Moody's Investors Service

Project: Content Management System – SMART Team

Project Overview: As part of Moody’s Content Management system, SMART Datawarehouse holds the Metadata information of all types of Documents which are published/created by the Analysts in the Content Management System. The SMART Datawarehouse stores this data for reporting purposes. The Datawarehouse tables are populated with the Metadata information coming from Methode Tool in XML format (source data) by Extract Transform and Load process using Pentaho ETL tool and Informatica. SMART DW team is responsible for delivering end-to-end solutions starting from the Design, Developing, Deploying and Supporting the applications developed on Pentaho and Informatica. The primary focus in our project is to understand the business model, designing and developing the Data models to build the Datawarehouse and the ETL and Reporting process to the sources and ensuring data accuracy of the application.

Roles & Responsibilities

Gathering the requirements from Clients and analyzing the requirements by involving various stakeholders. Analysing the current data available and finding the gaps, and recommend solutions to resolve those gaps.

Creating High Level and Application design documents by mapping business requirements from business requirement documents in Waterfall/Agile methodology. Develop the ETL process according to the Application design and business rules. Also Design and Develop reports on top of the data warehouse according to the business needs.

Involved in client interaction and gathering of requirements and feasibility study

Analyze BRD – Business Requirement Document

Creating HLD (High Level Design), AD (Application Design Document) and Technical Specifications Documents.

Design Pentaho Transformations or Informatica mappings to implement the business rules as per table specification documents.

Design and Develop Reports on the SMART Datawarehouse using Tableau and Pentoho Reporting Tool as required in the BRD and Application design documents

Work with QA and UAT team to analyze and resolve open defects.

Coordinated with the offshore and onsite team actively in the lead role of the Project, so that the delivery is completed on time.

Technology and Tools: SQL, Shell programming, Pentaho ETL tool, Informatica Power Center, Sybase, MSSQL, Tableau, Windows, UNIX.

Tata Consultancy Services – IN Jan 2015 – June 2018

Role: Analyst (Requirements, Impacts, and Data) & ETL Lead

Client: AT&T

Project: Alliance AIM (Analytical Informational Model)

Project Overview: Alliance AIM (Analytical Informational Model) is a critical module of Enterprise Consolidated Data Warehouse(eCDW) which is responsible for providing revenue data reports used by Top level management. AIM also sources the revenue data to Internal Revenue Service (IRS) team on every month end. Alliance AIM model is designed exclusively to maintain critical revenue data and to provide single version of truth to entire organization. As already specified above this revenue data in AIM is used to send monthly reports to IRS team on every month end. The primary focus in our project is to understand the business model, designing and developing ETL to all the sources of AIM. It also includes ensuring data accuracy across AIM application.

Roles & Responsibilities

Creating High Level and Application design documents by mapping business requirements from business requirement documents and developing the Extraction, Transformation and Loading scripts accordingly in Waterfall/Agile methodology.

Involved in client interaction and gathering of requirements and feasibility study

Analyze BRD – Business Requirement Document

Creating HLD (High Level Design), AD (Application Design Document) and Technical Specifications Documents.

Creating ERWIN data models in eCDW(Enterprise Consolidated Datawarehouse) as required in BRD and AD Documents.

Design Informatica mappings and maplets to implement the business rules as per table specification documents.

Query modulation of existing SQLs for improved performance.

Work with System Testing and UAT team to analyze and resolve open defects.

Technology and Tools: Teradata SQL and Utilities, Shell programming, Vertica, Informatica and Teradata, Vertica, ERWIN, Windows, UNIX.

Tata Consultancy Services – IN Aug 2013 – Dec 2014

Role: Analyst (Requirements, Impacts, and Data) & ETL Developer

Client: AT&T

Project: Enterprise Data warehouse (EDW)

Project Overview: EDW Data Integration focuses primarily on analysing the AT&T Wireless & Fixed line system, understanding the business model, designing and developing ETL modules to several critical applications in Marketing, Finance and Sales areas to integrate the Wireless data to existing Business Intelligence Database of AT&T. It also involves in maintaining of data integrity within these applications.

Roles & Responsibilities

Understanding the business requirements, design documents and developing the Extraction, Transformation and Loading scripts accordingly.

Involved in client interaction and gathering of requirements and feasibility study

Analyze HLD, AD and Technical Specifications Documents

Carrying out the ETL-Extraction Transformation and Loading process using Teradata Utilities, Unix Scripts and Mainframes.

Performance tuning of Teradata Queries

Preparing Test Plans and Test Specifications as per the requirements and following the quality standards

Technology and Tools: Teradata SQL and Utilities, Shell programming, Vertica, Informatica and Teradata, Windows, UNIX, COBOL, JCL, DB2, IBM Mainframes, Solaris UNIX.

Tata Consultancy Services – IN May 2011 – July 2013

Role: Analyst (Requirements, Impacts, and Data) & ETL Developer

Client: Bank of America

Project: The ‘W’ Data Warehouse application- Ecommerce

Project Overview: The ‘W’ Data Warehouse application- Ecommerce focuses primarily on analysing the e-commerce traffic of Bank of America. The main objective of the Warehouse is to help the Bank in taking Business decisions. Understanding the business model and to design, enhance and maintain new applications on a Mainframe –Teradata based Warehouse in banking domain. Ecommerce takes up enhancements to the existing 41 applications and developed new applications as and when the requirement comes up for the same.

Roles & Responsibilities

Understanding the business requirements, design documents and developing the Extraction, Transformation and Loading scripts accordingly.

To do an impact Analysis for the New/Changed Requirements.

Develop the code according to the LLD and standardize the code.

Perform testing of the developed query for performance issues and tuning poor performing queries if any.

Perform SIT (System Integration Testing) and provide data to Onshore Counterpart for submitting it to the User community.

Involve in Post implementation support. Maintaining the jobs till they are turned over to the Production Support team.

Technology and Tools: Teradata, COBOL, JCL, IBM Mainframe, Z/OS.

EDUCATION:

Bachelor’s in Technology from JNT University, Hyderabad, India (June 2009)

AWARDS (Personal):

Received Star of the month awards.

Received On the spot awards.

Received Star of the quarter award.

Contact this candidate