What are the responsibilities and job description for the Data Integration Engineer(Informatica) position at OP?
OP is currently seeking a skilled Data Integration Lead to drive end-to-end data integration strategies across enterprise systems. The ideal candidate will have deep experience with ETL design and development (Informatica preferred) and hands-on knowledge of data governance using Collibra. This role is key in ensuring seamless data flows, data quality, and regulatory compliance.
Key Responsibilities
OP is a technology consulting and solutions company, offering advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields — including AI, cyber security, enterprise architecture, and beyond. Our most valuable asset is our people: dynamic, creative thinkers, who are passionate about doing quality work. As a member of the OP team, you will have access to industry-leading consulting practices, strategies & and technologies, innovative training & education. An ideal OP team member is a technology leader with a proven track record of technical excellence and a strong focus on process and methodology.
Key Responsibilities
- Lead the design, development, and deployment of ETL pipelines using Informatica PowerCenter/Cloud.
- Collaborate with data architects and business teams to integrate data from various source systems (on-prem and cloud).
- Drive data governance efforts by implementing Collibra workflows for metadata management, data lineage, and stewardship.
- Create and maintain data models, technical mappings, and source-to-target documentation.
- Define and enforce data integration standards and best practices.
- Monitor data quality and resolve issues related to data movement, transformation, and integrity.
- Support audit, compliance, and regulatory reporting requirements via Collibra catalogs and lineage reports.
- Mentor junior data engineers and coordinate with offshore teams.
- 8 years in data integration, ETL design, and data architecture.
- Strong proficiency with Informatica PowerCenter, Informatica Cloud, or similar ETL tools.
- Working experience with Collibra for data cataloging, metadata management, and stewardship workflows.
- Strong SQL and data modeling skills (logical/physical models).
- Familiarity with data governance frameworks, data quality metrics, and data privacy practices (e.g., GDPR, CCPA).
- Ability to work across cross-functional teams and lead discussions with business and technical stakeholders.
- Excellent communication, documentation, and problem-solving skills.
- Experience in cloud data platforms (AWS, Azure, GCP).
- Exposure to Snowflake, Databricks, or BigQuery.
- Collibra Ranger Certification or other Collibra training.
- Knowledge of data lineage tools, REST APIs, or data fabric architecture is a plus.
- 401(k).
- Dental Insurance.
- Health insurance.
- Vision insurance.
- We are an equal opportunity employer and value diversity, equality, inclusion, and respect for people.
- The salary will be determined based on several factors, including, but not limited to, location, relevant education, qualifications, experience, technical skills, and business needs.
- Participate in OP monthly team meetings, and participate in team-building efforts.
- Contribute to OP technical discussions, peer reviews, etc.
- Contribute content and collaborate via the OP-Wiki/Knowledge Base.
- Provide status reports to OP Account Management as requested.
OP is a technology consulting and solutions company, offering advisory and managed services, innovative platforms, and staffing solutions across a wide range of fields — including AI, cyber security, enterprise architecture, and beyond. Our most valuable asset is our people: dynamic, creative thinkers, who are passionate about doing quality work. As a member of the OP team, you will have access to industry-leading consulting practices, strategies & and technologies, innovative training & education. An ideal OP team member is a technology leader with a proven track record of technical excellence and a strong focus on process and methodology.
