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 everywhere 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
Hands-on experience with:
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-solving and debugging skills
Desired Skills
Experience with Informatica Data Quality (IDQ) or MDM
Exposure to API-led integration patterns
Knowledge of Python or scripting for data processing
Experience with orchestration tools or iPaaS platforms (e.g., Boomi, MuleSoft, Workato)
Familiarity with DevOps practices (CI/CD pipelines, Git)
Experience in industry domains such as Healthcare, Higher Education, Financial Services, or Non-Profit
Informatica Professional Certification (IICS / IDMC)
Additional Information
Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:
Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
11 paid federal holidays and flexible unlimited time off (UTO)
Generous 401(k) matching with immediate vesting
Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
A healthy environment where we value unique experiences, and care about everything that makes you, you.
Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.
Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications.Salary Range$110,000—$120,000 USD
Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Applicants have rights under Federal Employment Laws. For more Information visit EEO, EEO Poster Supplement, Family and Medical Leave Act (FMLA), and Employee Polygraph Protection Act (EPPA).
If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.
Apply Now
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
Hands-on experience with:
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-solving and debugging skills
Desired Skills
Experience with Informatica Data Quality (IDQ) or MDM
Exposure to API-led integration patterns
Knowledge of Python or scripting for data processing
Experience with orchestration tools or iPaaS platforms (e.g., Boomi, MuleSoft, Workato)
Familiarity with DevOps practices (CI/CD pipelines, Git)
Experience in industry domains such as Healthcare, Higher Education, Financial Services, or Non-Profit
Informatica Professional Certification (IICS / IDMC)
Additional Information
Attain Partners values your mental, emotional, and physical health and wellbeing. Our comprehensive benefits package starts on your first day of employment and includes benefits such as:
Competitive health, dental, and vision coverage, HSA and FSA accounts, life and disability insurance, fertility and family planning benefits, and employee assistance and discount programs
11 paid federal holidays and flexible unlimited time off (UTO)
Generous 401(k) matching with immediate vesting
Flexible career paths – our career tracks provide advancement, mobility, and flexibility as you continue to grow with us
A healthy environment where we value unique experiences, and care about everything that makes you, you.
Attain Partners is committed to fair and equitable compensation practices. The individual base salary for this position is unique to each candidate and will be commensurate with experience, education, and skills. In addition to base salary, this role is eligible for an annual discretionary bonus.
Interested in this position but the compensation isn’t quite right? Let us know your expectations, and we’ll see if we can make it happen based on your qualifications.Salary Range$110,000—$120,000 USD
Attain Partners is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to sex, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.
Applicants have rights under Federal Employment Laws. For more Information visit EEO, EEO Poster Supplement, Family and Medical Leave Act (FMLA), and Employee Polygraph Protection Act (EPPA).
If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.
Apply Now