Senior Informatica PowerCenter ETL Developer

Deegit Inc; Camp Hill (Cumberland County); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology services company is seeking a skilled candidate for a data architecture role in Camp Hill, PA. You will work on implementing and enhancing enterprise-level data architecture using ETL tools, specifically Informatica PowerCenter. The ideal candidate has over 5 years of experience in ETL processes, strong SQL skills, and experience in data warehousing. This role demands a technical mindset and the ability to collaborate with cross-functional teams.

Qualifications

• 5+ years of experience in developing Informatica PowerCenter ETL mappings using Designer and Workflow Manager.
• 3-5 years of hands-on experience in administration and configuration of Informatica PowerCenter Server.
• 2 years of experience using Oracle PL/SQL.

Responsibilities

• Implement, maintain, and enhance enterprise-level data architecture using Informatica Power Center.
• Develop and implement ETL processes to support sequencing and analysis efforts.
• Create technical design documents that capture mapping and document data quality rules.

Skills

Informatica PowerCenter ETL mappings

SQL

Interpersonal and communication skills

Oracle PL/SQL

Education

B.S. or higher in Computer Science or another technical field

Tools

Informatica PowerCenter

Oracle Enterprise Manager

Job description

A technology services company is seeking a skilled candidate for a data architecture role in Camp Hill, PA. You will work on implementing and enhancing enterprise-level data architecture using ETL tools, specifically Informatica PowerCenter. The ideal candidate has over 5 years of experience in ETL processes, strong SQL skills, and experience in data warehousing. This role demands a technical mindset and the ability to collaborate with cross-functional teams.