Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Integration Monitoring ETL Engineer
(Jobs in Raritan, NJ)
 
Requirement id 114868
Job title Engineer
Job location in Raritan, NJ
Skills required Integration, SQL, Monitoring, ETL
Open Date 09-Mar-2021
Close Date
Job type Contract
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Engineer: Integration, SQL, Monitoring, ETL

Candidate must be our W2 Employee.

Job Description:

The Data Engineer Uses Celonis To:

Responsibilities:

• Map business goals with data

• Work with the business to understand what data they need to analyze their process.

• Write SQL / ML code to connect a process to Celonis

• Configure data jobs, loads and data models

• Validate data

The Data Engineer Tasks Include

• Change Request handling (e.g. scoping)

• Integration of new tables

• SQL adaption / transformation customization

• Configuration of the complete event collection

• Adaption of technical analysis features

• Connecting and creating new processes / data models

• Monitoring

Change Request Handling

Scoping of the new requirement (user story) with the according success criteria and coming up with a solution and an estimation on how to solve it and how much time it is going to take

Change Request Can Be

• Additional meta-data

• Further activities

• Change in activity logics

• New data models / processes

• New systems



Integration Of New Data - Tables

• Getting information on the table names, description and name mapping from the source system

• Adapt the current data extractions with the table to be added as well as correct filtering over global Datapool-Parameters

• Create a new view that than can be integrated into the data model with the correct join definition predefined in the SQL code to keep out unnecessary data out of the front end

• Add the table to the data model and trigger a new load



SQL Adaption / Transformation Customization / Activity Creation

• Understand the current SQL logic to derive how the activity is created

• Gather source system knowledge to derive the new SQL logic

• Create / Adapt the activity and integrate it into the according event log and transformation logic



Configuration Of The Complete Event Collection



Configuration of a the small pieces in the event collection to ensure a smooth running, e.g.:

• Schedulers (Transformations, Extractions, ML Workbench)

• Data Pool Parameters (Start Dates, Document Types, etc.)

• Data Connections

• Data Pools

• Integration Servers

• Data Model Loads

• Delta Loads

Connecting And Creating New Processes / Data Models

• Scoping of the new project and estimation of a technical implementation timeline

• Derive technical requirements from the business requirements given

• Steering the technical integration of the project

• Creation of a new data model

• Integration of all events together with their SQL logic

• Build up of the data model with all joins and necessary data



Monitoring



Supervision of all business critical Celonis parts, e.g.:

• Scheduler Executions (Delta Loads, Full Loads, Extractions, Machine Learning Workbench)

• Data Model Loads

• Overall System Health

• APC-Consumption

• License Consumption (Business Users, Analysts)

Most of these points can be partially automated via notifications and have to be done on a daily basis.

Recommended Know-How

• Know-how of data structures

• Vertica SQL skills

• Experience with ETL processes

• IT-affinity



Celonis Applications

• Process Analytics

• Event Collection

• App Store

• Process Automation

• Action Engine

• Machine Learning Work
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 114868 while calling.
 
Other jobs in NJ: Edison (2), Englewood Cliffs (1), Ewing (2), Franklin Lakes (7), Hamilton (3), Hightstown (7), Hopewell (2), Jersey City (3), Little Falls (1), Maplewood (1), Mercer County (3), Mount Laurel (11), Mt Laurel (4), New Brunswick (1), Newark (1), Princeton (4), Somerset (9), Trenton (123), Unknown (2), Warren (7), Wayne (1),
 
 Integration job openings in other states
Jobs List

VDOT Solutions Architect (743290)
Create date: 31-Jul-2024
No of Submissions : 2

Start date : 07/29/2024

End Date :07/31/2025

Submission deadline : 08/09/2024

Client Info : VDOT

Note:

* Both Web Cam and In Person Interview

* Hybrid

* local candidates strongly preferred

* candidate must be able to come to Rich.... (This job is for - Design Integration Azure Jobs in VA Richmond Architect - (in Richmond, VA))

GA DHS - Sr. Cloud Application (729257)
Create date: 09-Feb-2024
Job Title: GA DHS - Sr. Cloud Application/Boomi Integration Specialist (729257)

Hybrid

start date :04/01/2024

End date :06/30/2025

submission deadline :02/16/2024

client info :DHS

Description :

Must be local to Metro Atlanta.... (This job is for - Integration Jobs in GA Atlanta Specialist - (in Atlanta, GA))

VDOT Solutions Architect 2 ROLES (723714)
Create date: 10-Nov-2023
Hybrid

Start date :11/27/2023

End date :06/30/2024

Submission deadline :11/15/2023

Client info :VDOT

Description :

**local candidates strongly preferred
**candidate must be able to come to Richmond, VA to pick up laptop
*the .... (This job is for - Integration Jobs in VA Richmond Architect - (in Richmond, VA))

Cloud Architect - 119546 - SP
Create date: 28-Jun-2023
start date : 7/17/2023

End date : 1 Years from projected start date

submission deadline : 7/5/2023 at 10am EST

client info : PDSS

Note :

* This is a FULLY REMOTE position

* Local or non-local may apply

* Will close submissions on: 7/5/2023 at 10am EST

* Inte.... (This job is for - Integration DevOps Jobs in MI Lansing Architect - (in Lansing, MI))

Risk Management - 115082 - SP
Create date: 10-Mar-2023
start date:4/1/2023
End date:03/31/2024

submission deadline:3/15/2023 3:00:00 PM

client info : MDCPS

Note:

* Required to be onsite in MS one full week per month

Description:

we are seeking an experienced professional with a broad understanding of solutions, industry best .... (This job is for - Integration Jobs in MS Jackson Manager - (in Jackson, MS))
 
 Integration job openings in NJ
Jobs List

PeopleSoft HR TechnoFunctional - 72975
Create date: 15-Mar-2021
Job Description:

Candidates are required to be onsite when it is safe to do so. The rate in iLabor is before travel expenses. Candidates that can relocate without expense will be prioritized.
PeopleSoft TechnoFunctional experience in HCM module
Mostly Functional
Core HR Benefits, Benefits Admin, T&L
Mostly delivery, b.... (This job is for - HCM Integration Development Jobs in NJ JerseyCity Consultant - (in Jersey City, NJ))

NJTA Senior Consultant (615819)
Create date: 16-Jan-2020
Start Date :02/03/2020
End Date :06/30/2020
Submission Deadline :1/22/2020

Client Info :Turnpike Authority

Description :

The Client is seeking a Jira SME to function as the resident expert in Jira modules integration.

This contractor should function as a Jir.... (This job is for - Migration Integration Jobs in NJ Woodbridge Consultant - (in WOODBRIDGE, NJ))

Enterprise Package Solutions Specialist II - J-11-063-634
Create date: 02-Nov-2015
NOTE :
Start Date : 10/30/2015
End Date : 04/30/2016
Submission Deadline : 11/06/2015

Client Info : COMSYS

Description:
Position: Prd Mgt - Enterprise Package Solutions Specialist II
Position Code: Enterprise Package Solutions Specialist II
Qty: 1 !
Required Date:.... (This job is for - Integration Administrating Database Admin Jobs in NJ TOWNCENTER Specialist - (in TOWN CENTER, NJ))
(Engineer: Integration, SQL, Monitoring, ETL in Raritan, NJ)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us