MuraliKrishna Pollaimandala

Primary: ETL (Informatica)

• Design Develop end-to-end ETL pipelines using tools like IICS (Cloud Data Integration) and Power Center where we have implemented mappings, mapping tasks/sessions, and task flows/workflows for data transformation.
• Integrated data from multiple heterogeneous sources, both structured and semi-structured, ensuring reliable extraction, transformation, and loading into target systems to support enterprise data processing needs.
• Experienced in data warehousing with hands-on implementation of CDC and SCD (Slowly Changing Dimensions) logic to manage incremental data changes, ensure up-to-date data, and preserve historical accuracy for reliable reporting and analytics.
• Performed ETL performance tuning using partitioning, pushdown optimization, parallel processing, cache management, and SQL tuning, reducing batch load times by 30%.
• Developed real-time data integration flows using Informatica IICS to sync data with Elastic search Engines, integrating REST APIs with JSON payloads and Swagger specifications, and applying Java transformations for data processing.

Secondary: Elastic Search

• Extensive experience in querying and managing Elasticsearch, including designing REST API payloads and implementing advanced search and index templates.
• Optimized Elasticsearch queries using search weights and relevance tuning to improve accuracy, performance, and scalability.
• Automated Elasticsearch operations using Python scripting and developed Mustache-based search templates with customized sorting and aggregations.