Senior Data Ingestion Engineer
Req number:
R8847Employment type:
Full timeWorksite flexibility:
RemoteWho 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.
6+ years non-SAP data ingestion experience; Fivetran connectors; cloud-hosted databases (Oracle, DB2, PostgreSQL, Microsoft SQL Server); SaaS and on-premises databases; bachelor's degree preferred; strong communication and accountability.
Key Responsibilities
- designing data pipelines
- building Fivetran connectors
- configuring data loads
Skills & Tools
Fivetran, Oracle, DB2, PostgreSQL, Microsoft SQL Server, MySQL
Job Details
- Category: Software Development
- Seniority: Senior Level
- Commitment: Full Time
- Workplace: Remote — India
- Languages: English
About CAI
A global services firm uniting talent and technology to power the possible for clients, colleagues, and communities. — Industry: Information Technology