Informatica powercenter with Teradata Job at CLOUDSCOUTS SOFTWARE SOLUTIONS LLC, Topeka, KS

V2dKMDM1WkJqQUJHbS9oUHp0MGpiL1lIeHc9PQ==
  • CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
  • Topeka, KS

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.
• 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.

Job Tags

H1b, Remote work,

Similar Jobs

Availa Bank

Bank Interactive Teller Machine (ITM) Associate Job at Availa Bank

 ...candidates at the right time and price. Streamline your federal contractor compliance requirements with automated posting to state job banks, comprehensive reporting, and documentation to meet OFCCP obligations. OFCCP Compliance Tools Streamline your federal... 

Inside Higher Ed

Assistant, Associate, or Professor in Criminal Justice Job at Inside Higher Ed

 ...Track Status Tenure Track Required Education: PhD in Criminal Justice, Sociology, Social Work or related field (ABD will be considered...  ...and private criminal justice focused agencies/organizations/associations. Job Summary THE UNIVERSITY OF KENTUCKY ,... 

Resource Options, Inc.

Recruiter Job at Resource Options, Inc.

Job Description The ideal candidate will be comfortable meeting new people frequently and have an ability to determine a candidate's potential through clever questions. They should have excellent organizational skills in order to build and maintain a pipeline of prospective...

Palm Beach County Public Defender / 15th Circuit

Certified Legal Intern Job at Palm Beach County Public Defender / 15th Circuit

 ...Defense; Appeals; and Investigative & Social Services Units. Recruiting Academic Year 2025-2026 and Summer 2026 Certified Legal Intern Volunteers: Students enrolled in a credit-bearing law school practice program, or who have already participated as a CLI in such... 

Buck Institute

Senior Bioinformatics and Data Scientist Furman lab Job at Buck Institute

 ...POSITION SUMMARY We are seeking a full-time Senior Bioinformatics and Data Scientist to join our team at the Buck Institute for Research on Aging to work on projects in academia with a close-knit team, collaborate with experts in the field of aging, and participate...