We are seeking a skilled ETL Engineer 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

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

Required Skills

• 8+ years in data integration & ETL design.
• 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.
  
  

Preferred Qualifications

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

Benefits

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

Additional Responsibilities

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

About Us

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.