Azure Data Engineering
Design, develop, and maintain scalable Azure-based data pipelines using Azure Data Factory.
Build reusable and parameterized ADF pipelines, datasets, linked services, triggers, and orchestration frameworks.
Implement batch ETL/ELT workflows for large-volume enterprise datasets.
Develop ingestion pipelines from multiple sources including SFTP, SharePoint, APIs, and enterprise applications.
Implement pipeline monitoring, error handling, retry mechanisms, and alerting.
Ensure data pipelines meet defined performance and SLA requirements.
Azure Data Lake Storage
Design and manage data storage structures using ADLS Gen2.
Implement scalable storage strategies for enterprise data platforms.
Organize data according to Bronze/Silver/Gold layers.
Optimize file formats and storage layouts for analytical workloads.
Support secure data movement between Azure services and external systems.
SQL & Data Engineering
Develop complex SQL and T-SQL queries for data extraction and transformation.
Develop and optimize stored procedures and database objects.
Perform data validation, reconciliation, and quality checks.
Troubleshoot query and pipeline performance issues.
Optimize SQL queries and data processing logic for high-volume workloads.
Enterprise Integration
Design and develop enterprise integrations using Dell Boomi and Azure integration services.
Develop reusable integration components and centralized error-handling frameworks.
Integrate systems through APIs, SFTP, SharePoint, and enterprise applications.
Develop secure SFTP-based integrations using PGP encryption/decryption.
Work with SAP SuccessFactors and downstream provider integrations.
Handle employee lifecycle and other business-critical integration scenarios.
Azure Logic Apps
Develop and maintain Azure Logic Apps workflows.
Automate data ingestion and business workflows involving Email, SharePoint, ADLS, and SFTP.
Implement event-driven and workflow-based automation.
Configure notifications and alerts for pipeline and business-process failures.
Mandatory Skillset
The following skills should be considered mandatory for this role: