• Engineered multi-terabyte marketing database solutions leveraging Microsoft SQL Server, AWS, Snowflake, and Azure technologies.• Designed and maintained robust ETL processes, performed data analysis, and executed coding and testing across various sectors such as Campaign, Retail, Financial, Insurance, Hotel, Government, Medical, and Healthcare.• Led the migration of on-premise solutions to cloud platforms, transforming Informatica workflows to SQL Server stored procedures, Amazon Redshift, Snowflake, Matillion, and Talend.• Managed data extraction to Amazon S3 Buckets in various formats.• Automated ETL processes and file extraction using Tidal, enhancing operational efficiency.• Collaborated in requirement reviews and design discussions with cross-functional teams, including BSA, Delivery Architects, Developers, and Client Teams.• Executed historical loads of files up to 10 TB in size, ensuring data integrity and availability.• Utilized SVN, GitHub, and Jira for version control and project management.• Used shell scripting for staging processes and data analysis.• Led unit testing phases and mentored new hires and colleagues.• Coordinated with global delivery teams across multiple geographical regions.

• Developed and optimized stored procedures in MS SQL Server and Oracle for complex data models in an Agile environment.• Authored T-SQL code, ensuring high performance and reliability.• Conducted thorough analysis, comparison, and testing of extensive financial and billing data.• Created ETL processes using SSIS packages from diverse data sources.• Generated reports using SQL Server Reporting Services (SSRS), translating business requirements into technical solutions.• Designed test strategies and test cases for various testing phases, including unit, functional, and performance testing.• Collaborated closely with Project Managers, BSA, Architects, DBAs, Developers, and QA teams to ensure alignment with business goals.