Snow flake /AWS Engineer

About Kanerika

Who we are :

Kanerika Inc. is a premier global software products and services firm that specializes in providing innovative solutions and services for data-driven enterprises. Our focus is to empower businesses to achieve their digital transformation goals and maximize their business impact through the effective use of data and AI . We leverage cutting-edge technologies in data analytics, data governance, AI-ML, GenAI/ LLM and industry best practices to deliver custom solutions that help organizations optimize their operations, enhance customer experiences, and drive growth.

Awards and Recognitions

Kanerika has won several awards over the years, including:

- CMMI Level 3 Appraised in 2024.

- Best Place to Work 2023 by Great Place to Work

- Top 10 Most Recommended RPA Start-Ups in 2022 by RPA today.

- Frost & Sullivan India 2021 Technology Innovation Award for its Kompass composable solution architecture.

- Kanerika has also been recognized for its commitment to customer privacy and data security, having achieved, ISO 9001, ISO 27701, SOC2, and GDPR compliances .

Working for us

Kanerika is rated 4. 6 /5 on Glassdoor, for many good reasons. We truly value our employees' growth, well-being, and diversity, and people’s experiences bear this out. At Kanerika, we offer a host of enticing benefits that create an environment where you can thrive both personally and professionally. From our inclusive hiring practices and mandatory training on creating a safe work environment to our flexible working hours and generous parental leave, we prioritize the well-being and success of our employees. Our commitment to professional development is evident through our mentorship programs, job training initiatives, and support for professional certifications. Additionally, our company-sponsored outings and various time-off benefits ensure a healthy work-life balance. Join us at Kanerika and become part of a vibrant and diverse community where your talents are recognized, your growth is nurtured, and your contributions make a real impact. See the benefits section below for the perks you’ll get while working for Kanerika.

Locations

We are located in Austin (USA), Singapore, Hyderabad, Indore and Ahmedabad (India).

Job Location: Hyderabad, Indore and Ahmedabad ( India )
Skills Required:

We are seeking a skilled
Snowflake Data Engineer to join our team. The ideal candidate will be
responsible for designing, developing, deploying, and supporting enterprise
data solutions on the Snowflake platform. This role involves building scalable
data pipelines, developing metadata-driven frameworks, automating database
deployments, and supporting production environments. The successful candidate
will possess strong troubleshooting skills, be comfortable working across both
application and database administration domains, and consistently produce
well-documented, maintainable solutions.

Key Responsibilities

Snowflake Engineering &
Development

• Design, develop, and maintain
robust data solutions using Snowflake.

• Develop and support database
objects including tables, views, streams, tasks, stored procedures, and 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 activities, including role management, access controls,
warehouse management, and object security.

• Support operational automation
across development, test, and production environments.

• Support Amazon Aurora
PostgreSQL operational activities, including connectivity validation,
performance troubleshooting, access coordination, and environment support.

Database Deployment &
Release Management

• Utilize Liquibase for
source-controlled database deployments and schema migrations.

• Develop and maintain
deployment scripts and release automation processes.

• Ensure database changes are
properly version-controlled, tested, and promoted through environments.

• Partner with development and
operations teams to establish deployment standards and best practices.

Data Engineering &
Operational Support

• Develop efficient data
ingestion, transformation, and validation processes.

• Design, develop, and support
AWS Glue jobs and workflows for data ingestion, transformation, cataloging, and
orchestration across cloud and enterprise data platforms.

• Work with Amazon S3 for data
landing, staging, archival, file organization, access patterns, and integration
with Snowflake and AWS Glue pipelines.

• Support AWS Database Migration
Service (AWS DMS) tasks for data replication, migration, validation,
monitoring, and issue resolution across source and target platforms.

• Troubleshoot and resolve
issues related to data pipelines, database performance, and application
integrations.

• Perform root cause analysis
and implement corrective actions for recurring issues.

• Monitor data loads, data
quality processes, and platform performance to ensure reliability and
availability.

• Support production incident
management and operational escalations.

Software Engineering &
Documentation

• Write clean, maintainable, and
supportable code following engineering best practices.

• Design solutions with
long-term maintenance, observability, and troubleshooting requirements in mind.

• Implement appropriate logging,
exception handling, auditing, and monitoring capabilities.

• Produce comprehensive
technical documentation for all solutions, processes, and deployments.

• Create and maintain
operational runbooks, troubleshooting guides, architectural documentation, and
knowledge transfer materials.

• Ensure all code deliveries are
supplemented with proper and abundant documentation to support future
maintenance and operational activities.

System Integration & DevOps

• Support CI/CD processes for
database and data engineering solutions.

• Utilize GitHub for source code
management, version control, and collaboration.

• Collaborate with application
development, infrastructure, and data teams to deliver integrated enterprise
solutions.

• Integrate Snowflake solutions
with AWS services, including AWS Glue, Amazon Aurora PostgreSQL, Amazon S3, and
AWS DMS, to support scalable enterprise data processing and interoperability.

• Participate in code reviews,
deployment reviews, and technical design discussions.

Requirements

• At least 2 years of relevant
data engineering experience, including hands-on work with cloud data platforms
and production data environments.

• Strong hands-on working
experience with Snowflake development and administration.

• Proficiency in writing and
optimizing complex SQL queries and Snowflake stored procedures.

• Hands-on proficiency with AWS
Glue for ETL development, workflow orchestration, job monitoring, and
troubleshooting.

• Experience developing database
and application support scripts.

• Experience working with Amazon
Aurora PostgreSQL, including SQL development, integration support, operational
troubleshooting, and performance analysis.

• Experience working with Amazon
S3 for storage, ingestion, staging, and integration with cloud-native data
pipelines.

• Experience with AWS DMS for
database migration, change data capture, replication monitoring, and
troubleshooting.

• Hands-on experience with
Liquibase for database deployment and schema version management.

• Strong troubleshooting,
analytical, and problem-solving skills.

• Experience supporting
production data warehouse or data platform environments.

• Ability to develop
maintainable, reusable, and well-documented code.

• Experience with source control
systems such as GitHub.

• Excellent verbal and written
communication skills.

• Strong attention to detail and
commitment to operational excellence.

Preferred Qualifications (Plus)

• Experience with cloud
platforms such as AWS.

• Experience building
cloud-native data pipelines using AWS Glue, Amazon Aurora PostgreSQL, Amazon
S3, AWS DMS, Snowflake, and related AWS data services.

• Experience with Snowflake
performance tuning and cost optimization.

• Experience implementing
metadata-driven frameworks and data validation solutions.

• Proficiency with Python, Shell
Scripting.

• Familiarity with CI/CD
pipelines and DevOps practices.

• Knowledge of data warehousing
concepts, dimensional modeling, and enterprise reporting platforms.

• Experience with monitoring,
observability, and operational support frameworks.
• Experience
supporting regulatory, audit, and data governance requirements.

Benefits

Why join us?

· Work with a passionate and innovative team in a fast-paced, growth-oriented environment.

· Gain hands-on experience in content marketing with exposure to real-world projects.

· Opportunity to learn from experienced professionals and enhance your marketing skills.

· Contribute to exciting initiatives and make an impact from day one.

· Competitive stipend and potential for growth within the company.

· Recognized for excellence in data and AI solutions with industry awards and accolades.