4 - 6 years

15 - 25 Lacs

Noida

Posted:5 days ago| Platform: Naukri logo

Apply

Skills Required

hive analytical report generation bi data warehousing data pipeline sql plsql star schema optimization spark data ingestion hadoop etl big data reporting snow flake schema snowflake python sql queries performance tuning elt data engineering kafka clustering informatica

Work Mode

Work from Office

Job Type

Full Time

Job Description

We are looking for a highly experienced Senior Data Engineer with deep expertise in Snowflake to lead efforts in optimizing the performance of our data warehouse to enable faster, more reliable reporting. You will be responsible for improving query efficiency, data pipeline performance, and overall reporting speed by tuning Snowflake environments, optimizing data models, and collaborating with Application development teams. Roles and Responsibilities Analyze and optimize Snowflake data warehouse performance to support high-volume, complex reporting workloads. Identify bottlenecks in SQL queries, ETL/ELT pipelines, and data models impacting report generation times. Implement performance tuning strategies including clustering keys, materialized views, result caching, micro-partitioning, and query optimization. Collaborate with BI teams and business analysts to understand reporting requirements and translate them into performant data solutions. Design and maintain efficient data models (star schema, snowflake schema) tailored for fast analytical querying. Develop and enhance ETL/ELT processes ensuring minimal latency and high throughput using Snowflake’s native features. Monitor system performance and proactively recommend architectural improvements and capacity planning. Establish best practices for data ingestion, transformation, and storage aimed at improving report delivery times. Experience with Unistore will be an added advantage

Mock Interview

Practice Video Interview with JobPe AI

Start Hive Interview Now
R Systems International
R Systems International

Information Technology and Services

Gurgaon

5001-10000 Employees

99 Jobs

    Key People

  • Dr. Rajnish Gaur

    Managing Director & CEO
  • Mr. Anand Jha

    Chief Financial Officer

RecommendedJobs for You

Pune, Maharashtra, India

Chennai, Bengaluru, Mumbai (All Areas)

Hyderabad, Telangana, India