Job Title: Application Architect – Informatica & Finance
Job Type: Long Term Contract
Location: Columbus, OH - Remote
Position Summary
We are seeking an experienced Application Architect with strong expertise in Informatica data integration technologies and a solid understanding of accounting and finance processes. The ideal candidate will lead the design and implementation of scalable enterprise data integration architectures connecting financial source systems, data warehouses, data lakes, and reporting platforms.
This role requires a combination of technical architecture leadership, hands-on Informatica expertise, data governance, and the ability to collaborate effectively with finance stakeholders and IT delivery teams.
Key Responsibilities
- Application Architecture: Define and implement end-to-end application and data integration architectures aligned with enterprise finance and accounting requirements.
- Informatica Development: Design, develop, and optimize ETL/ELT pipelines using Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), and Informatica Data Quality.
- Financial Data Integration: Integrate financial ERP systems, accounting applications, data warehouses, data lakes, and reporting platforms.
- Data Quality & Governance: Establish data validation, reconciliation, metadata management, data lineage, and governance practices to ensure financial data accuracy and audit compliance.
- Technical Leadership: Define architecture standards, coding guidelines, reusable integration frameworks, and technical documentation.
- Performance Optimization: Identify bottlenecks and optimize data integration workflows for scalability, reliability, and performance.
- Stakeholder Collaboration: Partner with finance, accounting, business analysis, and IT teams to translate business requirements into technical solutions.
- Team Mentoring: Provide technical guidance and mentorship to developers and integration teams throughout the solution delivery lifecycle.
- Security & Compliance: Ensure data integration solutions comply with enterprise security policies, financial controls, and applicable audit requirements.
Required Qualifications
- 8+ years of experience in Information Technology, including at least 4+ years in application architecture, solution architecture, or enterprise data integration architecture.
- Extensive experience designing and implementing enterprise ETL/ELT solutions using Informatica PowerCenter and/or Informatica IICS.
- Strong knowledge of Informatica mappings, workflows, transformations, scheduling, monitoring, and performance tuning.
- Experience with Informatica Data Quality, metadata management, and data governance practices.
- Solid understanding of accounting and finance concepts, including general ledger, accounts payable, accounts receivable, financial reporting, and reconciliation.
- Experience integrating financial ERP systems with enterprise data warehouses, data lakes, and business intelligence platforms.
- Knowledge of relational databases, SQL, data modeling, and enterprise data architecture principles.
- Experience defining technical standards, architecture documentation, and reusable integration patterns.
- Strong analytical, problem-solving, communication, and stakeholder management skills.
- Ability to work effectively with technical teams and business finance stakeholders.
Preferred Qualifications
- Bachelor’s degree in Computer Science, Information Technology, Accounting, Finance, or a related discipline.
- Informatica certifications in PowerCenter, IICS, or Informatica Cloud Data Quality.
- Experience with cloud platforms such as AWS, Microsoft Azure, or Google Cloud Platform.
- Familiarity with financial ERP platforms such as SAP, Oracle Financials, or Microsoft Dynamics 365 Finance.
- Experience with enterprise data warehouses, BI/reporting tools, and modern cloud data platforms.
- Knowledge of financial data controls, audit requirements, and regulatory compliance practices.
Expected Deliverables
- Enterprise application and data integration architecture designs.
- Scalable Informatica ETL/ELT pipelines for financial data.
- Data quality, reconciliation, and governance frameworks.
- Technical design documents, standards, and reusable integration patterns.
- Optimized data workflows supporting accurate and timely financial reporting.
Ideal Candidate Profile
The ideal candidate is a technically strong Application Architect who combines deep Informatica expertise with practical accounting and finance domain knowledge. The candidate should be capable of leading enterprise integration initiatives, ensuring financial data integrity, and translating business requirements into secure, scalable, and maintainable technical solutions.
