Data Engineering | Generative AI | Microsoft Dynamics 365 | AI &ML | Application Modernization | Business Intelligence
Senior AWS Redshift Data Engineer
Location
India
Posted
81 days ago
Salary
0
Seniority
Senior
Job Description
Senior AWS Redshift Data Engineer
Techmango Technology Services Private Limited
• 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.
Job Requirements
- 7+ 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.
Benefits
- Work with a fast-growing global data engineering team.
- Opportunity to learn and grow in advanced cloud and analytics technologies.
- Competitive salary and performance-based incentives.
- A collaborative and innovation-driven work environment.
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
• Own the end-to-end migration workflow for new customers. • Design mapping strategies to transform competitor data into our unified schema. • Build and maintain migration tooling (scripts, internal apps, reusable templates). • Collaborate with Client Success and Product teams to resolve data discrepancies and edge cases. • Optimize and automate recurring migration tasks to drive scalability. • Diagnose and troubleshoot migration issues quickly and systematically. • Continuously refine best practices for schema evolution, error handling, and data validation.
Data Migration Manager – Implementation Specialist
Fundraise UpUnlocking the world's generosity potential
• Lead the full lifecycle of data migration projects, from initial planning to executing the final “red button” push. • Collaborate closely with clients, CRM providers, and payment system representatives to collect, validate, and prepare all required data files. • Determine optimal migration timelines and coordinate schedules that work for all stakeholders. • Maintain transparent and ongoing communication with all parties to provide updates, address concerns, and ensure smooth execution. • Confidently operate software tools and systems related to data migration (no programming required). • Manage multiple complex projects simultaneously, ensuring deadlines and quality standards are met. • Adhere to strict guidelines and agreements, maintaining a high level of accuracy and consistency. • Participate in regular cross-team discussions on product, sales, support, customer feedback, and performance metrics.
Data Migration Manager, Implementation Specialist
Fundraise UpUnlocking the world's generosity potential
• Lead the full lifecycle of data migration projects, from initial planning to executing the final “red button” push. • Collaborate closely with clients, CRM providers, and payment system representatives to collect, validate, and prepare all required data files. • Determine optimal migration timelines and coordinate schedules that work for all stakeholders. • Maintain transparent and ongoing communication with all parties to provide updates, address concerns, and ensure smooth execution. • Confidently operate software tools and systems related to data migration (no programming required). • Manage multiple complex projects simultaneously, ensuring deadlines and quality standards are met. • Adhere to strict guidelines and agreements, maintaining a high level of accuracy and consistency. • Participate in regular cross-team discussions on product, sales, support, customer feedback, and performance metrics.
• Building and maintaining the core data infrastructure that powers analytics across the company. • Designing pipelines and data models that pull from product systems, observability tooling, and external sources into a reliable, scalable data platform. • Working closely with SRE, product, and engineering teams to ensure data is correctly captured, structured, and aligned across services. • Maintaining observability stacks to support debugging and system reliability. • Defining and enforcing data quality standards. • Supporting KPI development and ensuring all pipelines and data flows meet security, privacy, and compliance requirements.



