Informatica Integration Developer

Attain Partners is an innovative consulting firm dedicated to disrupting the status quo to change the world and improve the lives of those we touch. From strategy to technology and ever y where in between, our experts use their unique skills to advance the important missions of education, nonprofit, healthcare, and state and local government clients.

People are at the center of all we do, and that’s why we empower career growth, provide industry-leading benefits packages, encourage a flexible work environment, and foster a culture of inclusion to support the needs of our team. We share a collective passion for our mission and our people. Guided by our seven core values, The Attain Way, our vision is the foundation of our culture—to be and attain the best.

Job Description

We are seeking an experienced Informatica Integration Developer to design, develop, and support enterprise-grade data integration solutions. This role will focus on building scalable data pipelines, ensuring high data quality, and enabling seamless data movement across cloud and on-premise systems. The ideal candidate has strong hands-on experience with Informatica’s Intelligent Data Management Cloud (IDMC) and is passionate about delivering clean, trusted, and AI-ready data to support analytics, reporting, and business operations.

Job Responsibilities

• Design, develop, and maintain data integration workflows using Informatica (IDMC, IICS, or PowerCenter)
• Build and optimize ETL/ELT pipelines for data ingestion, transformation, and loading Integrate data across systems such as CRM, ERP (Workday, Oracle, SAP), and data warehouses (Snowflake, SQL Server)
• Implement data quality rules, validations, and monitoring processes
• Collaborate with data architects and business stakeholders to translate requirements into technical solutions
• Support data migration, conversion, and modernization initiatives
• Troubleshoot and resolve integration and data-related issues
• Ensure adherence to data governance, security, and compliance standards
• Document technical designs, mappings, and workflows
• Lead and/or support business development efforts
• Lead and/or support proposal development and solution design in support of new and expanded client work

Required Skills

• 3–7+ years of experience in data integration or ETL development
• Informatica Intelligent Cloud Services (IICS) / IDMC or PowerCenter
• Data Integration, Mass Ingestion, or Application Integration modules
• Strong SQL skills (data querying, transformation, optimization)
• Experience with REST/SOAP APIs and file-based integrations (CSV, JSON, XML)
• Understanding of data warehousing concepts and dimensional modeling
• Experience working with cloud data platforms (e.g., Snowflake, AWS, Azure, GCP)
• Familiarity with data quality and governance concepts
• Strong problem-so