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.