CS

Informatica powercenter with Teradata

CLOUDSCOUTS SOFTWARE SOLUTIONS LLC H-1B Information Technology Full-timeSpringfield, IL
Posted Nov 3, 2026 · Expires Nov 24, 2026

Quick facts

Type
Full-time
Location
Springfield, IL
Background
Bachelor's degree
Experience
7+ years
Skills
Python, JavaScript, SQL, React
Industry
Information Technology — 1359 open jobs
Visa in listing
H-1B
Apply
Free to apply — never pay anyone for a job offer or visa sponsorship

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.

About CLOUDSCOUTS SOFTWARE SOLUTIONS LLC

Company Profile

Modal Window

Visa sponsorship record: Cloudscouts Software Solutions LLC

Sponsors actively
23H-1B labor applications (LCA)100% certified
15H-1B petitions approved by USCISapproval rate 94% · 15 new
0Green card filings (PERM)no filings found
$113kMedian H-1B salaryfrom LCA filings
Fiscal yearH-1B LCAsUSCIS approvalsUSCIS denialsPERM
FY202619131—
FY2025420—

Roles they sponsor most

  • software developer20 LCAs · median $113k
  • data engineer2 LCAs · median $102k
  • data scientist1 LCA · median $84k

Full sponsorship history of Cloudscouts Software Solutions LLC →

Which visas can work for this job

  • Mentioned in the listing

    H-1B

  • H-1B cap-exempt employer

    Regular cap-subject employer — a new H-1B needs to win the lottery in March (unless you already hold cap-counted H-1B status).

  • O-1 (extraordinary ability)

    For candidates with awards, publications, press, a high salary or critical roles at distinguished organizations. No cap, no lottery; the employer files a petition.

Sources: U.S. Department of Labor OFLC disclosure data (H-1B/H-1B1/E-3 LCA, PERM), OFLC prevailing wage data, USCIS H-1B Employer Data Hub, E-Verify participating employers. Data loaded: LCA FY2024–FY2026, PERM, USCIS Data Hub, OFLC wages; updated 2026-10-03. Employers are matched by name, so records of companies with similar names can occasionally be mixed up. This is general information, not legal advice — talk to an immigration attorney about your case.

Get new Information Technology jobs by emailOne email a day, only when there are new jobs. Unsubscribe in one click.