Data Architect
- Hiring Organisation
- Zensar Technologies
- Location
- Stratford-Upon-Avon, Warwickshire, West Midlands, United Kingdom
- Employment Type
- Permanent
Triggers Mapping Data Flows/Wrangling Data Flows (where applicable) Integration Runtime strategies (Self-hosted/Azure IR) Implement operational excellence: logging, alerting, retry patterns, failure handling, and idempotent design. SQL Development & Optimization Develop and optimize SQL queries and stored procedures to support ADF pipeline operations and downstream transformations. … Conduct query plan analysis and performance tuning (indexes, partitioning strategies, statistics, query rewrites). Establish SQL coding standards and reusable patterns for transformation logic. Troubleshooting & Analytical Problem Solving Apply a strong analytical mindset to diagnose and resolve complex data integration issues across ingestion, transformation, orchestration, and storage layers. Perform ...