Informatica powercenter with Teradata CLOUDSCOUTS SOFTWARE SOLUTIONS LLC

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

Informatica powercenter with Teradata Overview

Company Name CLOUDSCOUTS SOFTWARE SOLUTIONS LLC

Job Role Informatica powercenter with Teradata

Qualifications Not specified

Category I

Job Type Full Time

Location Springfield, IL, United States

Job Description Job Description Remote : Informatica powercenter developer with Teradata exp.
Most recent project must be Healthcare
10+ years and W2 role

H1b transfer is fine

H4 EAD,GC,USC

Required Qualifications:

• 7+ years of experience with Informatica PowerCenter and ETL development.
• 5+ years of experience writing complex SQL and performance tuning.
• 5+ years of experience with Teradata (v17+), including Fastload, TPT, and Multiload utilities.
• 5+ years of Informatica PowerCenter administration experience.
• 2+ years of Unix Shell (Bash/Korn) scripting experience.
• Strong communication, collaboration, and mentoring skills.
• Bachelor's or advanced degree in IT, Computer Science, Mathematics, or a related field.
• Strong organizational and time management skills.

Preferred Qualifications:

• Residing in or near Springfield, IL.
• 5+ years of data warehouse development experience.
• 5+ years of data modeling experience using ERWIN or similar tools.
• 2+ years of experience with Azure Data Factory and Snowflake.
• Experience with scripting languages such as Python, R, or JavaScript (React).
• Familiarity with Informatica Data Quality (IDQ), Address Doctor, and Metadata Manager.
• Experience with Medicaid, Medicare, or healthcare data systems.
• Experience working in Agile environments.
• Knowledge of BI and data integration technologies across relational and multidimensional systems.

Key Responsibilities:

• Design and implement ETL solutions using Informatica PowerCenter to extract, transform, and load data from various agency sources.
• Automate data staging processes and optimize ETL job scheduling for performance and efficiency.
• Administer and support ETL environments, including development and production systems.
• Perform repository backups, recovery operations, and system maintenance.
• Develop mappings, mapplets, sessions, and workflows using a wide range of Informatica transformations.
• Monitor and troubleshoot ETL jobs across development, testing, and production environments.
• Write and optimize complex SQL queries and Unix Shell scripts for data marts and interfaces in Teradata.
• Collaborate with stakeholders to define requirements, document technical solutions, and support project planning.
• Participate in unit, integration, and system testing.
• Provide technical support, mentoring, and guidance to team members.
• Communicate project status and deliverables to leadership and clients.
• Continuously learn and apply new technologies to enhance system performance and capabilities.

Visa Sponsorship May be