Return To Job Search

Ingestion Engineer - Lead
Cincinnati Metro Area
Developer: Web
JN -092019-21853

Position: Ingestion Engineer - Lead
Number of Openings: 2 positions
Start Date: ASAP
Job location: Cincinnati

About Cohesion
Cohesion is a leading IT staffing firm that empowers people and companies to thrive. We specialize in finding, retaining, and developing top IT talent for our clients. Cohesion’s has helped business leaders add value, drive growth, and achieve competitive advantage in the marketplace. Learn more at 

Position: Ingestion Engineer - Lead


Must Have
Apache, Code, Data Modeling, Design, ETL Concepts, Java, Kafka, Spring Framework, SQL, Testing

Nice To Have
Bachelor’s degree (Computer Science, Computer Engineering, Information Systems, Business Analytics, or another technically strong program), plus 3 - 5 years of related experience, Database Technology (DB2, Oracle, SQL Server, Postgres), DataStage, Informatica, Talend


The Lead Ingestion Engineer is responsible for the comprehensive development of software components that move data between software systems, including design, testing, maintenance, and documentation. The Ingestion Engineer will plan and coordinate deliverables for the Enterprise Data Organization within an Agile squad, while continuously improving the software delivery processes and ETL/Data movement practices.


  1. Design, code, test, and document mappings/transformations of load routines to data repositories
  2. Troubleshoot and problem solve to ensure data integrity
  3. Maintain system documentation (data dictionary, job flows, job dependencies)
  4. Provide input on physical database design decisions
  5. Communicate effectively with business partners
  6. Collaborate, and deliver results, within cross-functional agile team
  7. Mentor junior resources, and share technical knowledge with teammates
  8. May provide escalation support if necessary

  1. Bachelor’s degree (Computer Science, Computer Engineering, Information Systems, Business Analytics, or another technically strong program), plus 3 - 5 years of related experience.
  2. General knowledge of Extract, Transform, and Load (ETL) concepts, and working knowledge of 3rd party ETL tool (DataStage, Talend, or Informatica)
  3. Proficient in Java and Spring Framework, and experience with Apache Kafka
  4. Knowledge of NiFi, Python, SQData, and/or Job Control Language (JCL) a plus
  5. Proficient in SQL, with experience in a database technology (DB2, Oracle, SQL Server, Postgres)
  6. General understanding of Data Modeling principles and ability to tune SQL for optimal performance
  7. Ability to think outside of the box, have fun, and engage with co-workers

To apply, please send your resume to

Cohesion is an IT Services Firm dedicated to advancing the careers of IT Professionals.  We work with some of the most recognized companies in the country to place IT professionals that stand out among their peers.  Talented individuals need challenging opportunities. To discover your next great opportunity and begin to build a career path, contact us today.


© Cohesion . All Rights Reserved.