Datawarehouse Consultant

About The OpportunityA fast-scaling technology services firm operating in the Enterprise Data & Analytics domain, we specialize in designing, deploying, and optimizing modern data warehouse architectures for clients across BFSI, Retail, and Manufacturing sectors. We enable data-driven decision-making through scalable cloud-based data platforms, ETL/ELT pipelines, and BI-ready semantic layers—powering dashboards, AI/ML models, and real-time analytics.Role & ResponsibilitiesDesign and implement enterprise-grade data warehouse architectures on cloud platforms (Snowflake, Redshift, BigQuery) and on-prem (Teradata, SQL Server).Develop and optimize ETL/ELT workflows using tools like Informatica, Talend, Azure Data Factory, or AWS Glue for high-volume, complex data ingestion and transformation.Collaborate with stakeholders to define data models (star/snowflake schemas), dimensional modeling, and data lineage documentation.Ensure data quality, governance, and performance tuning across staging,...