ETL Developer

Job Description: ETL Developer

Responsibilities:• Design, develop, and maintain relational databases for data storage and mining.• Perform data warehouse design and testing, including schema design, architecture, metadata creation, and repositorymanagement.• Design data warehouse schematics, layouts, and capacity planning.• Create and implement effective metrics and monitoring processes.• Develop processes for data entry and ensure reliability and security of information.• Extract data from various sources into staging, perform necessary transformations, and load transformed data intopresentation repositories.• Design and schedule ETL/ELT processes for periodic automated updates using Azure Data Factory.• Write complex stored procedures, efficient SQL queries, and tune for optimal performance.

Requirements:• 2 to 3 years' experience in ETL development and SSIS.• Experience in writing custom C# scripts in SSIS.• Proficiency in Azure Data Factory, Stored Procedures, SQL Server Management Studio, SQL Query Analyzer, and T-SQLProgramming.• Experience with APIs, preferably with OAuth.

Key Skills

• SQL
• C#