ETL DEVELOPER/DATA ENGINEER
Jacksonville, FL, United States
JOB SUMMARY:
This assignment is for an SSIS/Azure developer to support processes related to the data propagation to Azure cloud solutions. This includes development and application maintenance efforts as well as design & delivery of HR Datamarts. The selected resource should be capable of working with complex SQL queries, debugging SSIS packages and code modification as needed. Knowledge of database structures, performance tuning, and data analysis is required.
JOB DUTIES | ESSENTIAL FUNCTIONS:
Design & develop new automated ETL solutions using Microsoft SSIS and Azure data transformation tools
Evaluate, debug, and modify existing complex SSIS packages in accordance with business requirements.
Perform data analysis and test/debug software solutions
nalyze existing ETL jobs, data warehouse applications or work to formulate logic for moderately complex new systems and devise moderately complex algorithms.
Design and extract data from different data sources such as Oracle Fusion ERP Modules, and other SQL Server databases.
pply effective programming security practices.
Practices current development methods/techniques and establishes development standards (which include coding standards, documentation standards, and testing standards) to ensure the quality and maintainability of automated solutions.
Following established change management code migration processes.
SKILLS AND ABILITIES: Experience in data ingestion, data transformation, and data loading
dvanced knowledge of ETL tools such as SSIS, Microsoft SQL Server
Experience in Azure Data platforms such as Azure Databricks, Azure Synapse, Azure Data Factory, ADLS Gen2, etc
Working knowledge of Python, PySpark or equivalent
Experience in HR Datamart design & delivery
Demonstrated broad problem-solving skills, including experience identifying and using code libraries and open-source forums
Good written and verbal communication skills
PRIOR WORK EXPERIENCE: 5 + Years of Data ingestion and transformation experience using SSIS, SSDT
8+ Years ETL experience
2+ Years of experience with Azure Data platforms and Python
Preferred experience working on Oracle Fusion HCM(Cloud) Module
EDUCATION Bachelors degree in computer science, or IT or equivalent
Benefits: Health insurance
401(k)