> Markdown version of [/jobs/ext/2002088-informatica-powercenter-with-teradata](https://www.wearedevelopers.com/jobs/ext/2002088-informatica-powercenter-with-teradata). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Informatica powercenter with Teradata

- **Company:** CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
- **Location:** Topeka, KS, United States (Remote available)
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** JavaScript (Programming Language), Agile Methodology, Bash Shell, Data Integration, Extract Transform Load (ETL), Data Mart, Data Warehousing, Job Scheduling, Python (Programming Language), Korn Shell, Unix Shell, Metadata, Performance Tuning, Standard Sql, System Testing, Teradata SQL, Scripting, Freeform SQL, Azure Data Factory, Informatica Powercenter, ReactJS, Snowflake, Information Technology
- **Published:** August 9, 2026
- **Apply:** https://www.wayup.com/i-j-Informatica-powercenter-with-Teradata-CLOUDSCOUTS-SOFTWARE-SOLUTIONS-LLC-333526672369970/

## About the Role

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.

## Description

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


## Related Videos

- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [JavaScript? No. Java Scripts! - Scripting with Java](https://www.wearedevelopers.com/videos/2094-javascript-no-java-scripts-scripting-with-java)
- [Watch Tests Go Brrrr! : Getting Started with Cypress in ReactJS](https://www.wearedevelopers.com/videos/282-watch-tests-go-brrrr-getting-started-with-cypress-in-reactjs)
- [A Data Mesh needs Open Metadata](https://www.wearedevelopers.com/videos/505-a-data-mesh-needs-open-metadata)
- [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers)
- [Intermediate Bitcoin Script](https://www.wearedevelopers.com/videos/25-intermediate-bitcoin-script)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Best Coding Boot Camps in Germany](https://www.wearedevelopers.com/magazine/237-best-coding-boot-camps-in-germany)
- [The 8 Best Code Testing Tools](https://www.wearedevelopers.com/magazine/402-the-8-best-code-testing-tools)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)