Informatica powercenter with Teradata

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.

This is a remote position.