19 Nov
|
Trigent Software
|
Bengaluru
19 Nov
Trigent Software
Bengaluru
Snowflake Administration & Optimization:
· Optimize Snowflake performance, query efficiency, cost/credit utilization, and
overall data architecture.
· Implement best practices for data security, governance, backup/disaster
recovery, and zero copy cloning.
Data Transformations with dbt:
· Design, develop, and maintain production-grade dbt models (SQL) to transform
raw data into clean, documented, and tested analytics datasets.
· Implement automated testing, documentation, and data quality checks within
dbt project workflows.
PostgreSQL Database Management:
· Design, configure, tune, and maintain production PostgreSQL databases.
· Monitor performance, execute index tuning, manage schema migrations, and
maintain high availability.
Data Operations & Analytics Support:
· Build and maintain effective ELT pipelines connecting PostgreSQL, Snowflake,
and downstream analytics tooling.
· Support the analytics team by developing or optimizing semantic models and
dashboards in Sigma or Power BI (nice-to-have).
Qualifications & Requirements Must-Haves:
Snowflake DBA / Platform Admin Experience:
· 5+ years of hands-on experience administering and tuning enterprise-level
Snowflake environments.
dbt (data build tool) Expertise:
· Hands-on experience building, testing, and deploying data transformation
models with dbt Core or dbt Cloud.
PostgreSQL Administration:
· Strong practical experience managing, indexing, and tuning PostgreSQL
databases.
SQL Mastery & Data Modelling:
· Deep understanding of advanced SQL, dimensional modeling (Kimball
methodology), and analytical query optimization.
Nice-to-Haves:
· BI / Visualization Experience: Hands-on experience building reports,
dashboards, or semantic models in Sigma or Microsoft Power BI.
Logistics & Supply Chain Domain Knowledge:
· Exposure to logistics concepts (e.g., shipment tracking, warehouse
management, freight operations, supply chain KPIs).
· Data Engineering Tooling: Experience with orchestration tools (e.g., Airflow,
Dagster, Prefect) and Git workflows.
📌 DataEngineer_Snowflake (Bengaluru)
🏢 Trigent Software
📍 Bengaluru