TEKsystems | Oracle PL/SQL Data Engineer (Gunjan Sheth) | Franklin, TN | United States | BigDataKB.com | 11/12/2022

Before u proceed below to check the jobs/CVs, please select your favorite job categories, whose top job alerts you want in your email & Subscribe to our Email Job Alert Service For FREE


Job Location: Franklin, TN

Equivalent Experience


Optum is modernizing a legacy payment integrity application and moving it to a cloud based, big data architecture. Optum also acquired a company (Equian) that has a competing product that they plan on integrating into the new system. The legacy application is an Oracle based solution that leveraged ODI for integration and ETL. The new system will be written in Python on the cloud and use a workflow integration tool from Apache called Airflow. The engineer will be part of a 8 person team that will be building an adapter to integrate the Equian systems into the legacy Optum solution.

BigDataKB.com Jyotish
BigDataKB.com Jyotish - Career & Life Prediction

The group is on a devops journey and the engineer should have experience in CI/CD (tool agnostic) along with experience with software automation efforts in workflow processes, build/deploy and integration processes. There is a big effort to automate various functions and tasks in this effort and the right candidate should be able to articulate how they’ve automated functions on a similar project.

The Data Engineers will work intensively in Oracle PL/SQL. Prior ETL experience is preferred. That said, I am looking for engineering and dev-ops minded people with such experience. By that I mean folks who are used to working with Git repositories and CI/CD pipelines and automating things through code. I need folks who know how to work smarter not harder. They will be working on a legacy stack but I don’t want legacy mindset. We will be migrating this to the cloud (likely Azure) so any cloud experience would be preferred.


Python, ETL, PL/SQL, CI/CD, Automation, devops, Sql

Top Skills Details:


Additional Skills & Qualifications:

Needs to have a modern software engineering mindset who can look for ways to automate data functions.

Screening tips

I would like to highlight a few things in bold here to be sure we are not having a lot of early rejections. I don’t mean to be repetitive but these are important call outs.

It is essential that candidates presented…

  • Possess deep, not cursory, understanding of SQL, PL/SQL, and ETL processes. We do screen with probing questions about these topics and we will know right away if the person is a “tool user” versus in the weeds and understands nuanced approaches and can speak intelligently about using one approach versus the other and why and how it impacts the database, etc.
  • Have significant practical experience managing SQL, PL/SQL, and ETL processes with modern source management systems (Git in particular). We will again ask questions in this area and it will be readily apparent if the candidate does not know their way around Git and how code is effectively managed in such systems.
  • Can speak to situations in which they have demonstrated proactive stance to reducing manual work through automation
  • Are ok with joining a 24×7 support rotation schedule.

About TEKsystems:

We’re partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That’s the power of true partnership. TEKsystems is an Allegis Group company.

The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

Apply Here

Submit CV To All Data Science Job Consultants Across United States For Free


Please enter your comment!
Please enter your name here