SQL Data Warehouse Developer

SQL data warehouse Developer

Uni Tencys Systems Private Limited IN

Experience Required: 2-4 years

Location: Remote / Bharuch

Employment Type: Full-time

Job Summary

We are seeking an SQL Data Warehouse Developer to design, develop, and manage SQL-based data warehouse solutions. This role involves automating data extraction, transformation, and loading processes, optimizing database performance, and ensuring data security protocols. The developer will also schedule and monitor ETL workflows, contributing to reliable and efficient data pipelines.

Key Responsibilities

• Design and manage SQL-based data warehouse solutions.
• Automate FTP data extraction, transformation, and loading processes into SQL tables.
• Develop and maintain scripts for data integration and automation using Python or PowerShell.
• Optimize database performance and maintain data security protocols.
• Schedule and monitor ETL workflows to ensure the reliability of data pipelines.

Basic Requirements

• Strong expertise in SQL and database management.
• Proficiency with ETL tools such as SSIS.
• Scripting and automation capabilities (Python, PowerShell) for FTP file handling and task automation.
• Experience with task scheduling tools (SQL Server Agent, cron jobs).
• Knowledge of secure file transfers (SFTP/FTPS).

Preferred Attributes

• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work independently in a remote environment.