Akhil Ponna

Capgemini

Hyderabad

04.2021 - Current

Led the migration of multiple Data Marts from an on-premise environment to the cloud, utilizing Informatica, IICS, and Azure Synapse Analytics to ensure scalability, reliability, and security.
Conducted insightful data analysis, informing efficient solutions to enhance processes and reduce costs, addressing both business needs and customer requirements.
Planned and orchestrated ETL schedules for migration projects, using IICS/ETMETA framework and Crontab for seamless execution.
Continuously monitored and improved ETL processes to ensure optimal performance and efficiency. Leveraged SQL queries to identify bottlenecks and applied strategic logic for refining the overall ETL process.
Improved SQL query response time, resulting in a faster data migration process, by utilizing SQL tuning techniques to optimize database performance.
Used advanced SQL queries to analyze and profile data, conducting data cleansing and error checking procedures to uphold and verify data integrity.
Facilitated effective communication with stakeholders and project team members, ensuring alignment with project timelines, goals, and objectives.
Identified and resolved defects during System Integration Testing (SIT) and User Acceptance Testing (UAT) by diagnosing issues, troubleshooting, and providing timely and effective solutions.
Contributed to the successful execution of a large-scale data migration project by collaborating with Data Engineers, actively participating in issue identification and resolution.

Similar Profiles