Senior Analyst, WMS Data (iSeries)
Fulfillment IQ · Bengaluru, Karnataka, India
Tailor my CV for this job — freeGeneral Information:Job Title: Senior Analyst, WMS Data (iSeries)Primary Job Location: Bengaluru, IndiaLocation Flexibility: Hybrid, with 20-30% travel to client sites as needed.
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.You'll work with distribution and fulfillment clients across manufacturing, retail, and 3PL, alongside client configuration and operations leads, BI developers, and FIQ's 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 modern data platformsMust-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 spokenNice to Have:
- 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
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 scaleReporting 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 dataIntegration 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 modern platforms (for example, Microsoft Fabric) as client roadmaps evolveTesting 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 membersKey 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 extensionsWhy You Will Love Working HereAt Fulfillment IQ, we do not just build supply chain solutions, we build long-term careers. We give our people real ownership, real influence, and meaningful responsibility. Whether you are leading a client relationship, shaping a solution, or building internal capability, your decisions have visible impact. We operate with a high-trust, high-standards culture that values clear thinking, collaboration, and accountability without unnecessary hierarchy or bureaucracy.Why You'll Love Working Here:At Fulfillment IQ, we don't just build supply chain solutions—we build careers, friendships, and unforgettable experiences. As an equal opportunity employer, we celebrate diversity and are committed to creating an inclusive environment for all team members. Here's what makes working with us a rewarding experience: Work That Matters
- Imagine being part of projects that reshape the supply chain industry and create real-world impact. Your work here won't just meet expectations, it'll set new ones Career Growth That Matters
- We're serious about growth.
- Whether it's training, mentorship, or new challenges, we'll help you go from good to exceptional.Flexibility to Thrive
- Whether you prefer working remotely, in a hybrid setup, or on-site, we offer flexible options to help you balance work and life effectively.We Celebrate You
- From work anniversaries to team achievements, we value your contributions and celebrate milestones with thoughtful rewards like vouchers and team events.A Collaborative Culture
- Work alongside some of the brightest minds in the industry. Our supportive and inclusive culture ensures every voice is heard, and every team member feels valued.Perks you'll appreciate:Health and Wellness
- Comprehensive group medical insurance for you and your family, in line with local practice
- Employee wellness programs where applicable Time Off
- Competitive paid time off, sick leave, and public holidays
- Flexible leave policies that respect local labour standardsRetirement and Financial Security
- Statutory retirement and social security contributions (Employees' Provident Fund, Employees' State Insurance where applicable, and gratuity)
- Employee stock options (ESOP), where applicableProfessional Growth
- Dedicated learning and development budget, with support for skills, leadership, and career progression Flexible Work
- Remote and hybrid work options, flexible hours aligned to role and client needs Additional Perks
- Equipment and workstation allowances, internet and business travel reimbursements, team events and offsitesWork Authorization:
- Applicants must be legally authorized to work in India. Use of Artificial Intelligence in Hiring:FIQ uses artificial intelligence to assist in the screening, assessment, and shortlisting of applications for this position, including features within our applicant tracking system. AI supports human reviewers and does not make hiring decisions on its own. Final hiring decisions are made by FIQ personnel. If you have questions about how AI is used in this process, contact hr@fulfillmentiq.com.Accommodations:FIQ is committed to an inclusive and accessible recruitment process. Consistent with the Rights of Persons with Disabilities Act, 2016, accommodations are available on request at any stage of recruitment and assessment. Contact hr@fulfillmentiq.com, and we will work with you to meet your needs.Candidate Privacy:Your personal information is collected and used for recruitment purposes in accordance with FIQ's Candidate Privacy Notice, available here, and in accordance with India's Digital Personal Data Protection Act, 2023. This includes the use of AI-assisted screening described above, as well as cross-border storage or processing that may occur in the United States. By applying, you acknowledge this notice. Questions: hr@fulfillmentiq.com.Equal Opportunity:Fulfillment IQ is a people-first company built on trust, collaboration, and ownership. We are proud to be an equal opportunity employer and are committed to building a diverse, inclusive, and high-performing workplace. We provide equal opportunity in line with the Constitution of India and consider all qualified applicants without regard to religion, race, caste, sex, place of birth, disability, or any other characteristic protected under applicable Indian law.Safe and Respectful Workplace:FIQ maintains a safe and respectful workplace and complies with the Sexual Harassment of Women at Workplace (Prevention, Prohibition and Redressal) Act, 2013 (POSH). We have a constituted Internal Committee to receive and address complaints, and every employee is covered by our anti-harassment policy from day one. Learn More About Us:Website: fulfillmentiq.comLinkedIn: Fulfillment IQSpotify: eCom Logistics Podcast SpotifyYouTube: eCom Logistics Podcast YouTube