Purple Drive
Role Overview
We are looking for an experienced
Informatica ETL Engineer
to design, implement, and support enterprise-scale data integration and processing solutions. The ideal candidate will have strong expertise in
Informatica PowerCenter, PowerExchange, and IICS , with proven experience in building and optimizing
ETL pipelines , managing
data marts , and providing
production support
in complex data environments. You will work closely with data architects, analysts, and business stakeholders to deliver high-quality, scalable data solutions.
Key Responsibilities
Design, develop, and maintain
ETL workflows
and
data integration solutions
using
Informatica PowerCenter, PowerExchange, and IICS . Build and optimize
data marts ,
data warehouses (EDW) , and
operational data stores (ODS) . Provide
production support
by monitoring, troubleshooting, and resolving issues in Informatica workflows and jobs. Manage and enhance
data pipelines
for real-time and batch integrations using open integration patterns. Work with databases like
Snowflake, DB2, and PostgreSQL , ensuring performance optimization and data integrity. Diagnose and resolve
performance bottlenecks , enable parallelism, and ensure efficient data processing. Manage
ID management ,
Snowflake data shares , and client/prospect data workflows. Collaborate with cross-functional teams under
Agile methodologies
to deliver scalable and reliable data solutions. Schedule, monitor, and analyze ETL job executions, ensuring timely and accurate data delivery. Communicate effectively with stakeholders to understand requirements, present findings, and support ongoing operations. Required Skills
7+ years of
hands-on experience
with
Informatica tools
(PowerCenter, PowerExchange, IICS). 10+ years of total experience in
data warehousing (DW) ,
data marts ,
EDW , and
ODS . Strong experience in
production support , performance tuning, and data model optimization. Proficiency in
Snowflake ,
DB2 ,
PostgreSQL , and other relational database systems. Knowledge of
data modeling ,
parallel processing , and
real-time integration
techniques. Experience with
Agile methodologies
and working in cross-functional teams. Strong analytical, troubleshooting, and communication skills (verbal & written).
We are looking for an experienced
Informatica ETL Engineer
to design, implement, and support enterprise-scale data integration and processing solutions. The ideal candidate will have strong expertise in
Informatica PowerCenter, PowerExchange, and IICS , with proven experience in building and optimizing
ETL pipelines , managing
data marts , and providing
production support
in complex data environments. You will work closely with data architects, analysts, and business stakeholders to deliver high-quality, scalable data solutions.
Key Responsibilities
Design, develop, and maintain
ETL workflows
and
data integration solutions
using
Informatica PowerCenter, PowerExchange, and IICS . Build and optimize
data marts ,
data warehouses (EDW) , and
operational data stores (ODS) . Provide
production support
by monitoring, troubleshooting, and resolving issues in Informatica workflows and jobs. Manage and enhance
data pipelines
for real-time and batch integrations using open integration patterns. Work with databases like
Snowflake, DB2, and PostgreSQL , ensuring performance optimization and data integrity. Diagnose and resolve
performance bottlenecks , enable parallelism, and ensure efficient data processing. Manage
ID management ,
Snowflake data shares , and client/prospect data workflows. Collaborate with cross-functional teams under
Agile methodologies
to deliver scalable and reliable data solutions. Schedule, monitor, and analyze ETL job executions, ensuring timely and accurate data delivery. Communicate effectively with stakeholders to understand requirements, present findings, and support ongoing operations. Required Skills
7+ years of
hands-on experience
with
Informatica tools
(PowerCenter, PowerExchange, IICS). 10+ years of total experience in
data warehousing (DW) ,
data marts ,
EDW , and
ODS . Strong experience in
production support , performance tuning, and data model optimization. Proficiency in
Snowflake ,
DB2 ,
PostgreSQL , and other relational database systems. Knowledge of
data modeling ,
parallel processing , and
real-time integration
techniques. Experience with
Agile methodologies
and working in cross-functional teams. Strong analytical, troubleshooting, and communication skills (verbal & written).