Snow flake /AWS Engineer
Zohorecruit
Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.
Job summary
Kanerika Inc. is seeking a skilled Snowflake Data Engineer to design, develop, and maintain enterprise data solutions on the Snowflake platform.
You will build scalable ETL/ELT pipelines, optimize performance, and support database objects and automation workflows across cloud environments. The ideal candidate has 2+ years of data engineering experience with cloud data platforms, strong SQL and Snowflake proficiency, and hands-on experience with AWS Glue, Aurora PostgreSQL, and S3 integrations.
Qualifications
- 2+ years of data engineering experience with cloud data platforms.
- Strong Snowflake development and administration experience.
- Proficiency in writing and optimizing SQL queries and Snowflake procedures.
- Hands-on experience with AWS Glue for ETL development and orchestration.
- Experience with Amazon Aurora PostgreSQL and Amazon S3 integration.
Responsibilities
- Design, develop, and maintain Snowflake data solutions.
- Build scalable ETL/ELT pipelines for analytics workloads.
- Develop and support database objects and SQL frameworks.
- Support CI/CD processes for data engineering solutions.
- Produce clear technical documentation and runbooks.
Skills
Tools
Job description
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.
- 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 .
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.
We are located in Austin (USA), Singapore, Hyderabad, Indore and Ahmedabad (India).
Hyderabad, Indore and Ahmedabad ( India )
We are seeking a skilledSnowflake Data Engineer to join our team. The ideal candidate will be responsible for designing, developing, deploying, and supporting enterprisedata solutions on the Snowflake platform. This role involves building scalabledata pipelines, developing metadata-driven frameworks, automating databasedeployments, and supporting production environments. The successful candidatewill possess strong troubleshooting skills, be comfortable working across bothapplication and database administration domains, and consistently producewell-documented, maintainable solutions.
- Design, develop, and maintainrobust data solutions using Snowflake.
- Develop and support databaseobjects including tables, views, streams, tasks, stored procedures, and dynamicSQL frameworks.
- Build scalable and performantETL/ELT pipelines for data integration and analytics workloads.
- Optimize Snowflake queryperformance, storage utilization, and compute efficiency.
- Implement metadata-driven andconfiguration-based data processing frameworks.
- Develop, support, and maintaindatabase administration scripts for operational and support activities.
- Create automation scripts fordatabase monitoring, housekeeping, deployments, validations, and health checks.
- Assist with Snowflake platformadministration activities, including role management, access controls,warehouse management, and object security.
- Support operational automationacross development, test, and production environments.
- Support Amazon AuroraPostgreSQL operational activities, including connectivity validation,performance troubleshooting, access coordination, and environment support.
- Utilize Liquibase forsource-controlled database deployments and schema migrations.
- Develop and maintaindeployment scripts and release automation processes.
- Ensure database changes areproperly version-controlled, tested, and promoted through environments.
- Partner with development andoperations teams to establish deployment standards and best practices.
- Develop efficient dataingestion, transformation, and validation processes.
- Design, develop, and supportAWS Glue jobs and workflows for data ingestion, transformation, cataloging, andorchestration across cloud and enterprise data platforms.
- Work with Amazon S3 for datalanding, staging, archival, file organization, access patterns, and integrationwith Snowflake and AWS Glue pipelines.
- Support AWS Database MigrationService (AWS DMS) tasks for data replication, migration, validation,monitoring, and issue resolution across source and target platforms.
- Troubleshoot and resolveissues related to data pipelines, database performance, and applicationintegrations.
- Perform root cause analysisand implement corrective actions for recurring issues.
- Monitor data loads, dataquality processes, and platform performance to ensure reliability andavailability.
- Support production incidentmanagement and operational escalations.
- Write clean, maintainable, andsupportable code following engineering best practices.
- Design solutions withlong-term maintenance, observability, and troubleshooting requirements in mind.
- Implement appropriate logging,exception handling, auditing, and monitoring capabilities.
- Produce comprehensivetechnical documentation for all solutions, processes, and deployments.
- Create and maintainoperational runbooks, troubleshooting guides, architectural documentation, andknowledge transfer materials.
- Ensure all code deliveries aresupplemented with proper and abundant documentation to support futuremaintenance and operational activities.
- Support CI/CD processes fordatabase and data engineering solutions.
- Utilize GitHub for source codemanagement, version control, and collaboration.
- Collaborate with applicationdevelopment, infrastructure, and data teams to deliver integrated enterprisesolutions.
- Integrate Snowflake solutionswith AWS services, including AWS Glue, Amazon Aurora PostgreSQL, Amazon S3, andAWS DMS, to support scalable enterprise data processing and interoperability.
- Participate in code reviews,deployment reviews, and technical design discussions.
- At least 2 years of relevantdata engineering experience, including hands-on work with cloud data platformsand production data environments.
- Strong hands-on workingexperience 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, andtroubleshooting.
- Experience developing databaseand application support scripts.
- Experience working with AmazonAurora PostgreSQL, including SQL development, integration support, operationaltroubleshooting, and performance analysis.
- Experience working with AmazonS3 for storage, ingestion, staging, and integration with cloud-native datapipelines.
- Experience with AWS DMS fordatabase migration, change data capture, replication monitoring, andtroubleshooting.
- Hands-on experience withLiquibase for database deployment and schema version management.
- Strong troubleshooting,analytical, and problem-solving skills.
- Experience supportingproduction data warehouse or data platform environments.
- Ability to developmaintainable, reusable, and well-documented code.
- Experience with source controlsystems such as GitHub.
- Excellent verbal and writtencommunication skills.
- Strong attention to detail andcommitment to operational excellence.
- Experience with cloudplatforms such as AWS.
- Experience buildingcloud-native data pipelines using AWS Glue, Amazon Aurora PostgreSQL, AmazonS3, AWS DMS, Snowflake, and related AWS data services.
- Experience with Snowflakeperformance tuning and cost optimization.
- Experience implementingmetadata-driven frameworks and data validation solutions.
- Proficiency with Python, ShellScripting.
- Familiarity with CI/CDpipelines and DevOps practices.
- Knowledge of data warehousingconcepts, dimensional modeling, and enterprise reporting platforms.
- Experience with monitoring,observability, and operational support frameworks.
- Experiencesupporting regulatory, audit, and data governance requirements.
- 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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
