Overview
On Site
Contract - W2
Contract - 12+ month(s)
Skills
Data Flow
Auditing
Regulatory Compliance
Regulatory Reporting
Mentorship
Offshoring
Data Integration
Data Architecture
Informatica PowerCenter
Informatica
Extract
Transform
Load
Meta-data Management
Workflow
SQL
Data Modeling
Data Governance
Data Quality
Privacy
Communication
Documentation
Conflict Resolution
Problem Solving
Cloud Computing
Amazon Web Services
Microsoft Azure
Google Cloud Platform
Google Cloud
Snow Flake Schema
Databricks
Health Insurance
Insurance
Team Building
Collaboration
Wiki
Knowledge Base
Status Reports
Account Management
IT Consulting
Managed Services
Recruiting
Artificial Intelligence
Cyber Security
Enterprise Architecture
Training
FOCUS
Job Details
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:
- 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, 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.
Preferred Qualifications:
- Experience in cloud data platforms (AWS, Azure, Google Cloud Platform).
- 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.