Title               : ETL Architect

Location        : Remote

Data Engineering & ETL Development:

• Design, develop, and maintain ETL (Extract, Transform, Load) processes using SQL Server Integration Services (SSIS).

• Build and optimize data pipelines for efficient data extraction, transformation, and loading from various sources.

• Implement incremental and full load ETL strategies to support real-time and batch data processing.

• Ensure data integrity, data quality, and performance optimization across ETL workflows.

Database Development & Optimization:

• Develop and maintain SQL Server databases, stored procedures, functions, and triggers.

• Optimize SQL queries and indexing strategies to improve database performance.

• Implement data partitioning, indexing, and caching strategies for high-performance data processing.

Azure Data Services & Cloud Integration:

• Develop data solutions on Azure, leveraging services such as Azure Data Factory (ADF), Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics.

• Integrate on-premises and cloud-based data sources using Azure Hybrid Data Solutions.