Posted 10 months ago

Senior Data Engineer - R01553752

HyderabadOn-siteFull-time

AI Summary

Senior data engineer who designs and maintains robust ELT/ETL pipelines into Snowflake, optimizes queries, and implements data models for analytics.

About this role

Senior Data Engineer

Primary Skills

DataStream, ETL Fundamentals, SQL, SQL (Basic + Advanced), Python, Data Warehousing, Time Travel and Fail Safe, Snowpipe, SnowSQL, Modern Data Platform Fundamentals, PLSQL, T-SQL, Stored Procedures

Job requirements

Design, develop, and maintain robust ELT/ETL data pipelines to load structured and semi-structured data into Snowflake. Implement data ingestion workflows using tools like Azure Data Factory, Informatica, DBT, or custom Python/SQL scripts.

Write and optimize complex SQL queries, stored procedures, views, and UDFs within Snowflake.

Use Snowpipe for continuous data ingestion and manage tasks, streams, and file formats for near real-time processing Optimize query performance using techniques like clustering keys, result caching, materialized views, and pruning strategies. Monitor and tune warehouse sizing and usage to balance cost and performance.

Design and implement data models (star, snowflake, normalized, or denormalized) suitable for analytical workloads.

Create logical and physical data models for reporting and analytics use cases.

Skills

Analytics Use CasesAzure Data FactoryClustering KeysData ModelsDatastreamData WarehousingDbtDenormalizedETL FundamentalsFail SafeInformaticaLogical Data ModelsMaterialized ViewsModern Data Platform FundamentalsNormalizedPhysical Data ModelsPL/SQLPruning StrategiesPythonPython ScriptsResult CachingSnowflake SchemaSnowpipeSnowSQLSQLSQL (Basic + Advanced)SQL QueriesStar SchemaStored ProceduresTime TravelT-SQLUDFsViews

Senior Data Engineer - R01553752

About this role

Primary Skills

Job requirements

Skills

Explore related jobs

More jobs at Brillio

Similar Analytics Use Cases jobs

Jobs in Hyderabad

Browse these categories