Teradata Consultant

Posted 6 Days Ago
Be an Early Applicant
St. Louis, MO, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Gather and analyze requirements, convert them into designs, coordinate with stakeholders, and manage timelines. Design logical/physical Teradata databases, use Teradata utilities (TPT, TPump, BTEQ, FastLoad/FastExport/MultiLoad), optimize performance for large data, develop SQL (views, stored procedures, macros, functions), write Unix shell scripts, and work with Informatica ETL within BI/DW environments. Strong communication and project-management skills required.
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

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

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

  • Strong requirement elicitation and analysis skills
  • Ability to convert requirements into design (logical/physical DB design)
  • Project coordination with SMEs and stakeholders, manage timelines and escalation
  • Good knowledge in Teradata concepts and logical/physical database design
  • At least 2 years experience with Teradata utilities: TPT, TPump, BTEQ, FastLoad, FastExport, MultiLoad
  • In-depth knowledge of performance tuning and optimization for large volume Teradata processing
  • Experience in SQL programming (views, stored procedures, macros, functions)
  • Strong experience (at least 2 years) in Unix Shell Scripting
  • Experience with Informatica ETL tool
  • Good knowledge of BI/DW concepts
  • Excellent communication skills
  • Bachelor's degree or equivalent (or three years progressive experience in lieu of each year of education)
  • At least 4 years of experience in Information Technology
  • Must be U.S. Citizen, Green Card Holder, GC-EAD, H4-EAD or L2-EAD (no sponsorship available)
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

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

SonSoft Inc. Logo SonSoft Inc.

Consultant

Information Technology • Professional Services • Software • Consulting
In-Office
St. Louis, MO, USA
87 Employees

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