onsite
Azure Data Engineer - TEKsystems
Data Engineer
Design and optimize enterprise data pipelines on Azure, modernizing Oracle EBS data into scalable, near‑real‑time datasets using Azure Data Factory, Synapse, and advanced SQL/Python techniques.
About the role
Key Responsibilities
- Design, develop, and maintain end‑to‑end data pipelines that ingest, transform, and load data from Oracle EBS and other source systems into Azure platforms.
- Implement incremental load and UPSERT patterns to provide near real‑time data availability for analytics and reporting.
- Build and optimize data models and warehouses in Azure Synapse Analytics, ensuring performance, scalability, and data quality.
- Write complex SQL queries and stored procedures for data cleansing, enrichment, and validation.
- Collaborate with data scientists, business analysts, and stakeholders to translate business requirements into technical solutions.
- Automate monitoring, logging, and error‑handling processes using Azure Data Factory and Python scripts.
Requirements
- 5+ years of experience in data engineering, with a strong focus on Azure data services.
- Deep expertise in Azure Data Factory, Azure Synapse Analytics, and SQL development.
- Hands‑on experience modernizing data from Oracle EBS or similar ERP systems.
- Proficiency in data modeling concepts and best practices for relational and analytical workloads.
- Solid programming skills in Python for automation and data manipulation.