Teradata Consultant with ((Informatica)

Sonsoft Inc

Apply to this job
St. Louis, MO, us on site Until 8/21/2026 H-1B sponsor history First posted February 24, 2026 Last posted February 24, 2026
Job description

SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Preferred

Strong Requirement Elicitation & Analysis skills

Should have the capability to understand requirements and convert to design

Ability to coordinate with SMEs, stakeholders, manage timelines, escalation & provide on time status – strong project management skills as well.

Good knowledge in Teradata concepts and Logical/physical database design

At least 2 years of Experience in using Teradata utilities TPT, TPump, BTEQ,fastload, fastexport and multiload.

In-depth knowledge of Performance tuning and optimization to handle and process large volume of data in Teradata

Experience in SQL programming (views/store procedures/macros/functions) based on User requirements and architectural guidelines and standards.

Strong experience(at least 2 years) in Unix Shell Scripting

Experience in Informatica ETL tool.

Good knowledge of BI/DW concepts

In-depth knowledge of Performance tuning and optimization to handle and process large volume of data in Teradata

Experience in SQL programming (views/store procedures/macros/functions) based on User requirements and architectural guidelines and standards.

Experience in writing Unix Shell scripting is a must

Excellent Communication Skills

Qualifications Basic
• Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
• At least 4 years of experience with Information Technology.

** U.S. Citizens and those who are authorized to work independently in the United States are encouraged to apply. We are unable to sponsor at this time.
Note:-
1. This is a Full-Time & Permanent job opportunity for you.
2. Only US Citizen, Green Card Holder, GC-EAD, H4-EAD & L2-EAD can apply.
3. No OPT-EAD, H1B & TN candidates please.
4. Please mention your Visa Status in your email or resume.

About this role

Summary

Manage teradata systems, optimize performance, develop ETL processes, coordinate projects, and analyze requirements.

Job title

Teradata Consultant with Informatica

Experience level

4+ years

Industry

software

Location requirements

St. Louis, MO, US, on-site; remote not specified

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

teradataETLsqlunix shell scriptinginformaticaperformance tuningdatabase designrequirements analysiscommunication

Preferred skills

project managementrequirements elicitationbi/dw concepts

Specializations

teradataETLsqlunix shell scriptinginformatica
Locations

Structured locations inferred from the posting.

St. Louis, MO, USA

On-site City