Teradata with ETL (DataStage/Talend)

Sonsoft Inc

Apply to this job
Rosemead, CA, 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.

  • Strong Requirement Elicitation & Analysis skills
  • Should have the capability to understand requirements and convert to design
  • Good knowledge in Teradata concepts and Logical/physical database design
  • At least 5 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 3 years) in Unix Shell Scripting
  • Experience in ETL tool like DataStage or Talend or both.
  • 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
  • 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 authorized to work in the U.S. 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, TN Visa, GC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD & H1B Consultants please.
  4. Please mention your Visa Status in your email or resume.
About this role

Summary

Design, optimize, and implement data warehousing solutions using Teradata and ETL tools.

Job title

Teradata with ETL (DataStage/Talend)

Experience level

5+ years

Industry

software

Location requirements

Rosemead, CA, on-site, US citizens only

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

teradatautility tools (TPT, TPump, BTEQ, fastload, fastexport, multiload)sql programmingunix shell scriptingETL tools (DataStage or Talend)data warehousing

Preferred skills

None specified

Specializations

teradataETLsqlunix shell scriptingperformance tuning
Locations

Structured locations inferred from the posting.

Rosemead, CA, USA

On-site City