Talent.com
CLOUDSCOUTS SOFTWARE SOLUTIONS LLC
Informatica powercenter with TeradataCLOUDSCOUTS SOFTWARE SOLUTIONS LLC • Springfield, IL, US
Informatica powercenter with Teradata

Informatica powercenter with Teradata

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC • Springfield, IL, US
30+ days ago
Job type
  • Part-time
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.

Create a job alert for this search

Informatica powercenter with Teradata • Springfield, IL, US

Similar jobs

Cloud & Infrastructure Architect — Remote

HSHS Medical GroupSpringfield, IL, United States
Remote
Full-time

A leading healthcare organization is seeking an IT Infrastructure & Cloud Architect for remote work.This role involves designing enterprise-scale IT solutions while ensuring performance, security, ... Show more

 • Promoted

Clinical Data Manager II - Drive Data Quality & Rave

CytelSpringfield, Illinois, United States
Full-time

Cytel is seeking a Clinical Data Manager II in Springfield, Illinois, to provide data management support for clinical studies.The ideal candidate will have a Bachelor's degree in Life Sciences and ... Show more

 • Promoted

Data Center Technician United States Onsite

RM Staffing B.V.Springfield, IL, US
Full-time +1

This is a full-time, on-site position where you'll support critical infrastructure at world-class data center facilities.Comprehensive benefits package including:.Health, dental, and vision insuran... Show more

Information Technology Professional

US NavySpaulding, IL, US
Full-time

Information Technology Professional (IT/CTN/IS).Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specialists keep the Fleet connected, informed, and secure by oper... Show more

 • Promoted

Senior Business Intelligence Engineer – Conversational Channels

HumanaSpringfield, IL, United States
Full-time

Become a part of our caring community.At Humana, we’re committed to helping people achieve lifelong well‑being—and that starts with using data and technology to create smarter, more connected exper... Show more

 • Promoted

Head of Software Engineering (Remote) — Scale High-Impact Platforms

Capital OneSpringfield, IL, United States
Remote
Full-time

A leading financial services company seeks a Director of Software Engineering to lead teams in developing innovative solutions.The ideal candidate will have extensive software development experienc... Show more

 • Promoted

Remote Decision Intelligence Engineer - Next Best Action (RL)

Humana IncSpringfield, IL, United States
Remote
Full-time

A leading healthcare company in Illinois seeks a Decision Intelligence Engineer to design and implement reinforcement learning algorithms for a new platform.You will collaborate closely with engine... Show more

 • Promoted

Data Engineer – Databricks & Talend (Healthcare ETL, Remote)

CognizantSpringfield, IL, United States
Remote
Full-time

A leading technology company is seeking a Data Engineer to design and deliver scalable data integration solutions.This remote role involves building and optimizing data pipelines using Databricks, ... Show more

 • Promoted

Remote Senior SDDC Solutions Consultant (VMware)

SHISpringfield, IL, United States
Remote
Full-time

A leading global IT provider is seeking a Senior Solutions Consultant to support post-sales implementation of data center infrastructure automation initiatives.Responsibilities include designing an... Show more

 • Promoted

Senior AWS Data Architect: Spark & Glue ETL Mastery

CognizantSpringfield, IL, United States
Full-time

Cognizant is seeking an expert in data process optimization who can leverage AWS DevOps, AWS Glue Studio, and Apache Spark.The successful candidate will be responsible for designing efficient ETL w... Show more

 • Promoted

Clinical Data Manager II

CytelSpringfield, Illinois, United States
Temporary

The Clinical Data Manager II (CDM) will provide comprehensive data management support for assigned clinical studies.The CDM will be responsible for performing ongoing data review to ensure accuracy... Show more

 • Promoted

Information Systems Technician

U.S. NavySherman, IL, United States
Full-time

Job Title : Information Technology Professional (IT/CTN/IS) Category / Component : Enlisted • Both Overview Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specia... Show more

 • Promoted

SAP S/4HANA System Architect

AmpstekSpringfield, IL, United States
Full-time

Qualifications and Technical Skills.Strong understanding of S/4HANA system architecture and simplification items.Experience evaluating migration paths (Brownfield/System Conversion, Selective Data ... Show more

 • Promoted

Senior Data Center Network Architect - Onsite/Hybrid

DistroSpringfield, IL, United States
Full-time

A technology company in Springfield, Illinois is seeking a Senior Data Center Network Engineer for a contract engagement.This role requires designing and supporting large-scale data center network ... Show more

 • Promoted

Remote VP, Strategic Accounts — Real-World Data

NorstellaSpringfield, IL, United States
Remote
Full-time

A leading life sciences company seeks a VP of Strategic Accounts to enhance its RWD solutions for clients.With a strong focus on strategic sales, the role demands over 10 years of experience in bus... Show more

 • Promoted

Senior Lead Teradata Database Administrator (DBA)

Gilder Search GroupSpringfield, IL, United States
Full-time

Manage, monitor, and maintain OnPrem Teradata hardware/software including patches, replacements, and upgrades with support from Teradata.Support data governance, metadata management, and system adm... Show more

 • Promoted • New!

IT Professional

U.S. NavyChatham, IL, United States
Full-time

Job Title : Information Technology Professional (IT/CTN/IS) Category / Component : Enlisted • Both Overview Information Systems Technicians, Cryptologic Technician Networks, and Intelligence Specia... Show more

 • Promoted

Senior Marketing Data Platform Architect

AcxiomSpringfield, IL, United States
Full-time

A leading data analytics firm is looking for a highly experienced Principal Solution Architect to join their Data & AI Consulting practice.This role focuses on marketing transformation programs and... Show more