Software Engineer Lead – ETL

Jobtailor; Kentucky; On-site; USD 90,000 - 140,000; Full time

Job summary

Jobtailor in Kentucky is seeking a senior data solutions lead to drive the design and development of software and data integrations across business units.

You will oversee large data warehouses, guide colleagues, and ensure robust ETL processes using Informatica and Java/Spring Boot, with a strong emphasis on documentation and standards.

The role offers opportunities to shape technical strategy, mentor peers, and deliver impactful business outcomes through modern data initiatives.

Qualifications

• Proven experience with data warehousing and large data volumes.
• Informatica ETL design and development expertise.
• Experience with Teradata, Oracle and Hadoop.
• Knowledge of deployment tools such as Udeploy, Artifactory and GitHub.
• Hands-on Java and Spring Boot development experience.

Responsibilities

• Lead technical design and development of software solutions.
• Propose and design data integration and warehousing solutions.
• Prepare technical and procedural documentation.
• Provide guidance and support to team members.
• Review code, tests, and documentation of software.
• Apply modern methodologies to advance data initiatives.

Skills

Java

Spring Boot

ETL development

Data warehousing

Problem solving

Tools

Informatica ETL

CA7 Orchestration

Teradata

Oracle

Hadoop

Udeploy

Artifactory

GitHub

Job description

Responsibilities

• Creates and leads the technical design and development of software solutions.
• Proposes & designs software solutions to address complex business needs.
• Prepares technical and procedural documentation required.
• Facilitates complex problem resolution.
• Provides technical guidance and support to colleagues.
• Reviews coding, testing, and documentation of software.
• Applies modern principles, methodologies and tools to advance business initiatives and capabilities.

Requirements

• Informatica ETL development and design.
• Leading complex Data Warehouse applications.
• CA7 Orchestration
• Data Warehouse experience, and working with large amounts of data
• Teradata, Oracle, Hadoop
• Experience solutioning new data integrations
• Experience with code deployment tools such as Udeploy, Artifactory and GitHub.
• Java/ Spring Boot knowledge