16 Nov
|
Fulfillment IQ
|
Bengaluru
16 Nov
Fulfillment IQ
Bengaluru
Job highlights
- RPG,CL,or COBOL experience on IBM i.
- Experience with Microsoft Fabric,Azure Data Factory,Snowflake,or other modern data platforms. Data migration experience from legacy iSeries WMS to cloud WMS (for example,Manhattan Active WM). Python or other scripting for data automation. Manufacturing,retail,or 3PL distribution experience
Job Details
- Job Title: Senior Consultant - Manhattan WMi (iSeries / AS400)
- Primary Job Location: Hybrid, Bengaluru based, or Remote within India
- Employment Type: Full-time employment
Role Overview
This role supports FIQ client engagements where the warehouse runs on an IBM i (iSeries / AS/400) WMS, such as Manhattan WMi (PkMS), Blue Yonder (JDA) WMS on IBM i, or a comparable legacy platform.
The primary focus is WMS data: getting accurate, timely data out of DB2 and into the hands of operations, reporting, and leadership teams, then supporting the integrations and system changes that depend on it.
Youll work with distribution and fulfillment clients across manufacturing, retail, and 3PL, alongside client configuration and operations leads, BI developers, and FIQs onshore and offshore delivery teams. This is a techno-functional seat: strong SQL and data skills come first, backed by enough warehouse process knowledge to know what the data means. Depending on the engagement, the work extends into WCS, LMS, ERP, and MHE integration, testing and go-live support, and helping clients modernize, whether that means moving to a modern data platform or migrating from a legacy WMS to a cloud WMS.
Mandate
- Extract, transform, and deliver WMS data from DB2 on iSeries to BI and reporting platforms
- Own the WMS data model on each engagement: table structures, relationships, and field definitions
- Turn operational questions into accurate, repeatable queries and data feeds
- Support WMS integrations with WCS, LMS, ERP, TMS, and MHE, including data mapping and testing
- Help clients move from ad hoc data pulls toward governed,
scalable reporting and contemporary data platforms
Must-Have Qualifications
- Technical: 5+ years as a technical or techno-functional analyst on a WMS running on IBM iSeries (AS/400), such as Manhattan WMi, JDA/Blue Yonder WMS on iSeries, or similar
- Technical: advanced DB2 for i SQL skills, including complex joins, performance tuning, and extracting large data sets quickly and reliably
- Technical: experience building data extracts, views, or pipelines that feed BI and reporting tools (Cognos, Power BI, Tableau, or similar)
- Technical: working knowledge of WMS integrations with WCS, LMS, ERP, TMS, or MHE, including flat file, socket-based, and API-based interfaces
- Functional: solid understanding of warehouse processes (receiving, inventory, replenishment, wave planning and release, picking, packing, shipping) and how they are represented in WMS data
- Functional: experience with data validation and reconciliation, and supporting testing (unit, SIT, UAT) for data and integration changes
- Ways of working: able to ramp quickly in a new client environment, handle high volumes of data requests, and collaborate with onshore and offshore teams
- Travel: able to travel 20-30% to client sites as needed
- Language: professional working proficiency in English, written and spoken
Nice to Have
- RPG, CL, or COBOL experience on IBM i
- Experience with Microsoft Fabric, Azure Data Factory, Snowflake, or other contemporary data platforms
- Data migration experience from legacy iSeries WMS to cloud WMS (for example, Manhattan Active WM)
- Python or other scripting for data automation
- Manufacturing, retail, or 3PL distribution experience
Key Responsibilities
Data Extraction and Modeling
- Write and optimize DB2 SQL to extract inventory, order, wave, labor, and shipping data from iSeries WMS platforms
- Build repeatable extracts, views, and scheduled data feeds for BI developers and analysts
- Document WMS data models, key tables, and field definitions so reporting can scale
Reporting and Analytics Enablement
- Partner with BI developers to design data sets that support operational dashboards and KPIs
- Respond to ad hoc data requests from operations and leadership with accurate, timely answers
- Validate and reconcile reporting outputs against source WMS data
Integration Support
- Map WMS integration touchpoints, message formats, and data flows with WCS, LMS, ERP, TMS, and MHE
- Troubleshoot integration and data issues, and support changes during system migrations
- Support data movement into up-to-date platforms (for example, Microsoft Fabric) as client roadmaps evolve
Testing and Knowledge Transfer
- Write test scenarios and run data validation for SIT and UAT
- Provide on-site support during cutovers and stabilization as needed
- Document queries, integrations, and fixes, and coach client and offshore team members
Key Performance Indicators
- Turnaround time on data extraction and ad hoc query requests
- Dashboards and reports live on reliable WMS data within the first 60 days of an engagement
- Data accuracy and reconciliation rate between WMS source and reporting outputs
- Integration and data defects found and resolved before go-live
- Client satisfaction and engagement extensions
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
📌 Senior Consultant - Manhattan WMi (iSeries / (Bengaluru)
🏢 Fulfillment IQ
📍 Bengaluru