Purple Drive
************Local Preferred****************
Key Responsibilities:
Design, develop, and maintain ETL workflows using Informatica PowerCenter (or IICS if cloud-based). Extract, transform, and load data from multiple sources (databases, flat files, APIs, etc.) into target systems. Optimize ETL jobs for performance, scalability, and reliability. Work with business analysts and data architects to translate requirements into technical solutions. Perform data validation, error handling, and troubleshooting of ETL processes. Support production deployments and resolve data integration issues in a timely manner. Required Skills:
Strong hands-on experience in
Informatica PowerCenter / Informatica Cloud (IICS) . Solid knowledge of
SQL
and relational databases (Oracle, SQL Server, or similar). Experience in
ETL performance tuning
and debugging. Understanding of
data warehousing concepts
(star schema, snowflake, fact/dimension tables). Familiarity with scheduling tools (Control-M, Autosys, or equivalent). Nice-to-Have Skills:
Experience with
cloud platforms
(AWS, Azure, or GCP). Knowledge of
Informatica MDM or Data Quality (IDQ) . Exposure to
Unix/Linux scripting .
Key Responsibilities:
Design, develop, and maintain ETL workflows using Informatica PowerCenter (or IICS if cloud-based). Extract, transform, and load data from multiple sources (databases, flat files, APIs, etc.) into target systems. Optimize ETL jobs for performance, scalability, and reliability. Work with business analysts and data architects to translate requirements into technical solutions. Perform data validation, error handling, and troubleshooting of ETL processes. Support production deployments and resolve data integration issues in a timely manner. Required Skills:
Strong hands-on experience in
Informatica PowerCenter / Informatica Cloud (IICS) . Solid knowledge of
SQL
and relational databases (Oracle, SQL Server, or similar). Experience in
ETL performance tuning
and debugging. Understanding of
data warehousing concepts
(star schema, snowflake, fact/dimension tables). Familiarity with scheduling tools (Control-M, Autosys, or equivalent). Nice-to-Have Skills:
Experience with
cloud platforms
(AWS, Azure, or GCP). Knowledge of
Informatica MDM or Data Quality (IDQ) . Exposure to
Unix/Linux scripting .