ON Partners

Informatica Integration Developer

ON Partners

full-time

Posted on:

Location Type: Remote

Location: United States

Visit company website

Explore more

✨ AI Apply
Apply

Salary

💰 $110,000 - $120,000 per year

Tech Stack

AWSAzureCloudERPETLGoogle Cloud PlatformInformaticaOracleSOAPSQL

About the role

  • 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.

Requirements

  • 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.
Benefits
  • 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.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
InformaticaETLELTSQLREST APIsSOAP APIsdata warehousingdimensional modelingdata qualitydata governance
Soft Skills
problem-solvingcollaborationcommunicationleadership