Aws Architect

Job Title: AWS Architect
Location: Hyderabad/Indore
Job Type: Full-time

AWS Glue (as a data engineer but not infra)

AWS S3 (as a data engineer but not infra)

AWS Redshift (as a data engineer but not infra)

AWS Athena (as a data engineer but not infra)

Programming - SQL, Python, Pyspark

Make sure you have worked in a data analytics project as a data engineer and leading a track/module/individual contributor with exhaustive exp.

ETL, Spark, AWS Glue or EMR is mandatory.

Redshift good to have.

Candidate should have knowledge on Data lake/Data warehousing/Lakehouse..

Position Summary

We are seeking a highly experienced AWS Data Engineering Architect (10-12 years) to lead the design and delivery of enterprise-scale data platforms. This role requires a unique blend of deep technical expertise across AWS data services and strong functional knowledge of SAP Data Models (ECC, S/4HANA) alongside traditional and modern data sources like MySQL, Oracle, REST/OData APIs, and RDS. You will be responsible for architecting end-to-end Data Lakehouse solutions that consolidate disparate data sources into a unified, high-performance analytics platform.

Key Responsibilities

• Multi-Source Data Architecture: Design and implement scalable AWS Data Lake and Lakehouse architectures that integrate (MySQL, Oracle, RDS, On-premise).
• Modern API Ingestion: Architect and build ingestion frameworks for RESTful and OData APIs using AWS Glue, Lambda, and Amazon API Gateway.
• Enterprise ETL/ELT: Lead the development of robust data pipelines using AWS Glue (PySpark), Amazon EMR, and AWS Step Functions, ensuring optimized CDC (Change Data Capture) from RDS, Oracle, and MySQL sources.
• Data Modeling & Warehousing: Define conceptual, logical, and physical data models for Amazon Redshift and S3-based storage using open table formats like Apache Iceberg.
• Performance & Cost Engineering: Optimize environments for large-scale data processing, focusing on query performance and cost-efficiency using AWS Lake Formation.

Technical Requirements

• AWS Core: Mastery of S3, Glue, Redshift, Lambda, Athena, Airflow, MWAA, EMR, Kinesis, Lake Formation, and RDS.
• Database Expertise: Strong hands-on experience with MySQL, Oracle, and AWS Aurora/RDS.
• API & Integration: Proficiency in consuming and architecting REST APIs and OData services for data ingestion.
• Languages: Expert-level Python/PySpark and Advanced SQL.

Preferred Qualifications

• 10-12 years of IT experience, with 5+ years specifically in AWS Data Architect.
• AWS Certified Data Engineer Associate or AWS Certified Solutions Architect – Professional.
• Excellent verbal and written communication for high-level stakeholder management.
• Experience in Agile/DevOps methodologies for data engineering.