ETL Architect

Position: ETL Architect

JFS – IT Consultant 1 (ITC1)

Location: Columbus, OH – Remote
Duration: Long Term
Work Hours: 7:00 AM – 4:00 PM EST

Location Preference: Candidates preferably located in Ohio or within the Eastern Standard Time zone.

Position Summary

We are seeking an experienced Application Architect with deep expertise in Informatica data integration and a strong foundation in Accounting and Finance domains. The candidate will lead the design, development, and governance of enterprise data flows connecting financial source systems, data warehouses, and reporting platforms, ensuring financial data integrity and scalable architecture.

Key Responsibilities

·        Architecture & Strategy: Define end-to-end application and data integration architecture for finance and accounting systems, aligning technical solutions with enterprise financial goals.

·        Informatica Leadership: Design, build, and optimize robust ETL/ELT pipelines, data integration strategies, and metadata management solutions using Informatica PowerCenter / Intelligent Cloud Services (IICS).

·        Data Governance & Security: Enforce rigorous data quality and checks to ensure financial data accuracy and audit compliance.

·        Technical Governance: Establish coding standards, design patterns, and framework documentation for integration and delivery teams.

·        Collaboration & Mentorship: Guide cross-functional teams, mentor junior developers, and act as the technical liaison between finance stakeholders and IT delivery groups.

Required Qualifications

·        Experience: 8+ years in Information Technology, with at least 4+ years specializing in enterprise application or solution architecture.

·        Informatica Expertise: Proven track record designing large-scale data warehousing and ETL solutions using the Informatica suite (IICS, PowerCenter, Data Quality).

·        Domain Knowledge: Solid working knowledge of core financial and accounting concepts.

·        Integration Skills: Experience integrating financial ERPs with data lakes, enterprise data warehouses, and reporting tools.

·        Communication: Exceptional stakeholder management and communication skills to bridge complex technical concepts with business finance teams.

Preferred Qualifications

·        Bachelor’s degree in computer science, Information Technology, Accounting, Finance, or a related field.

·        Certifications in Informatica or Cloud Platforms (AWS/Azure/Google Cloud Platform).

Skill Matrix

·        Information Technology & Application/Solution Architecture – Required – 8+ years in IT, including 4+ years in enterprise application or solution architecture.

·        Informatica (IICS, PowerCenter, Data Quality) – Required – Experience designing large-scale data warehousing and ETL solutions.

·        Accounting & Finance Domain Knowledge – Required – Solid working knowledge of core financial and accounting concepts.

·        Financial ERP Integration – Required – Experience integrating financial ERPs with data lakes, enterprise data warehouses, and reporting tools.

·        Stakeholder Management & Communication – Required – Ability to communicate complex technical concepts to business finance teams and manage stakeholders.

·        Bachelor’s Degree – Highly Desired – Computer Science, Information Technology, Accounting, Finance, or a related field.

·        Informatica/Cloud Certifications – Highly Desired – Certifications in Informatica or AWS, Azure, or Google Cloud Platform.