1. How do you design a scalable product hierarchy that supports multiple classification systems (GS1, internal taxonomy, marketplace taxonomy)?

Answer:
Create a multi-hierarchy architecture using separate classification entities.
Use reference entities for external taxonomies and link through relationships like MappedToCategory.
Keep internal hierarchy as the master and external mappings as federated structures.
Avoid attribute duplication; use inheritance for common attributes.

2. How do you handle schema evolution when attributes change monthly without downtime?

Answer:
Use STEP’s dynamic schema capabilities:

• Implement attribute groups to isolate changes.

• Deploy configuration packages through controlled promotion.

• Create backward-compatible changes by keeping old attributes in read-only mode until deprecation.

3. You have 30 million SKUs. Performance is slow. How do you diagnose bottlenecks?

Answer:
Check the following in sequence:

1. Indexing delays (Lucene/Solr).

2. Workflow queue congestion.

3. Import pipeline thread limits.

4. Database-level table scans.

5. Match rule expensive joins.

6. Large relationship traversals.

Run system diagnostics and enable STEP performance logs for deep inspection.

4. How do you design multi-language support for 25 languages?

Answer:

• Enable STEP locale attributes.

• Use language-specific enrichment workflows.

• Maintain fallback logic (Default → English → Local).

• Separate translation-ready attributes in a dedicated group.

• Integrate translation API via REST Calls.

5. How do you ensure product variants (size, color, style) are modeled efficiently?

Answer:
Use a parent–child model:

• Parent = Style or Base product

• Child = SKU

• Define variation dimensions (Size, Color) using attribute sets

• Store shared attributes at parent level

• Override at child level only when necessary

6. A supplier updates 2 million records nightly. How do you design incremental updates?

Answer:

• Use delta feeds based on timestamps.

• Use BIS with Change Sets.

• Avoid full import.

• Apply partial update workflows.

• Enable CSN-based outbound publishing.

7. How do you design a governance workflow that requires 5 levels of approval?

Answer:

• Create modular workflow stages.

• Use conditional branching based on business rules.

• Implement role-based approval steps.

• Add SLA timers for escalations.

• Store approval history in workflow variables.

8. How do you resolve conflicts when two authoritative sources provide contradictory data?

Answer:
Implement source survivorship:

• Assign priority tiers.

• Use attribute-level source precedence.

• When priorities tie, use validation rules or timestamp-based logic.

• Push exceptions to Steward queues.

9. How do you design a relationship model to support “compatible products”?

Answer:
Use a symmetric relationship:

• Relation type: CompatibleWith

• Enforce no cycles

• Allow bidirectional lookup

• Store compatibility attributes (voltage, size, model year)

10. How do you create a completeness score that changes by category?

Answer:

• Configure completeness rules per category.

• Assign mandatory attributes at category level.

• Use rule sets for dynamic scoring.

• Compute score automatically during workflow transitions.

11. How do you integrate STEP with SAP, Salesforce, and AEM?

Answer:

• Use REST APIs for Salesforce

• Use IDoc/BAPI for SAP via middleware

• Use AEM importer with STEP outbound publishing

• Queue outbound data and use retry handlers

12. How do you design an audit mechanism for attribute changes?

Answer:
Enable attribute-level versioning and maintain:

• Old value

• New value

• User

• Timestamp

• Workflow state

Expose audit trail through custom UI or API endpoint.

13. How do you model a Supplier–Product–Location relationship?

Answer:
Use a 3-level structure:

• Supplier (Master)

• Product (Master)

• Location (Reference entity or domain)

Relationship type: SupplierProvidesProductAtLocation.

14. How do you design high-availability architecture for STEP?

Answer:

• Use clustered application servers

• Use external search cluster

• Configure load balancers

• Enable DB replication

• Isolate BIS nodes for heavy pipelines

15. You need to support 3 different publication schedules. How do you handle this?

Answer:
Create separate Outbound Channels:

• Real-time

• Near-real-time

• Batch

Use event triggers + scheduler + queue management.

16. How do you handle attribute overrides by region?

Answer:
Use:

• Localized attributes

• Region-specific attribute groups

• Region inheritance rules

• Workflow branches for region-based enrichment

17. How do you design image and digital asset management in STEP?

Answer:

• Use Media Manager

• Store high-res master + derivatives

• Auto-generate renditions

• Link assets via relationships to products

• Validate image specs using rules

18. How do you prevent data stewards from bypassing workflows?

Answer:

• Restrict direct editing rights

• Use workflow-only attribute editing

• Enforce state transitions

• Monitor via audit logs

19. How do you optimize search performance for 50M records?

Answer:

• Add custom indexes

• Reduce indexing delay intervals

• Disable unnecessary wildcard or fuzzy search

• Use faceted navigation

• Allocate dedicated search nodes

20. How do you design a change request (CR) module inside STEP?

Answer:

• Model CR as separate entity

• Link CR to the product

• Manage through custom workflow

• Provide UI validation screens

• Auto-update master after approval

21. How do you manage PII inside STEP?

Answer:

• Store PII in encrypted attributes

• Restrict access via roles

• Use masking for non-admin users

• Maintain audit logs for every read/write action

