- Location
- Bengaluru, India
- Department
- Transportation
- Source
- Keka
Description
Job Title: Senior Data Architect
About Hashout Technologies
Hashout Technologies is a client-centric digital transformation partner specializing in Adobe Experience Manager (AEM) and the broader Adobe Experience Cloud ecosystem, including personalization, data/CDP, journey orchestration, and campaign management.
We deliver highly customizable, outcome-driven MarTech solutions, leveraging our expertise across leading CMS platforms to build tailored digital experiences that align with our clients’ needs and drive measurable business growth.
Position Details
- Role: Data Architect
- Experience Required: 5+
Role Overview
This role requires deep data expertise that goes beyond tool familiarity. The ideal candidate will have worked close to the data layer, modelling it, mapping it, and querying it at scale across complex enterprise environments.
Relevant Backgrounds
Candidates may come from any of the following areas:
- Cloud Data Warehouses such as BigQuery, Snowflake, Redshift, or Synapse, with experience modelling and querying large, complex datasets.
- Marketing Tech or Campaign Platforms, with ownership of source to target mapping, metadata mapping, and data dictionaries (not campaign execution).
- MDM Platforms, with hands on work in master data, entity resolution, and identity stitching.
Key Responsibilities
- Understand source systems and map them to AEP XDM Schemas using L
LDM methodology.
- Work with structured and semi structured data formats across diverse pipelines.
- Define entity relationships, cardinalities, and ER diagrams.
- Write and optimise SQL at source and within AEP Query Service, including
joins, filters, and aggregations.
- Own source to target mapping, metadata documentation, and schema
governance.
Required Skills and Experience
- Strong data modelling fundamentals covering relationships, keys, and
cardinalities.
- Hands on SQL experience across source systems and large-scale query engines.
- Experience producing data dictionaries and source to target mapping documents.
- Ability to independently map a source system to a target schema.
Skills
SQLSnowflakeBigQuery