Prasad Nanubala

ETL Informatica Developer

Jio Platforms Pvt . Ltd

03.2022 - Current

Streamlined data extraction, transformation, and loading for improved overall system performance.
Having good knowledge and experience on Manthan Analytics ETL tool.
Provided support during production deployments by troubleshooting issues and ensuring seamless transitions between environments.
Managed version control for source code, maintaining a well-organized repository for easy access and collaboration among team members.
Strong Technical experience in designing, developing, and maintaining Data warehouses and Data Integration applications such as Informatica Power Center, AWS Red Shift, AWS Redshift , Actian Vector, SAP HANA, MS SQL Server, Oracle.
Developed complex mappings, workflows, and sessions to meet project objectives and deadlines.
Associated with multiple teams for Development, Testing, and Support simultaneously for End-to-end deliveries.
Led the implementation of advanced features such as partitioning and pushdown optimization to improve processing efficiency.
Specialized in Retail Data warehousing with exposure to ERP modules SAP-MM,SAP-SD, SAP-CRM, and TP-Linux.
Created detailed documentation outlining the functionality of developed ETL processes which served as valuable reference material for future maintenance or enhancements.
Enhanced data integration by designing and developing efficient ETL processes using Informatica Power Center.
Optimized performance by identifying bottlenecks in ETL processes and implementing solutions to resolve them.
Efficient in all the phases of the DWH development life cycle and coherent with Data Profiling, Data Cleansing, Data Conversion, Performance Tuning and System
Testing.
Identified, troubleshot and corrected bugs and bottlenecks.
Collaborated with business analysts to understand and define requirements.
Prepared functional and technical documentation data for warehouses.