Data Engineer ; Mid-Level

An UNCOMN Genius Leading Innovation means believing in the power of business to make the world a better place through everyday business relationships and interactions. If you join our team, our commitment to you is to find a role that accentuates your strengths and helps you exercise your own brand of “UNCOMN Genius” to reach your career aspirations. We’ll invest in you because — as a consultancy — our people are our brand and great companies invest in their brands.

Our Communities of Practice (COPs) offer a dynamic platform for team members to enhance their professional skills and pursue personal growth in their desired areas. These communities facilitate the development of professional skills, foster the sharing of information and expertise, and encourage the incubation of innovative ideas. Additionally, they provide a space for collaboration with seasoned professionals. Participants are assigned their COP, and we supply the necessary framework and a collaborative environment for their development.

This approach not only supports individual growth, but also strengthens our collective expertise.

Location: Scott AFB, IL

Remote Status: Hybrid

Job :670

# of Openings:1

At UN COMN
, we don’t just fix issues; we deliver secure solutions that power essential operations in both the public and private sectors. Our team tackles tough challenges—whether it’s improving organizational systems, streamlining logistics, or making sense of complex data—all with one goal: helping our clients succeed so they can continue serving others.
We’ve built a culture rooted in our Core Values , where innovation thrives, work-life balance is respected, and career growth is always encouraged. We're also proud to be recognized as a ‘
Top Workplace ’, and that’s not just us talking; it’s our employees. Now, we’re looking for another Uncommon Genius to join our dynamic team. If you love solving puzzles, building new things, fixing what’s broken, or pushing the boundaries of creativity, we encourage you to explore the details of this position below!

UN COMN is seeking an ETL & Data Ingestion Engineer (Data Engineer/Scientist 3 - Mid-Level) to support the Integrated Data Environment & Global Transportation Network Convergence (IGC) team. Responsibilities could include the following:

ETL and Informatica Engineering

• Lead the design, development, testing, deployment, and maintenance of enterprise ETL and data-integration solutions using Informatica and related approved technologies.
• Develop and optimize Informatica mappings, transformations, workflows, sessions, reusable components, scheduling configurations, and restart/recovery logic.
• Modernize legacy ETL workflows by refactoring mappings, SQL, transformation logic, interfaces, and operational processes for approved database and cloud environments.
• Develop and optimize complex SQL queries, views, stored procedures, functions, indexes, and transformation logic supporting high-volume data-processing workloads.
• Perform design and code reviews and establish reusable ETL patterns, development practices, and technical approaches for complex data-integration work.

• Design ingestion patterns for relational databases, APIs, web services, message-based interfaces, structured and unstructured files, and other approved enterprise data sources.
• Design and implement batch, micro-batch, incremental, event-driven, and change-data-capture processing approaches based on approved mission, interface, and performance requirements.
• Analyze source-system structures, interfaces, dependencies, formats, and business rules and develop source-to-target mappings, transformation specifications, data dictionaries, lineage documentation, and interface-control…