Data Engineer jobs

DataStage Consultant with Teradata

Sonsoft Inc (agency)Rosemead, CAFull-time

Pay not listed

Key facts

Experience
2+ years
Degree
Bachelor's degree
US visa
No US visa sponsorship

2 things to check before you apply.

On Sonsoft Inc’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 10 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listed, though one is likely required in CAAsk for the pay range before you interview. The law here likely requires one.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 55 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Elicit and analyze requirements, then translate them into designs.
  • Design databases and develop SQL objects such as views, stored procedures, macros, and functions.
  • Use ETL tools such as DataStage or Talend and Teradata utilities to process data.
  • Tune and optimize Teradata performance for large data volumes.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • At least 2 years of experience with Information Technology
  • 2 years of experience with Teradata TPT, TPump, BTEQ, FastLoad, FastExport, and MultiLoad (preferred)
  • 2 years of Unix shell scripting experience (preferred)
  • Experience with DataStage or Talend (preferred)

Education

  • Bachelor’s degree or foreign equivalent from an accredited institution, or three years of progressive experience in the specialty in lieu of each year of education

Skills

  • Experience writing Unix shell scripts
  • Strong requirements elicitation and analysis skills (preferred)
  • Ability to understand requirements and convert them to designs (preferred)
  • Good knowledge of Teradata concepts and logical/physical database design (preferred)
  • In-depth Teradata performance tuning and optimization for large data volumes (preferred)
  • SQL programming for views, stored procedures, macros, and functions based on user requirements and architectural guidelines (preferred)
  • Good knowledge of business intelligence and data warehousing concepts (preferred)

Other requirements

  • U.S. citizenship or independent authorization to work in the United States; sponsorship is unavailable

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Sonsoft Inc’s careers site

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

Job Description

Preferred

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

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

Show full descriptionShow less

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 (2 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

Excellent Communication Skills

Qualifications

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 2 years of experience with Information Technology.

Additional Information

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

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Data Engineer

K2 Space · Los Angeles, CA

$120k–$160k/yr

StrongChecked open todayPosted 11 days ago

Data Engineer

ACCO Engineered Systems · Pasadena, CA

$106k–$143k/yr

StrongChecked open todayPosted 1 month ago

W2PE - Engineer

Trace3 · Irvine, CA

$120–$150/hr

StrongChecked open todayPosted 1 month ago

Data Engineer

UJET · Austin, TX +2 places

$140k–$160k/yrHybrid

StrongChecked open todayPosted 1 month ago

Senior Data Engineer

BuildOps · Toronto, CA +2 places

$120k–$197k/yrHybrid

StrongChecked open todayPosted 11 days ago

Lead Data Engineer

ALO · Beverly Hills, CA

$180k–$220k/yr

StrongChecked open todayPosted 16 days ago

See more like this