Informatica powercenter with Teradata

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC

Springfield, United States of America

5 days ago

Role details

Contract type

Permanent contract

Employment type

Part-time (≤ 32 hours)

Working hours

Regular working hours

Languages

English

Experience level

Intermediate

Compensation

$ 114K

Job location

Remote

Springfield, United States of America

Tech stack

JavaScript

Agile Methodologies

Bash

Data Integration

ETL

Data Mart

Data Warehousing

Job Scheduling

Python

Korn Shell

Shell

Metadata

Performance Tuning

Standard Sql

System Testing

Teradata

Scripting (Bash/Python/Go/Ruby)

Freeform SQL

Azure

Informatica Powercenter

React

Snowflake

Information Technology

Job description

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.

Requirements

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., * 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