ETL Developer

‑Design and implement enterprise ETL solutions with replication or CDC in clustered SQL environments.

‑Architect and develop database solutions with both normalized and star (Kimball) schemas for data warehousing.

‑Demonstrate expert knowledge of advanced database design, indexing, constraints, and T‑SQL for robust ETL performance.

‑Troubleshoot existing ETL and database solutions by analyzing T‑SQL execution plans, SSIS pipeline execution plans, and DMV performance results.

‑Optimize physical databases and data warehouses through indexing, constraints, partitions, and clustering adjustments.

‑Tune ETL SSIS solutions using pipeline plans, memory buffers, control/data flow adjustments, and other performance enhancements.

‑Collaborate with stakeholders to ensure scalable and high‑performance data integration processes.