Senior Consultant

Job description

**TECHNICAL INTERVIEW** **Drive Location:** Bhubaneswar Office **Date:** July 4, 2026 We are seeking an experienced SAP Integration and Data Architect to design, develop, and maintain our enterprise data landscape. You will bridge cloud integration, data warehousing, and ETL pipelines using SAP CPI, SAP BW, and SAP BODS. **Key Responsibilities** **SAP CPI (Cloud Platform Integration)** - **Design and develop** end-to-end cloud integrations (A2A and B2B). - **Connect SAP Cloud** systems (S/4HANA, SuccessFactors) with non-SAP systems. - **Configure protocols** like SOAP, IDOC, OData, SFTP, and REST adapters. - **Build custom Groovy scripts** or JavaScript for complex data mapping. **SAP BW (Business Warehouse / BW/4HANA)** - **Model data architecture** using Advanced DSOs, Composite Providers, and Open ODS views. - **Extract and transform** data from SAP ERP sources using ODP framework. - **Optimize query performance** using BEx Query Designer or Eclipse Analysis tools. - **Manage process chains** to automate daily data loads and monitoring. **SAP BODS (BusinessObjects Data Services)** - **Create complex ETL jobs** to extract data from heterogeneous legacy databases. - **Apply data cleansing** , validation rules, and transformation logic. - **Tune performance** of data flows through bulk loading and parallel processing. - **Integrate BODS workflows** to feed clean staging data into SAP BW. **Required Skills & Qualifications** **Technical Expertise** - **Experience:** 4 to 13 years in SAP - **Integration:** Proficient in CPI iFlows, certificate management, and API design. - **ETL & Data Quality:** Mastery of BODS Designer, Management Console, and script repositories. - **Data Modeling:** Strong foundation in BW/4HANA or classic BW architecture and LSA++ methodologies. **Soft Skills** - **Problem Solver:** Ability to debug performance bottlenecks across middleware and database layers. - **Communicator:** Clear technical English to coordinate between business analysts and global infrastructure teams.