SQL Server ETL Engineer (T-SQL / SSIS) – Intermediate
- Location
- Norwich, England, United Kingdom
multiple research databases. Write historic correction scripts to fix data anomalies across large datasets. Implement validation and consistency checks during data ingestion and transformation. Performance & Database Engineering Optimise ETL queries and batch processes running against very large tables (billions of rows). Analyse and tune query execution plans, indexing … strategies, and partitioned tables. Improve performance of data loads and batch ETL processing. Operational Database Work Support operational SQL Server tasks including: Integrity checks Troubleshooting failed imports Manage file‐based data ingestion, including large CSV imports and server directory management. Maintain and improve SSIS packages and SQL‐driven import ...