Senior Data Ingestion Engineer

Req number:

Employment type:

Worksite flexibility:

CAI is a global services firm with over 9000 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 rightwhatever 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

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 Youll 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 Youll Need

Required:

• Bachelors 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 or (888).