08 Oct
|
Whitekraaft Solutions
|
Ahmedabad
08 Oct
Whitekraaft Solutions
Ahmedabad
Job Location: Hyderabad, Indore and Ahmedabad (India) (WFO)
Experience: 2-4 years
Role Overview
We are seeking a skilled Snowflake Data Engineer responsible for designing, developing, deploying, and supporting enterprise data solutions on the Snowflake platform - building scalable data pipelines, developing metadata-driven frameworks, automating database deployments, and supporting production environments. Comfortable working across both application and database administration domains, producing well-documented, maintainable solutions.
Key Responsibilities
Snowflake Engineering & Development
- Design, develop, and maintain robust data solutions using Snowflake.
- Develop and support database objects: tables, views, streams, tasks, stored procedures, dynamic SQL frameworks.
- Build scalable and performant ETL/ELT pipelines for data integration and analytics workloads.
- Optimize Snowflake query performance, storage utilization, and compute efficiency.
- Implement metadata-driven and configuration-based data processing frameworks.
Database Administration & Scripting
- Develop, support, and maintain database administration scripts for operational and support activities.
- Create automation scripts for database monitoring, housekeeping, deployments, validations, and health checks.- Assist with Snowflake platform administration: role management, access controls, warehouse management, object security.
- Support Amazon Aurora PostgreSQL operational activities: connectivity validation, performance troubleshooting,
access coordination, workplace support.
Database Deployment & Release Management
- Utilize Liquibase for source-controlled database deployments and schema migrations.
- Develop and maintain deployment scripts and release automation processes.
Data Engineering & Operational Support
- Develop efficient data ingestion, transformation, and validation processes.
- Design, develop, and support AWS Glue jobs/workflows for data ingestion, transformation, cataloging, and orchestration.
- Work with Amazon S3 for data landing, staging, archival, file organization, access patterns, and integration with Snowflake/AWS Glue pipelines.
- Support AWS Database Migration Service (AWS DMS) tasks for data replication, migration, validation, monitoring, issue resolution.
- Troubleshoot data pipelines, database performance, and application integrations; perform root cause analysis.
System Integration & DevOps
- Support CI/CD processes for database and data engineering solutions; use GitHub for source control.
- Integrate Snowflake solutions with AWS services (Glue, Aurora PostgreSQL, S3, DMS).
- Familiarity with CI/CD pipelines and DevOps practices.
- Knowledge of data warehousing concepts, dimensional modeling, and enterprise reporting platforms.
- Experience supporting regulatory, audit, and data governance requirements.
Education
Bachelor's or Master's degree in Computer Science, Engineering, or a related field (or equivalent practical experience).
📌 Snowflake -AWS Engineer (Ahmedabad)
🏢 Whitekraaft Solutions
📍 Ahmedabad