Return To Job Search

Ingestion Engineer - Lead
Ohio
Cincinnati Metro Area
Developer
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 cohesion.com. 


Position: Ingestion Engineer - Lead

TECHNICAL SKILLS

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

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

JOB DESCRIPTION

GENERAL FUNCTION:
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.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

  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

MINIMUM KNOWLEDGE, SKILLS AND ABILITES REQUIRED:
  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

Contact
To apply, please send your resume to dhurley@cohesion.com

 
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.