Tagcor

ETL Developer

• 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

• Analyze 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.

• Apply 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

• Advanced 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

• Bachelor’s degree in computer science, or IT or equivalent