AWS Data Engineer

About TechMango:

Founded in 2014, TechMango Technology Services is a leading software development company with a strong focus on emerging technologies. Our primary goal is to deliver strategic solutions that align with our business partners' technological needs.

We specialize in providing custom software solutions using the best available technologies, ensuring quality delivery within defined timelines. Our services include analysis, design, architecture, programming, testing, and long-term technical support, all aimed at achieving ultimate customer satisfaction.

Recognized as the Best Offshore Software Development Company in India, TechMango is driven by the mantra, "Clients' Vision is our Mission." We strive to be a technologically advanced and highly regarded organization, offering high-quality and cost-efficient services while fostering long-term client relationships.

We operate in the USA (Chicago, Atlanta), UAE (Dubai), and India (Bangalore, Chennai, Madurai, Trichy, Coimbatore).

For more information, please visit our website.https://www.techmango.net

Techmango | Digital Transformation Solutions | IT Consulting

We provide cutting-edge technology solutions based on digital, Business Analytics, Cloud, Big Data, IoT, Blockchain, Managed IT Services & Technology

Role: AWS Data Engineer
Key Skills: Python, AWS services (e.g., Glue, Lambda, Step Functions, S3, Redshift, Athena), SQL performance tuning, schema design, indexing, T-SQL, and scripting automation for data ingestion and transformation.

Experience: 4 to 15 Yrs
Location: Madurai / Chennai
Mode : WFO / Remote

Job Title: AWS Data EngineerAbout the Role:
We’re looking for a seasoned AWS Data Engineer to join our Engineering organization and take ownership of the cloud-based systems that power our most critical data-driven decisions. You’ll design, architect, and maintain high-performance, scalable data pipelines and cloud data warehouses using AWS-native services such as Redshift, Glue, S3, Lambda, and Step Functions. This is a high-impact role ideal for someone who thrives in solving complex data challenges, optimizing distributed systems, and being the go-to expert in a collaborative and high-performance engineering team.

What You Will Do:

• Architect, build, and maintain robust and scalable data pipelines using AWS services (e.g., Glue, Lambda, Step Functions, S3, Redshift, Athena).
• Design and optimize schemas for Redshift and Snowflake to support analytics, reporting, and data science needs.
• Implement performant and reliable ETL/ELT processes that handle large volumes of structured and unstructured data.
• Enforce and monitor data SLAs to ensure freshness, reliability, and availability of datasets across environments.
• Collaborate with engineering, product, and analytics teams to transform business requirements into robust data models and pipelines.
• Proactively identify and resolve bottlenecks, data quality issues, and system inefficiencies.
• Implement schema versioning, data lineage tracking, and database change management practices.
• Define and enforce best practices for data governance, access control, observability, and compliance.
• Contribute to CI/CD workflows and infrastructure as code practices using tools like CloudFormation or Terraform.

What You Will Bring:

• 4+ years of experience in data engineering or backend systems development, with a strong focus on cloud-based architectures.
• Deep expertise in AWS data ecosystem—especially Redshift, Glue, S3, Athena, Lambda, Step Functions, and CloudWatch.
• Strong background in SQL performance tuning, schema design, indexing, and partitioning strategies for large datasets.
• Experience maintaining data freshness SLAs and end-to-end ownership of production pipelines.
• Hands-on experience with Python (or PySpark), T-SQL, and scripting automation for data ingestion and transformation.
• Solid understanding of relational and dimensional data modeling, normalization, and schema evolution.
• Experience with source control systems (e.g., Git, Bitbucket) and CI/CD pipelines for data infrastructure.
• Track record of transforming complex business requirements into reliable and scalable data solutions.
• Experience with data governance, security, and compliance frameworks (e.g., HIPAA, GDPR) is a plus.
• Familiarity with monitoring and observability tools (e.g., CloudWatch, Datadog, or Prometheus).
• Bonus: Exposure to Snowflake or MSSQL in hybrid cloud environments.

Nice to Have:

• AWS certifications such as AWS Certified Data Analytics, Solutions Architect, or DevOps Engineer.
• Experience with Apache Airflow, dbt, or other data orchestration tools.
• Familiarity with Kafka, Kinesis, or other streaming technologies.
• Understanding of data mesh or data lakehouse architectures.

Job Type: Full-time

Pay: ₹1,500,000.00 - ₹2,500,000.00 per year

Application Question(s):

• Overall work experience:
• How many years of experience do you have in Data Engineer ?
• How many years of experience do you have in AWS ?
• How many years of experience do you have in python / SQL / ETL ?
• Last working date:
• CTCC:
• ETCC:

Work Location: Remote