Tech Mahindra (Americas) Inc.

Compensation

Full Description

Data Analyst - Senior Top responsibilities • Write complex SQL queries to pull data and analyze results. (DoD App Retirement specific) • Find cases and investigate root causes when one record from data source maps to multiple records in ServiceNow and vice-versa. • Profile legacy sources: schema/PK-FK, volumes/frequency, lineage, owners, and data issues. • Map to CMDB/CSDM: place entities into correct CI classes/relationships; align lifecycle and environments. • Define identity and reconciliation: coalesce keys, dedupe/survivorship, reference resolution. • Design ingestion: Import Sets/Transform Maps, IntegrationHub ETL, MID/JDBC/API, idempotent schedules. • Drive data quality: DQ rules/KPIs, CMDB Health monitoring, remediation workflow. • Govern and document: RACI, data contracts, naming/taxonomy, domain separation/ACLs, attestations. • Validate and sign off: test cases, reconciliation counts, negative tests, rollback plan; facilitate stakeholder decisions. Top skills • ServiceNow CMDB/CSDM • CSDM modeling; core CMDB tables/relationships. • Identification & Reconciliation, CMDB Health; Import Sets/Transform Maps/Coalesce; IntegrationHub ETL/Flow Designer • Data • SQL; profiling and normalization; reference data management. • ETL/ELT patterns, idempotency, dedupe/survivorship; JSON/CSV/XML; REST familiarity. • Domain • Infra (servers/VMs/containers/network/storage); cloud resource models and tagging. • Application vs service modeling and dependencies. • Governance • Naming/taxonomy; DQ KPIs; ownership/stewardship; audit/change controls; privacy basics (PII/SOX/PCI). • Soft skills • Stakeholder interviewing/facilitation; concise documentation/visuals; analytical, hypothesis-driven thinking. Nice-to-haves BI dashboards (Power BI), telecom/OSS/BSS familiarity