TechDigital Group
ETL Developer
TechDigital Group - Cary, North Carolina, United States, 27518
Work at TechDigital Group
Overview
- View job
Overview
Job details (8+ Years of Experience)
Knowledge of Azure Data Factory
is a must and good to have knowledge on other tools as well like SSIS, Talend, etc. Good with migration projects on Azure Cloud. Good Experience with Python scripting. Should be able to evaluate and provide the best ETL tool as per data migration requirement. Good experience in migration project using Azure Data Factory from SQL Server, DB2 (LUW or Mainframe), Mainframe database (VSAM, Flat files, DB2) to Oracle (If do not have experience in this, should have experience from any relational source to cloud database using ADF) experience on validating Data migration. Experience in writing Python scripts and Azure DataBricks. Good experience in data extraction (Full data + Incremental data) strategies from source systems. Source systems like relational database SQL Server, DB2, mainframe database VSAM files / flat files / Sequential files. Hands-on experience in implementing bi-directional synchronization and what database configurations need to be done in the database to enable bi-directional sync. Documents all technical and system specifications for all ETL processes and perform unit tests on all processes and prepare required programs and scripts. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
#J-18808-Ljbffr
Knowledge of Azure Data Factory
is a must and good to have knowledge on other tools as well like SSIS, Talend, etc. Good with migration projects on Azure Cloud. Good Experience with Python scripting. Should be able to evaluate and provide the best ETL tool as per data migration requirement. Good experience in migration project using Azure Data Factory from SQL Server, DB2 (LUW or Mainframe), Mainframe database (VSAM, Flat files, DB2) to Oracle (If do not have experience in this, should have experience from any relational source to cloud database using ADF) experience on validating Data migration. Experience in writing Python scripts and Azure DataBricks. Good experience in data extraction (Full data + Incremental data) strategies from source systems. Source systems like relational database SQL Server, DB2, mainframe database VSAM files / flat files / Sequential files. Hands-on experience in implementing bi-directional synchronization and what database configurations need to be done in the database to enable bi-directional sync. Documents all technical and system specifications for all ETL processes and perform unit tests on all processes and prepare required programs and scripts. Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
#J-18808-Ljbffr