Datawarehouse Consultant

About The Opportunity

A 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 & Responsibilities

Design and implement enterprise-grade data warehouse architectures on cloud platforms (Snowflake, Redshift, Big Query) 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, ODS, and DWH layers with automated validation and monitoring.
Integrate data warehouses with BI tools (Tableau, Power BI, Looker) and support semantic layer creation for business users.
Lead client workshops, gather requirements, and deliver technical documentation aligned with enterprise data strategies.

Skills & Qualifications

Must-Have

Snowflake
Redshift
Big Query
Informatica
Talend
Azure Data Factory
SQL
Dimensional Modeling

Preferred

Apache Airflow
dbt
Power BI

Benefits & Culture Highlights

Work with Fortune 500 clients across global industries and solve high-impact data challenges.
Access to certified training programs and cloud platform certifications (AWS/Azure/GCP).
Performance-driven culture with clear growth paths into Lead/Architect roles.

Skills:

data,etl,data warehouse