Informatica powercenter with Teradata
Company: CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
Location: Topeka
Posted on: February 14, 2026
|
|
|
Job Description:
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. Bachelors 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.
Keywords: CLOUDSCOUTS SOFTWARE SOLUTIONS LLC, Kansas City , Informatica powercenter with Teradata, IT / Software / Systems , Topeka, Kansas
