CoreHRx Jobs

Apply in one click, save jobs and take free mock tests.

Register free Log in
Hiring? Post jobs with CoreHRx
My account
user

View & update profile

Senior Consultant - Manhattan WMi (iSeries / AS400)

Fulfillment IQ

Full time Hybrid
Location
Bangalore
Work mode
Hybrid
Posted 1 day ago Last checked 2 hr ago

Free · takes a minute · your resume fills your profile

CoreHRx never asks candidates for money. If anyone does, .

Role at a glance

You will
  • This role supports FIQ client engagements where the warehouse runs on an IBM i (iSeries / AS/400) WMS, such as Manhattan WMi (PkMS), Blue…
  • The primary focus is WMS data: getting accurate, timely data out of DB2 and into the hands of operations, reporting, and leadership teams…
  • You'll work with distribution and fulfillment clients across manufacturing, retail, and 3PL, alongside client configuration and operations…
Must-have skills
Picking & PackingPower BIReconciliationSQLTableauWarehouse Management System (WMS)
Work mode
Hybrid

How well do your skills match this job?

Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.

Job description

Location: Bengaluru, India

**General Information:**

**Job Title:** Senior Consultant - Manhattan WMi (iSeries / AS400)

**Primary Job Location**: Hybrid, Bengaluru based, or Remote within India

**Employment Type**: Full-time employment

**Hiring Timeline**: Immediate

**Reporting Line**: Co-Founder, COO & SVP Enterprise Systems

**Application Deadline**: Open until filled

**About Fulfillment IQ (FIQ)**

Fulfillment IQ is a supply chain engineering and transformation company that helps brands, retailers, and 3PLs design, build, and scale high-performance logistics operations.

We work at the intersection of strategy, supply chain, and technology where we solve complex, real-world problems across warehouse design, automation, order management, transportation, and end-to-end supply chain execution.

Our teams combine deep domain expertise with strong technical capability, delivering outcomes through consulting, systems implementation, and proprietary platforms that accelerate time-to-value and reduce delivery risk.

If you enjoy working in complex environments, partnering closely with clients, and seeing your work make a tangible impact on how global commerce moves, this is the place where your skills and judgment truly come to life.

**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.

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 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 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 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 modern 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

**Why You Will Love Working Here**

At 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 standards

**Retirement and Financial Security**

  • Statutory retirement and social security contributions (Employees' Provident Fund, Employees' State Insurance where applicable, and gratuity)
  • Employee stock options (ESOP), where applicable

**Professional 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 offsites

**Work 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.com](https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ffulfillmentiq.com%2F&data=05%7C02%7Csteny.john%40fulfillmentiq.com%7Cd6f9da0357884a75e45a08df3119a055%7C0861cd9f3d1e46c3b68768e9b6ca794e%7C0%7C0%7C639283658298879442%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=wwFfGgT7zsovJtjjN3WqENSwVzD5vdlqhX57CN3Msrc%3D&reserved=0)

**LinkedIn:** [Fulfillment IQ](https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Ffulfillmentiq%2F&data=05%7C02%7Csteny.john%40fulfillmentiq.com%7Cd6f9da0357884a75e45a08df3119a055%7C0861cd9f3d1e46c3b68768e9b6ca794e%7C0%7C0%7C639283658298885596%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=1fsEZ7bVHRJZ8aCnxYLKpkNe0sci9oZ6HVJsgA8Ly70%3D&reserved=0)

**Spotify:** [eCom Logistics Podcast Spotify](https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fopen.spotify.com%2Fshow%2F1IA3mhyXavWviPuQ6fb0Do&data=05%7C02%7Csteny.john%40fulfillmentiq.com%7Cd6f9da0357884a75e45a08df3119a055%7C0861cd9f3d1e46c3b68768e9b6ca794e%7C0%7C0%7C639283658298893144%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=MOJL7%2FvxacoVKPvJ0581WR%2FOCIlTGNwaDAJzfli47Zo%3D&reserved=0)

**YouTube:** [eCom Logistics Podcast YouTube](https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2F%40ecomlogisticspod&data=05%7C02%7Csteny.john%40fulfillmentiq.com%7Cd6f9da0357884a75e45a08df3119a055%7C0861cd9f3d1e46c3b68768e9b6ca794e%7C0%7C0%7C639283658298902230%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=BllfBp%2BHjnTov3GKhrZMVl3f1pW2gz1vh76q3v%2BYf4g%3D&reserved=0)

Job data: Headcount Labs (headcountlabs.com), ODbL 1.0. The job description belongs to the employer. Location data © OpenStreetMap contributors and Overture Maps.

Key skills

Required

Picking & PackingPower BIReconciliationSQLTableauWarehouse Management System (WMS)

Preferred

Microsoft AzurePython

Job market insights

5active Picking & Packing jobs in India
384active Power BI jobs in Bangalore
179active Reconciliation jobs in Bangalore
1 more open job at Fulfillment IQ

Most Consultancy Jobs posts in Bangalore ask for 3–6 years of experience (37% of 81 that say).

Hiring most for Consultancy Jobs in Bangalore

  • WSP9 open jobs
  • Beghou Consulting8 open jobs
  • Blue Yonder7 open jobs

Jobs asking for Picking & Packing in India also ask for

  • SAP60%
  • SQL60%
  • Warehouse Management System (WMS)60%
  • SAP S/4HANA40%
  • SAP SD40%

From live job posts on CoreHRx, updated 12 Nov 2026. Skill figures count posts that list their skills; salary figures only posts that show a salary.

Questions about this job

Where is this job based?

In Bangalore (hybrid).

What kind of job is this?

It is a full time job.

This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.

Questions you may be asked

  1. What is the difference between WHERE and HAVING?
  2. What is the difference between DELETE, TRUNCATE and DROP?
  3. What is the difference between an INNER JOIN and a LEFT JOIN?
  4. What is the difference between a primary key and a unique key?

Get consultancy jobs in Bangalore by email

Create a free profile and we email you new consultancy jobs in Bangalore, at most once a week.

Similar jobs

Free · takes a minute · your resume fills your profile