Jobs

Interviews
Job Alerts
Tools

Upskill and Grow with AI

Mock Interview Practice interviews in realistic simulations

Coding Practice Improve your coding skills with challenges

Certification Earn certifications to validate your skills

AI Learning Get trained with AI expert sessions

Career Path AI insights for smarter career decisions

AI Job Match Score AI-Powered Job Match Against Your Resume and Optimize Your Resume

Career Tools and Resources

Resume Builder Build Professional Resume with Ease

ATS Friendliness Check Check Resume Friendliness for Applicant Tracking Systems

Auto Apply Apply to hundreds of jobs on any platform effortlessly

Co-Pilot (Chrome Extension) Your AI Assistant for Seamless Browsing Efficiency

Interview Questions Streamline interviews with ready-to-use questions

Salaries Discover market-driven salary insights across skillsets and geographies

Companies Explore leading companies actively hiring talent
For Employers

Jobs

Interviews

Home
>
Jobs in Hyderabad
>
Akrivia HCM
>
Senior Data Warehouse Architect

Senior Data Warehouse Architect

Akrivia HCM

8 - 13 years

25 - 40 Lacs

Hyderabad

Posted:4 days ago| Platform:

Apply

Skills Required

Pyspark Star Schema Modeling Aws Glue Amazon Redshift ETL Etl Pipelines Airflow Data Engineering Kafka Elt Apache Nifi SQL datalake Data Pipeline Snowflake Data Pipeline Architecture MongoDB Data Warehousing Python

Work Mode

Work from Office

Job Type

Full Time

Job Description

Key Responsibilities

Design conformed star & snowflake schemas
, implement SCD2 dimensions and fact tables.
Lead
Spark (PySpark/Scala) or AWSGlue
ELT pipelines from RDSZeroETL/S3 into Redshift.
Tune RA3 clusterssort/dist keys, WLM queues, Spectrum partitionsfor subsecond BI queries.
Establish dataquality, lineage, and costgovernance dashboards using CloudWatch & Terraform/CDK.
Collaborate with Product & Analytics to translate HR KPIs into selfservice data marts.
Mentor junior engineers; drive documentation and coding standards.

MustHave Skills

AmazonRedshift (sort & dist keys, RA3, Spectrum)
Spark
on EMR/Glue (PySpark or Scala)
Dimensional modelling (Kimball), star schema, SCD2
Advanced SQL + Python/Scala scripting
AWS IAM, KMS, CloudWatch, Terraform/CDK, CI/CD (GitHub Actions or CodePipeline)

NicetoHave

dbt, Airflow, Kinesis/Kafka, LakeFormation rowlevel ACLs
GDPR / SOC2 compliance exposure
AWSDataAnalytics or SolutionsArchitect certification

Education

B.E./B.Tech in Computer Science, IT, or related field (Master’s preferred but not mandatory).

Compensation & Benefits

Competitive CTC
25–40 LPA
Health insurance for self & dependents

Why Join Us?

Own a greenfield HR analytics platform with executive sponsorship.
Modern AWS stack (RedshiftRA3, LakeFormation, EMRonEKS).
Culture of autonomy, fast decisionmaking, and continuous learning.

Application Process

30min technical screen
4hour takehome Spark/SQL challenge
90min architecture deep dive
Panel interview (leadership & stakeholder communication)

More Jobs at Akrivia HCM

Senior Content Writer

Hyderabad

6.0 - 11.0 yrs

INR 6 - 12 Lacs

Release Manager

Hyderabad

8.0 - 13.0 yrs

INR 15 - 25 Lacs

Site Reliability Engineer

Hyderabad

8.0 - 13.0 yrs

INR 15 - 25 Lacs

Engineering Manager

Hyderabad

10.0 - 15.0 yrs

INR 35 - 45 Lacs

Senior Data Warehouse Architect

Hyderabad

8.0 - 13.0 yrs

INR 25 - 40 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start PySpark Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.