Syntricate Technologies
ETL Developer
Syntricate Technologies, Cary, North Carolina, United States, 27518
Number of positions: 11Only fulltime no C2C
Job Title:
ETL Develope
r (Synapse, ADL, SSIS)Location: Cary, NC (Day 1 Onsite)
Required skill:• Experience in implementing the data solutions on MS Azure using Azure Data Factory, Synapse or Azure SQL Data Warehouse• Prior Experience on any of the ETL Technologies like Informatica Power Centre, SSIS• Experience with systems like a relational database SQL Server, DB2 , mainframe database, VSAM files, flat files, Sequential files• Good experience in data extraction ( Full data + Incremental data) strategies from source systems• In-depth understanding of various storage services offered by Azure• Experience with data process Orchestration, end-to-end design and build process of Near-Real Time and Batch Data Pipelines• Working experience with Azure monitor and Azure log Analytics• Strong client-facing communication skills• Experience with agile methodologies• Hands on Experience in using Azure devops.• nalyze current code in informatica, SQL, unix scripts.• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities• Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes• ble to mentor and guide offshore resources ( Not required for Offshore resources)
Job Title:
ETL Develope
r (Synapse, ADL, SSIS)Location: Cary, NC (Day 1 Onsite)
Required skill:• Experience in implementing the data solutions on MS Azure using Azure Data Factory, Synapse or Azure SQL Data Warehouse• Prior Experience on any of the ETL Technologies like Informatica Power Centre, SSIS• Experience with systems like a relational database SQL Server, DB2 , mainframe database, VSAM files, flat files, Sequential files• Good experience in data extraction ( Full data + Incremental data) strategies from source systems• In-depth understanding of various storage services offered by Azure• Experience with data process Orchestration, end-to-end design and build process of Near-Real Time and Batch Data Pipelines• Working experience with Azure monitor and Azure log Analytics• Strong client-facing communication skills• Experience with agile methodologies• Hands on Experience in using Azure devops.• nalyze current code in informatica, SQL, unix scripts.• Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities• Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes• ble to mentor and guide offshore resources ( Not required for Offshore resources)