Remote Informatica PowerCenter Developer | Teradata ETL

Abundant Code; Springfield (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC in Springfield, IL seeks an Informatica PowerCenter Developer with Teradata experience. The role emphasizes ETL design, performance tuning, and healthcare data integrations. Remote work options exist with a strong W2 requirement and 10+ years of experience.

Candidates should have PowerCenter administration experience, Unix scripting, and proficiency with SQL, Teradata utilities, and related tools. H1b transfer is acceptable.

Qualifications

• 7+ years of experience with Informatica PowerCenter and ETL development.
• 5+ years of SQL development and performance tuning.
• 5+ years of Teradata (v17+), Fastload, TPT, Multiload.
• 5+ years of PowerCenter administration.
• 2+ years of Unix Shell scripting (Bash/Korn).
• Bachelor's or advanced IT/CS/Math degree.

Responsibilities

• Design and implement ETL solutions with Informatica PowerCenter.
• Automate data staging and optimize ETL job scheduling.
• Administer and support ETL environments (dev and prod).
• Perform repository backups and system maintenance.
• Develop mappings, sessions, and workflows with Informatica.
• Write complex SQL and Unix scripts for Teradata data marts.
• Collaborate with stakeholders to document solutions.
• Provide mentoring and guidance to team members.

Skills

Informatica PowerCenter

Teradata

SQL

Unix Shell scripting

Python/R/JavaScript

Communication skills

Mentoring

Education

IT/CS/Math degree

Tools

Informatica PowerCenter

Teradata utilities (Fastload, TPT, Multiload)

ERWIN

Azure Data Factory

Snowflake

Job description

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC in Springfield, IL seeks an Informatica PowerCenter Developer with Teradata experience. The role emphasizes ETL design, performance tuning, and healthcare data integrations. Remote work options exist with a strong W2 requirement and 10+ years of experience.

Candidates should have PowerCenter administration experience, Unix scripting, and proficiency with SQL, Teradata utilities, and related tools. H1b transfer is acceptable.