Purple Drive
Job Title:
Lead Informatica Engineer
Location:
Owing Mills,MD
Employment Type:
Contarct
Role Overview
Seeking a seasoned Lead Informatica Engineer with deep expertise in Informatica tools, data pipeline design, and enterprise data integration. The candidate will play a key role in developing, optimizing, and supporting data solutions, driving high-quality delivery across a broad range of database technologies and business requirements.
Key Responsibilities
Lead the design, implementation, and optimization of
data pipelines
and data processing solutions using
Informatica PowerCenter, PowerExchange, and IICS . Develop and maintain
data marts , enterprise data warehouses ( EDW ), and operational data stores ( ODS ), ensuring alignment with business data strategies. Architect
ETL pipelines
and support real-time data integration using open integration patterns. Work with diverse database platforms including
Snowflake, DB2, Postgres , and others for large-scale data management and analytics. Troubleshoot and resolve
performance issues , optimize ETL workloads for
parallelism , and handle complex
data modeling
tasks. Manage
ID management , Snowflake data shares, and oversee client/prospect data management processes. Collaborate with cross-functional teams and business stakeholders in an
Agile environment
to deliver data solutions that meet business goals. Provide production support, resolve Informatica workflow issues, analyze job failures, and ensure smooth job scheduling, hosting, and monitoring. Maintain comprehensive documentation and provide clear communication, both written and verbal, across technical and business teams. Required Skills and Experience
7+ years
hands-on experience with
Informatica
tools (PowerCenter, PowerExchange, IICS). 10+ years
total experience in data engineering roles with strong knowledge of
data warehousing concepts , data marts, EDW, and ODS. Proven experience designing and implementing scalable data pipelines and real-time integrations. Strong proficiency with
Snowflake, DB2, Postgres , and other database technologies. Experience troubleshooting and fixing ETL performance and parallelism issues; advanced experience with data modeling. Exposure to
ID management , Snowflake data sharing, and enterprise data management. Practical experience with
Agile methodologies
and effective stakeholder management. Solid background in production support for Informatica environments, including issue resolution and process optimization. Excellent written and verbal communication skills.
Lead Informatica Engineer
Location:
Owing Mills,MD
Employment Type:
Contarct
Role Overview
Seeking a seasoned Lead Informatica Engineer with deep expertise in Informatica tools, data pipeline design, and enterprise data integration. The candidate will play a key role in developing, optimizing, and supporting data solutions, driving high-quality delivery across a broad range of database technologies and business requirements.
Key Responsibilities
Lead the design, implementation, and optimization of
data pipelines
and data processing solutions using
Informatica PowerCenter, PowerExchange, and IICS . Develop and maintain
data marts , enterprise data warehouses ( EDW ), and operational data stores ( ODS ), ensuring alignment with business data strategies. Architect
ETL pipelines
and support real-time data integration using open integration patterns. Work with diverse database platforms including
Snowflake, DB2, Postgres , and others for large-scale data management and analytics. Troubleshoot and resolve
performance issues , optimize ETL workloads for
parallelism , and handle complex
data modeling
tasks. Manage
ID management , Snowflake data shares, and oversee client/prospect data management processes. Collaborate with cross-functional teams and business stakeholders in an
Agile environment
to deliver data solutions that meet business goals. Provide production support, resolve Informatica workflow issues, analyze job failures, and ensure smooth job scheduling, hosting, and monitoring. Maintain comprehensive documentation and provide clear communication, both written and verbal, across technical and business teams. Required Skills and Experience
7+ years
hands-on experience with
Informatica
tools (PowerCenter, PowerExchange, IICS). 10+ years
total experience in data engineering roles with strong knowledge of
data warehousing concepts , data marts, EDW, and ODS. Proven experience designing and implementing scalable data pipelines and real-time integrations. Strong proficiency with
Snowflake, DB2, Postgres , and other database technologies. Experience troubleshooting and fixing ETL performance and parallelism issues; advanced experience with data modeling. Exposure to
ID management , Snowflake data sharing, and enterprise data management. Practical experience with
Agile methodologies
and effective stakeholder management. Solid background in production support for Informatica environments, including issue resolution and process optimization. Excellent written and verbal communication skills.