Requirements:

• Must have around 10+ years of experience in design, implement, and manage data warehousing solutions to support business intelligence and analytics.
• Must be experienced in technically leading a team of 5-10 back end developers..
• Must have sound experience of working in Agile/SCRUM methodology.
• Must have excellent written and verbal communication skills to effectively communicate with US clients, onsite team members, and all stakeholders in the project.
• Must have good understanding of designing new ETL packages to load data to Data warehouse from various sources.
• Must have experience in optimization of data warehousing structures for efficiency and scalability.
• Must have experienced in building Cubes and Dimensions with different Architectures and Data.
• Must have experienced in writing MDX Scripting
• Must have understanding of cloud infrastructure security
• Must have in-depth knowledge of database performance tuning, backup and recovery procedures, and security practices.
• Should able to analyze and optimize queries and database schema to improve performance.
• Should able to Monitor and resolve performance issues related to MySQL and data warehousing.
• Nice to have experience to design and implement ETL processes using AWS tools such as AWS Glue, AWS Data Pipeline, and AWS Step Functions.
• Nice to have experience in development of data workflows and transformations to integrate data from various sources using AWS services.