• Spearheaded the development of advanced ETL programs with Informatica PowerCenter, enhancing data processing efficiency by 40% and reducing operational costs.• Engineered and validated complex SQL queries and PL/SQL procedures, optimizing database operations, and ensuring data integrity.• Provided comprehensive production support for data-related issues, consistently resolving incidents within SLA timeframes.• Spearheaded a comprehensive project to rectify misclassified home and roam usage data, revising underlying logic and reloading historical data across all impacted tables. This initiative ensured data accuracy and integrity, significantly enhancing the reliability of usage reports and analytics.• Directed the historical reload of customer data, ensuring accuracy and consistency across all datasets.• Conducted in-depth performance tuning on delayed or stalled processes within ETL jobs and logic, identifying bottlenecks and implementing optimizations. These efforts resulted in a substantial improvement in job performance, reducing processing times and enhancing overall system efficiency.

• Designed and implemented ETL processes using Informatica to support data warehousing initiatives, enhancing data accessibility and reliability.• Developed and maintained SQL scripts to extract, transform, and load data from various sources, ensuring data accuracy and consistency.• Implemented Slowly Changing Dimension strategies tailored to project requirements, demonstrating adaptability and strategic thinking.• Provided production support, troubleshooting, and resolving data issues promptly, maintaining system stability.• Developed and optimized UNIX shell scripts to control ETL flow and reload historical data, ensuring seamless data integration.• Conducted in-depth root cause analysis for recurring issues, implementing long-term solutions to prevent future occurrences.

• Assisted in developing and maintaining ETL workflows using Informatica, contributing to data integration and management efforts.• Supported the creation of SQL queries to generate reports and dashboards, providing valuable insights for decision-making.• Provided first-level production support, escalating issues as needed to ensure timely resolution.• Created and maintained documentation for ETL processes and production support procedures, facilitating knowledge sharing and operational consistency.• Documented processes and created user guides, facilitating knowledge transfer and operational consistency