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 application.accommodations@cai.io or (888) 824 – 8111.