Applying here? Try the free cover letter tool — paste this posting and your résumé, no account needed.
About the role
Design, develop, and support enterprise-scale data ingestion pipelines using Fivetran across various source systems. Implement secure connectivity and manage complex data replication patterns including CDC and incremental loads.
What they look for
Requirements
Requires over 6 years of experience in non-SAP data ingestion and hands-on expertise with Fivetran connectors. Candidates should have a strong background in cloud-hosted databases, SaaS applications, and relational database management.
Full description
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.
