Data Architect
- Hiring Organisation
- Zensar Technologies
- Location
- Stratford-Upon-Avon, Warwickshire, West Midlands, United Kingdom
- Employment Type
- Permanent
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 root cause analysis (RCA) for pipeline failures, performance degradation, data quality issues, and environment instability. Design proactive monitoring dashboards and alerts for pipeline SLAs and data ...