Santhosh Naidu Puppala

Responsibilities:

• Designed and developed complex ETL processes using Informatica PowerExchange to extract data from mainframe databases (DB2, VSAM) and load into target systems.
• Involved in enhancements and maintenance activities of the data warehouse.
• Implemented performance tuning strategies to optimize ETL workflows, reducing data load times by 30%.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used various transformations to extract data from different formatted files and relational source system.
• Designed Mappings, Mapplets, Sessions, Worklets and Workflows.
• Design and develop PL/SQL packages, stored procedure, tables, views, indexes, and functions; implement best practices to maintain optimal performance.

Responsibilities:

• Developed and maintained PowerExchange Data Maps and Change Data Capture (CDC) mappings to efficiently capture and propagate data changes from mainframe sources.
• Worked closely with mainframe DBAs to optimize data extraction processes, ensuring minimal impact on source system performance during ETL operations.
• Configured and managed PowerExchange Listener services to enable secure and reliable data transfer between mainframe and target environments.
• Conducted comprehensive data validation and reconciliation processes to ensure accuracy and completeness of data migrated from mainframe systems.
• Utilized PowerExchange Navigator to monitor and manage data extraction processes, identifying and resolving issues promptly to maintain data pipeline integrity.
• Implemented automated job scheduling and monitoring using tools such as AutoSys or Control-M to streamline ETL workflows and reduce manual intervention.
• Sourced data from XML files, flat files, SQL server tables and Oracle tables.
• Created, scheduled and monitored workflow sessions on basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Responsible for monitoring all session that are running, scheduled, completed, failed and debugged mapping of failed session.
• Extracted data from multiple operational sources and loading into Staging Area, Data Warehouse and Data Marts using CDC (Power Exchange).

Responsibilities:

• Developed complex data transformation logic to handle mainframe-specific data formats and ensure compatibility with modern data platforms.
• Proficient in using Informatica PowerCenter for ETL development and data integration.
• Strong understanding of ETL concepts and best practices, including data extraction, transformation, and loading.
• Experience with various data sources, including mainframe databases (DB2, VSAM), relational databases (Oracle, SQL Server), and flat files.
• Knowledge of advanced PowerCenter transformations and techniques for handling complex data integration scenarios.
• Created scripts in PL/SQL to automate process of creating and dropping indices before and after ETL process.
• Extensively worked in operational support and deployment to Test, DR and Production.
• Actively involved in import and export of XML files, code migration of folders, Linux files, flat files and database objects.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
• Evaluated client needs and expectations, establishing clear goals for each consulting engagement