Enterprise Horizon Consulting Group

Data Engineer

• Execute data extractions from SAP ECC using SAP Data Services (BODS)
• Query and analyze source and staging data using SAP HANA SQL
• Build, maintain, and optimize dataflows, workflows, and extraction jobs
• Perform source data analysis and data profiling to identify data quality issues
• Perform source to target field-level data mappings
• Apply transformation rules, derivations, and validations within SAP Data Services
• Translate functional mapping specifications into executable ETL logic
• Load master and transactional data into SAP S/4HANA using Migration Cockpit and LSMW.
• Execute mock loads and support cutover load activities
• Analyze load errors, correct data issues, and reprocess loads as required
• Validate data across source systems, staging, and S/4HANA targets
• Reconcile record counts, balances, and key attributes based on defined validation criteria
• Support defect resolution and retesting during mock cycles
• Identify data quality issues such as duplicates, missing values, and invalid formats
• Support cleansing activities in coordination with business data owners
• Implement data correction logic within SAP Data Services where applicable
• Support mock load cycles, dress rehearsals, and production cutover execution
• Execute data loads according to defined load waves, object sequencing, and cutover schedules
• Perform root-cause analysis of load and validation errors across BODS, Migration Cockpit, and HANA layers
• Maintain and update mapping specifications and transformation logic documentation
• Track, analyze, and remediate data defects using defined defect management processes
• Validate data readiness prior to load execution (completeness, format, dependencies)
• Work with functional teams to resolve data issues tied to configuration or business rules

SAP Data Migration Specialist

Software Engineer

• **Key Responsibilities**
• **1. Core Logistics Data Integration**
• ● **SAP Connectivity:** Design and implement robust integration flows to extract and ingest data the MuleSoft SAP Connector (RFC, BAPI, IDoc) for both synchronous and asynchronous transactions.
• ● **Legacy Data Transformation:** Develop complex **DataWeave 2.0** scripts to translate, cleanse, and canonicalize data between DoD logistics standards and internal JSON/XML formats.
• ● **Reliability & Resilience:** Implement advanced error handling, queue-based patterns (e.g., Anypoint MQ Store and Forward), and guaranteed delivery mechanisms to ensure no mission-critical requisition or inventory update is ever lost.
• ● **Testing & Quality:** Write comprehensive **MUnit** test suites to achieve mandated code coverage (90%+) and validate complex business logic against DoD process rules.
• **2. Agentic AI Data Serving & Protocol **
• ● **Model Context Protocol (MCP) Server Development:** Design and build specialized MuleSoft APIs (acting as "MCP Servers") optimized to serve contextual data directly to Agentic AI systems and RAG pipelines.
• ● **Vector & RAG Database Access:** Implement connectivity patterns to secure Vector Databases and other specialized data stores that house indexed, vectorized logistics information.
• ● **Efficient Data Retrieval:** Tune APIs for ultra-low-latency data retrieval necessary for AI models, focusing on minimizing payload size and optimizing database queries (SQL, NoSQL, or Graph) originating from the Mule flow.
• ● **Security for AI:** Enforce strict access control, tokenization, and data masking policies within the API layer.
• ● **Metadata Management:** Ensure that all served data includes rich, accurate metadata (timestamps, source system, confidence score) to improve the grounding and auditability of AI-generated responses.

SAP Data Migration Specialist

SAP Legacy Integration Developer