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,SQL,ETL

Experience: 4 to 15 Yrs

Location: Madurai / Chennai

Mode : Remote

Job Title:  AWS Data Engineer

About the Role:

We’re looking for a seasoned AWS Data Engineer

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.