Developer II (ETL Developer - Middleware)

HNI Corporationis a global family of brands for the workplace and home dedicated to enhancing the spaces where we live, work, and gather. Wepride ourselves on fostering an environment where we make a positive impact on others; upholding our beliefs in integrity, inclusion and belonging.

We are hiring a Developer II with experience in middleware and integrations. This role focuses on designing, building, and maintaining robust data pipelines and integration solutions that connect enterprise applications, transactional systems, and third-party platforms. Unlike BI or analytics-focused data engineering roles, this position emphasizes operational data flows, system interoperability, and ensuring that critical business applications communicate efficiently and reliably.

This is a full-time, direct-hire salaried position that will work onsite four days a week (M-TH) from our newly renovated IT building in Muscatine, IA.

What You Will Do:

• Design, develop, and maintain ETL processes and data integration solutions to support middleware workflows across enterprise systems.
• Build and optimize data pipelines that enable seamless exchange of information between ERP, CRM, HR, finance, and other enterprise applications.
• Collaborate with application owners, solution architects, and infrastructure teams to translate integration requirements into scalable technical solutions.
• Ensure data integrity, consistency, and security across multiple platforms and environments.
• Develop APIs, messaging services, and file-based integrations to enable application interoperability.
• Monitor and troubleshoot data flows, addressing performance bottlenecks and integration failures.
• Document system designs, data mappings, and integration specifications to support ongoing maintenance and knowledge transfer.
• Stay current with emerging tools, patterns, and practices in enterprise integration and middleware technologies.

What You Have:

• Bachelor's degree in Computer Science, Information Systems, or a related field (or equivalent experience).
• 3-5 years of experience as a Data Engineer, ETL Developer, or Integration Developer within an enterprise IT environment.
• Strong proficiency with Informatica ETL tools
• Hands-on experience building web services (REST/SOAP)
• Solid understanding of SQL, relational databases, and data modeling.

Preferred Qualifications

• Experience with scripting languages (Python, PowerShell, Shell) for automation and data manipulation.
• Familiarity and/or experience with Oracle Integration Cloud (OIC) is STRONGLY preferred.
• Strong problem-solving skills and the ability to work collaboratively with cross-functional teams.

Relevant Skils

• Proficiency with ETL tools
• Experience developing and maintaining data pipelines and workflows
• Strong SQL skills (query optimization, stored procedures, performance tuning)
• Knowledge of data mapping, transformation, and cleansing techniques
• Familiarity with data modeling (relational and dimensional)

• Hands-on experience with APIs (REST, SOAP) and web services
• Knowledge of file-based integrations (SFTP, flat files, XML, JSON, CSV)
• Experience with enterprise service bus (ESB) or integration frameworks

• Proficiency with relational databases (Oracle, SQL Server)

• Python for scripting and automation
• Shell scripting / PowerShell for batch jobs and system-level integration

• Experience with CI/CD pipelines for ETL and integration code deployment
• Familiarity with version control (Git, SVN)
• Experience with job scheduling/orchestration tools (Airflow, Automic UC4)

• Understanding of data security practices (encryption, masking, secure file transfer)

We look forward to hearing for you!

HNI Corporation (NYSE: HNI) is a manufacturer of workplace furnishings and building products, operating under two segments. The workplace furnishings segment is a leading global designer and provider of commercial furnishings, going to market under multiple unique brands. The residential building products segment is the nation's leading manufacturer and marketer of hearth products.
We offer benefits starting from Day 1. To learn more, visit www.HNIbenefits.com.
Our company endeavors to make www.hnicareers.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at 563-272-7400 or via email at [emailprotected] Company is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, disability, protected veteran status, or other characteristics protected by law.