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 TSQL for robust ETL performance.

Troubleshoot existing ETL and database solutions by analyzing TSQL 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 highperformance data integration processes.