AWS Data Engineer

Role Overview: As an AWS Data Engineer at TechMango Technology Services, you will be responsible for designing, architecting, and maintaining high-performance, scalable data pipelines and cloud data warehouses using AWS services like Redshift, Glue, S3, Lambda, and Step Functions. Your role will involve solving complex data challenges, optimizing distributed systems, and collaborating with a high-performance engineering team. Key Responsibilities: - Architect, build, and maintain robust and scalable data pipelines using AWS services such as Glue, Lambda, Step Functions, S3, Redshift, and Athena. - Design and optimize schemas for Redshift and Snowflake to support analytics, reporting, and data science requirements. - Implement efficient and reliable ETL/ELT processes for handling large volumes of structured and unstructured data. - Enforce and monitor data SLAs to ensure data freshness, reliability, and availability across environments. - Collaborate with engineering, product, and analytics teams to translate business requirements into robust data models and pipelines. - Identify and resolve bottlenecks, data quality issues, and system inefficiencies proactively. - 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. Qualifications Required: - 4+ years of experience in data engineering or backend systems development with a focus on cloud-based architectures. - Proficiency in AWS data ecosystem, including Redshift, Glue, S3, Athena, Lambda, Step Functions, and CloudWatch. - Strong background in SQL performance tuning, schema design, indexing, and partitioning strategies for large datasets. - Hands-on experience with Python, T-SQL, and scripting automation for data ingestion and transformation. - Understanding of relational and dimensional data modeling, normalization, and schema evolution. - Experience with source control systems like Git, Bitbucket, and CI/CD pipelines for data infrastructure. - Track record of translating complex business requirements into scalable data solutions. - Knowledge of data governance, security, and compliance frameworks is a plus. - Familiarity with monitoring and observability tools like CloudWatch, Datadog, or Prometheus. - Bonus: Exposure to Snowflake or MSSQL in hybrid cloud environments. Additional Details about the Company: TechMango Technology Services, founded in 2014, is a leading software development company focusing on emerging technologies. They aim to deliver strategic solutions aligned with their business partners" technological needs and are recognized as the Best Offshore Software Development Company in India. Operating in the USA, UAE, and India, TechMango strives to offer high-quality and cost-efficient services while fostering long-term client relationships.,