ESM Architect

HEXAWARE • United States,

3h • Onsite

About The Position

Provide subject-matter expertise for ServiceNow, recovering its true business entities and process flows and delivering reliable, well-governed API-based extraction into the Bronze layer for onward modelling to Gold.

Requirements

• 5+ years with ServiceNow in a data, integration, or platform capacity, with genuine hands-on depth.
• Practical experience with the ServiceNow Table and REST APIs, including rate-limit management.
• Demonstrated ability to design reliable incremental extraction from SaaS platforms into a data lake or warehouse.
• Strong SQL and data-profiling skills; ability to reverse-engineer heavily customized SaaS configurations.
• Understanding of ITSM/CMDB practice.

Nice To Haves

• ServiceNow platform certifications.
• Experience with Fabric, Databricks, Azure Data Factory or comparable ingestion tooling.
• CMDB governance or CI data-quality remediation experience.
• Familiarity with Microsoft Purview or comparable catalog tooling.

Responsibilities

• Document the ServiceNow data model (CMDB, incident, change, request, task, CI relationships) as configured at Client Side.
• Reconstruct the underlying business processes — ITSM/ITIL flows in ServiceNow — and document where customization has altered standard behavior.
• Design and specify API-based extraction patterns, addressing incremental/CDC extraction, pagination, rate and API limits, bulk interfaces, authentication, and deleted-record handling.
• Produce Bronze → Silver → Gold source-to-target mappings, including picklist and reference-data normalization and documented data-quality defects.
• Define ServiceNow's contribution to DNA crosswalk keys (Customer/Account, Site, Asset/CI, Employee) and resolve identifier conflicts across systems.
• Define data-quality gates and confidence scoring for service-management KPIs and steward them through certification.
• Support pipeline development, observability, and automated testing for the ServiceNow source system.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed