A seasoned Data Warehousing Professional in designing, developing, and implementing ETL solutions using tools like IBM DataStage, Ab Initio and SSIS, ensuring seamless data integration and transformation. Proven track record of delivering end-to-end data migration projects, including Oracle to Snowflake migration, utilizing modern data platforms such as AWS and Snowflake to optimize performance and scalability. Experienced in cloud data solutions, proficient in designing and developing data models, views, and stored procedures in Snowflake for advanced data analytics and reporting. Strong database management skills, adept in working with Teradata, Oracle, DB2, MS SQL Server, and optimizing PL/SQL and Shell scripting for enhanced query performance. Demonstrated expertise in onshore-offshore coordination, acting as an onsite coordinator for multiple clients, ensuring effective communication, issue resolution, and project delivery within SLAs. Proficient in data quality management, ensuring integrity and consistency of enterprise data through DataStage jobs and best ETL practices for global insurance and retail giants. Adept at addressing production issues, performing performance tuning, and enhancing ETL processes to ensure optimal system performance and successful deployments. Collaborative team leader, skilled in engaging with cross-functional teams and conducting design reviews.