Senior Data Ingestion Engineer

Senior Data Ingestion Engineer

Req number:
R8847

Employment type:
Full time

Worksite flexibility:
Remote
##

Who we are

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

Job Summary
We are looking for a motivated Senior Data Ingestion Engineer ready to take us to the next level! If you have strong experience in designing, building, and supporting enterprise-scale data ingestion solutions across non-SAP, SAP, on-premises, SaaS, and cloud-based source systems, and are looking for your next career move, apply now.

Job Description

We are seeking an experienced Senior Data Ingestion Engineer with strong hands-on expertise in designing, building, and supporting enterprise-scale data ingestion solutions across non-SAP, SAP, on-premises, SaaS, and cloud-based source systems. This position will be full-time and remote

What You’ll Do

- Design, develop, configure, and support enterprise data ingestion pipelines using Fivetran
- Build Fivetran connectors for heterogeneous source systems, with particular emphasis on: Oracle | DB2 | Microsoft SQL Server | MySQL | PostgreSQL and other relational databases | SaaS applications | On-premises databases Cloud-hosted databases and applications
- Configure and manage initial/full loads, incremental loads, and Change Data Capture (CDC) ingestion patterns
- Understand and implement Oracle-based CDC and incremental replication patterns using Fivetran
- Configure secure connectivity between Fivetran and enterprise on premises/cloud source systems
- Design ingestion solutions considering source-system impact, scalability, throughput, latency, security, reliability, and cost

What You'll Need

Required:

- Bachelor's degree in computer science, Information Systems, or other related discipline preferred; or equivalent combination of education and experience
- Must have Non-SAP Data ingestion experience with 6 plus years
- Good Experience in Fivetran connectors
- Must have experience in cloud hosted databased and applications such as Oracle, DB2, PostgreSQL, Microsoft SQL Server and relational databases
- Working experience in SaaS application and On- Premises databases
- Good communication skills
- The candidate should have the learning attitude with accountability for the assigned tasks

Physical Demands

- Ability to safely and successfully perform the essential job functions
- Sedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.
- Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.