Job Title

Job Title: Senior AWS Data Architect – Enterprise Data Integration (SAP & Multi-Source) Experience Level:10–12 Years Location:Hyderabad/Indore Job Type:Full-time .Position Summary We are seeking a highly experiencedAWS 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 ofSAP Data Models(ECC, S/4HANA) alongside traditional and modern data sources likeMySQL, 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 SAP (ERP, BW) and non-SAP sources (MySQL, Oracle, RDS, On-premise). SAP Functional Integration:Leverage deep functional understanding of SAP modules (FICO, SD, MM) and table structures (e.g., KNA1, MARA, BSEG) to design efficient extraction strategies usingSAP ODP, OData APIs, SLT, and BW extractors . Modern API Ingestion:Architect and build ingestion frameworks forRESTful and OData APIsusing AWS Glue, Lambda, and Amazon API Gateway. Enterprise ETL/ELT:Lead the development of robust data pipelines usingAWS 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 forAmazon Redshiftand S3-based storage using open table formats likeApache Iceberg . Performance & Cost Engineering:Optimize environments for large-scale data processing, focusing on query performance and cost-efficiency using AWS Lake Formation. Stakeholder Communication:Act as the primary technical liaison between business functional owners, SAP consultants, and data engineering teams to translate business needs into technical specifications. Technical Requirements AWS Core:Mastery of S3, Glue, Redshift, Lambda, Athena, Airflow, MWAA, EMR, Kinesis, Lake Formation, and RDS. SAP Specialization:Proven experience with SAP S/4HANA or ECC data extraction; knowledge of SAP BTP or Datasphere is a significant plus. Database Expertise:Strong hands-on experience withMySQL, Oracle , andAWS Aurora/RDS . API & Integration:Proficiency in consuming and architectingREST APIsandODataservices for data ingestion. Languages:Expert-levelPython/PySparkandAdvanced SQL . Preferred Qualifications 10-12 years of IT experience, with 5+ years specifically in AWS Data Architecture. 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.