Informatica Cloud Developer

TechDigital Group; Cary (NC); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading technology company in Cary, North Carolina is seeking an experienced ETL Developer to design and maintain workflows using Informatica. The ideal candidate will have strong skills in Oracle SQL and a track record of ensuring data quality through profiling and cleansing. Join us to collaborate with stakeholders and enhance our data solutions in a fast-paced environment.

Responsibilities

• Design, develop, and maintain ETL workflows using Informatica IICS and PowerCenter.
• Write and optimize Oracle SQL queries for data extraction, transformation, and reporting.
• Collaborate with business analysts and stakeholders to understand data requirements.
• Perform data profiling, cleansing, and validation to ensure high data quality.
• Participate in performance tuning and troubleshooting of ETL processes.
• Document technical specifications, data flow diagrams, and process logic.

Skills

Informatica Cloud

IICS

SQL

Analytical skills

Tools

Informatica PowerCenter

Oracle SQL

Teradata

Job description

Mandatory Skills

Informatica Cloud, IICS, SQL with good analytical skills

Key Responsibilities

• Design, develop, and maintain ETL workflows using Informatica IICS and PowerCenter.


• Write and optimize Oracle SQL queries for data extraction, transformation, and reporting.


• Collaborate with business analysts and stakeholders to understand data requirements and translate them into technical solutions.


• Perform data profiling, cleansing, and validation to ensure high data quality.


• Participate in performance tuning and troubleshooting of ETL processes.


• Document technical specifications, data flow diagrams, and process logic.


• Optional: Support data migration or integration tasks involving Teradata.