22. How do you detect duplicate suppliers?

Answer:

• Use fuzzy matching rules

• Token-based similarity

• Address standardization

• Human review queue for low-confidence matches

23. How do you model bundles or kits?

Answer:
Use a composite entity:

• Bundle/Kit (Parent entity)

• BundleItem relationship with quantity

• Publish flat BOM structure

24. How do you automate seasonal attribute changes?

Answer:
Configure a scheduled job to:

• Update attributes

• Activate/deactivate categories

• Trigger seasonal workflows

25. How do you handle slow-running workflows?

Answer:

• Use asynchronous jobs

• Split heavy workflows

• Reduce transitions

• Increase parallel workflow threads

• Optimize rule execution frequency

26. How do you build a multi-level approval process for price changes?

Answer:

• Price group attributes

• Tiered approval rules

• Dynamic workflow branching

• Risk scoring (high/medium/low)

27. How do you design vendor onboarding inside STEP?

Answer:

• Create Supplier entity

• Use onboarding wizard

• Validate mandatory docs

• Route through approval workflow

• Push to ERP post-approval

28. How do you manage conflicting updates from 10 external feeds?

Answer:

• Define source priority

• Time-stamped source freshness rules

• Source-specific validation

• Feed sequencing

• Exception queues

29. How do you handle relationship explosions? (e.g., 10M cross-sell links)

Answer:

• Use lazy loading

• Apply pagination

• Cache most-used cross-sell associations

• Reduce traversal depth

• Split relationships in multiple sub-types

30. How do you design a publishing rule for only changed items?

Answer:
Use Change Sets & CSN-based delta detection:

• If CSN > last exported CSN → publish

• Maintain per-channel watermark

31. How do you design multi-country publishing?

Answer:

• Use localized attribute groups

• Region-based inheritance

• Country-specific workflow steps

• Channel-specific export templates

32. How do you enforce content validations before catalog publishing?

Answer:

• Use mandatory attribute rules

• Cross-field validation (e.g., Height ≥ Width)

• Category-level rule sets

• Block workflow transition if rules fail

33. How do you design a retry mechanism for failed outbound publishing?

Answer:

• Implement retry queue

• Capture error logs

• Allow configurable retry intervals

• Manual push option in UI

34. How do you automate image tagging?

Answer:

• Use AI/ML service external to STEP

• POST image link via API

• Receive tags and update attributes

• Validated by analyst workflow

35. How do you design enrichment tasks for multiple departments?

Answer:

• Create task entities

• Assign to teams via workflow

• Use SLA reminders

• Combine tasks into enrichment queues

36. How do you support custom UI dashboards?

Answer:

• Build custom UI via STEP UI Configurator

• Use widget-based design

• Integrate search, tasks, KPIs

37. How do you enforce category-specific attribute rules?

Answer:

• Attribute cardinality constraints

• Category attribute templates

• Dynamic rule triggers

• Completeness scoring per category

38. How do you design API governance?

Answer:

• Authentication tokens

• Rate limiting

• API versioning

• Attribute-level access control

• Monitoring via API logs

39. How do you validate external marketplace attributes (Amazon, Walmart)?

Answer:

• Map attributes to internal master

• Apply marketplace-specific rules

• Validate dimensions/weights

• Create error queues

40. How do you handle bulk attribute updates for promotions?

Answer:

• Use business rules to compute values

• Run mass update job

• Use limited publishing

• Version updates for rollback

41. How do you detect missing media assets?

Answer:

• Rule: If Category = “Fashion” → Image mandatory

• Auto-check during workflow transition

• Add missing-image task to queue

42. How do you optimize large BIS imports?

Answer:

• Use incremental import

• Use staging tables

• Disable expensive rules temporarily

• Apply multi-threading

• Validate only delta data

43. How do you implement an approval hierarchy that changes by category?

Answer:

• Dynamic workflow branching

• Category-specific approval groups

• Rule-based routing logic

44. How do you design a performant working copy / sandbox mechanism?

Answer:

• Create working-copy entities

• Link with original entities

• Merge changes after approval

• Track deltas

45. How do you keep STEP responsive when running heavy batch jobs?

Answer:

• Use separate BIS node

• Schedule batch jobs at night

• Use load balancer

• Limit workflow triggers during imports

46. How do you integrate AI-based enrichment?

Answer:

• Submit data to ML via REST

• Receive enriched values

• Validate using rules

• Pass enriched entity to workflow

47. How do you handle product lifecycle states?

Answer:

• Define lifecycle states (Draft → Ready → Active → Retired)

• Enforce state transitions

• Restrict editing in specific states

• Trigger channel publishing on state change

48. How do you detect anomalies in product data?

Answer:

• Attribute value distribution analysis

• Outlier detection using ML

• Validation rules based on thresholds

• Manual review queue

49. How do you split a large master data domain across multiple STEP instances?

Answer:

• Use domain segmentation

• Implement reference sync

• Master domain = Product

• Satellite domain = Supplier, Location

• Sync via APIs or BIS

50. How do you design global + regional + local governance in one model?

Answer:

• Define three inheritance layers

• Global template

• Regional overrides

• Local enrichment

• Merge attributes using layered survivorship