Description

Design, develop, and maintain ETL pipelines, reports, and data integration solutions.

Responsibilities

• Build ETL pipelines using SSIS and Azure Data Factory from heterogeneous data sources.
• Create and modify complex queries, stored procedures, and functions with error handling and performance tuning.
• Automate and monitor production jobs to ensure SLAs are met and rectify issues promptly.
• Perform logical and physical database design following established best practices.
• Collaborate with DBAs and business analysts in an agile environment to implement technical solutions.

Required Skills

• 5+ years of experience programming with PL/SQL.
• 2-3 years of Data Warehousing and ETL experience specifically using SSIS.
• Proficiency in SQL and Unix shell scripting.
• Experience with Oracle Transactional Databases.
• Experience with Azure Synapse Link for SQL Server.
• Hands-on experience with Azure Data Factory, Azure Databricks, and Azure Data Lake.
• Knowledge of Azure Virtual Machines and App Service.
• Bachelor's degree in Information Technology or a related field.

Preferred Skills

• Experience developing with Oracle APEX.
• Experience with Azure Storage services, Azure Active Directory, and Azure Scheduler.

Key Skills

Education

Any Graduate