AWS Data Engineer - Redshift & Snowflake
- Techmango Technology
- 7 - 12 years
- Chennai
- 28 days ago
- Email to a friend
- Report this job
Job Description
Dear Candidate,
Greetings of the day!!
I am Kantha, and I'm reaching out to you regarding an exciting opportunity with TechMango. You can connect with me on LinkedIn https://www.linkedin.com/in/kantha-m-ashwin-186ba3244/ Or Email: ka*************m@te******o.netTechmango Technology Services is a full-scale software development services company founded in 2014 with a strong focus on emerging technologies. It holds a primary objective of delivering strategic solutions towards the goal of its business partners in terms of technology.
We are a full-scale leading Software and Mobile App Development Company. Techmango is driven by the mantra Clients Vision is our Mission.
We have a tendency to stick on to the current statement. To be the technologically advanced & most loved organization providing prime quality and cost-efficient services with a long-term client relationship strategy. We are operational in the USA - Chicago, Atlanta, Dubai - UAE, in India - Bangalore, Chennai, Madurai, Trichy.
Job Title : Data EngineerLocation: Madurai / ChennaiExperience : 8+ Yrs
The Opportunity
Were looking for a seasoned Data Engineer to join our Engineering organization and take ownership of the systems that power our data-driven decisions. Youll architect and maintain high-performance data pipelines and databases across platforms like MSSQL, Redshift, and Snowflakeensuring data is reliable, accessible, and optimized for scale. If you thrive on solving complex problems, love optimizing systems for performance, and want to be the go-to expert in a collaborative, high-impact environment, wed love to meet you.
What You Will Do:
- Design and maintain scalable, efficient, and well-partitioned schemas in MSSQL, Redshift, and Snowflake
- Architect and optimize complex queries, stored procedures, indexing strategies, and partitioning for large datasets
- Build, monitor, and maintain data pipelines that ensure timely and accurate delivery of data to internal and external consumers
- Own and enforce data refresh SLAs, ensuring availability, consistency, and reliability across production and reporting environments
- Collaborate with software engineers, analysts, and DevOps teams to ensure data models and queries align with product and reporting requirements
- Proactively identify and remediate performance bottlenecks, slow queries, and data inconsistencies
- Implement and manage database change workflows using schema migration/versioning tools
- Define and promote best practices for data access, security, compliance, and observability
What You Will Bring:
- 8+ years of experience in database engineering or backend systems development
- Deep expertise with MySQL, Amazon Redshift, and Snowflake, including schema design and performance optimization
- Design, build, and maintain scalable data pipelines and ETL processes tailored to client needs.
- Proven track record maintaining data freshness SLAs and data quality across production pipelines
- Hands-on experience with T-SQL, LinkSQL, query optimization, and indexing strategies
- Experience with query optimization, mapping tables to blocks and partitions, sub-table structure and keying/indexing for efficiency
- Experience of relational data modeling and schema versioning in support of software development.
- Experience as the sole or lead database expert on a development team.
- Familiarity with source control systems (e.g., Git/Bitbucket) and CI/CD integration.
- Strong problem solving skills are desirable.
- Transforming product requirements into workable solutions, in collaboration with several development and testing teams.
- Writing robust functions, procedures and scripts using SQL.
- Being heavily involved in the day to day running of the business dealing with support and performance issues.
- Diagnose and troubleshoot data-related issues, providing quick and effective resolutions.
- Analyze data workflows and identify areas for improvement, recommending and implementing solutions to optimize performance.
- Utilize a proactive approach to foresee potential problems and address them before they impact operations.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Data EngineerEmployement Type: Full timeContact Details:
Company: Techmango TechnologyLocation(s): Chennai
Keyskills: Amazon Redshift Advance Sql AWS Glue Snowflake
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in