Datawarehouse Consultant with(Teradata)

Posted 15 Days Ago
Be an Early Applicant
Rosemead, CA, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Design and implement Teradata data-warehouse solutions: elicit requirements, create logical/physical designs, develop SQL (views, stored procedures, macros), use Teradata utilities (TPT, TPump, BTEQ, FastLoad/FastExport, MultiLoad), optimize performance for large data volumes, write Unix shell scripts, and work with ETL tools (DataStage/Talend).
Summary Generated by Built In
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.

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

Skills Required

  • Requirement elicitation and analysis skills
  • Translate requirements into design
  • Teradata concepts and logical/physical database design
  • 2 years experience with Teradata utilities (TPT, TPump, BTEQ, FastLoad, FastExport, MultiLoad)
  • Performance tuning and optimization for large-volume Teradata processing
  • SQL programming (views, stored procedures, macros, functions)
  • 2 years Unix Shell scripting experience
  • Experience with ETL tools such as DataStage or Talend
  • BI/Data Warehouse concepts knowledge
  • Excellent communication skills
  • Bachelor's degree or equivalent experience (4 years IT experience minimum)
  • Authorization to work in the US without sponsorship (US Citizen, Green Card, GC-EAD, H4-EAD, L2-EAD)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
87 Employees
Year Founded: 2007

What We Do

SonSoft Inc. is a global consulting and IT services firm specializing in software development, software consultancy, and Information Technology Enabled Services (ITES). The company provides a range of expertise including business consulting, systems integration, application development, and product engineering, helping clients re-engineer and re-invent their businesses to compete in a changing marketplace.

Similar Jobs

WorkWhile Logo WorkWhile

Senior Software Engineer

Artificial Intelligence • HR Tech • Information Technology • Machine Learning • Software • App development • Industrial
Hybrid
4 Locations
100 Employees
150K-200K Annually

Toast Logo Toast

Senior Software Engineer

Cloud • Fintech • Food • Information Technology • Software • Hospitality
Hybrid
Costa Mesa, CA, USA
5000 Employees
138K-221K Annually

Toast Logo Toast

Finance Manager

Cloud • Fintech • Food • Information Technology • Software • Hospitality
In-Office
San Francisco, CA, USA
5000 Employees
143K-229K Annually

BlackRock Logo BlackRock

Director, Head of US ETF Platform

Fintech • Information Technology • Financial Services
In-Office
San Francisco, CA, USA
25000 Employees
200K-270K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account