Teradata Consultant with ((Informatica)

Posted 7 Days Ago
Be an Early Applicant
St. Louis, MO, USA
In-Office
Mid level
Information Technology • Professional Services • Software • Consulting
The Role
Elicit and analyze requirements, convert to DW/ETL design, develop and optimize Teradata ETL using utilities, write SQL and Unix shell scripts, work with Informatica, ensure performance tuning for large data volumes, and coordinate stakeholders with clear communication.
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

  • Requirement elicitation and analysis
  • Convert requirements into design (logical/physical database design)
  • Coordinate with SMEs and stakeholders; manage timelines and escalate issues (project management)
  • Strong knowledge of Teradata concepts and logical/physical database design
  • At least 2 years experience with Teradata utilities: TPT, TPump, BTEQ, FastLoad, FastExport, MultiLoad
  • Performance tuning and optimization for large-volume data in Teradata
  • SQL programming: views, stored procedures, macros, functions
  • At least 2 years Unix Shell Scripting experience
  • Experience with Informatica ETL tool
  • Good knowledge of BI/DW concepts
  • Excellent communication skills
  • Bachelor's degree or equivalent (or progressive experience in lieu)
  • At least 4 years of IT experience
  • Must be authorized to work in the U.S.; employer cannot sponsor visas (US Citizen, Green Card, GC-EAD, H4-EAD, L2-EAD eligible)
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

Boeing Logo Boeing

Team Lead

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Hybrid
Maryland Heights, MO, USA
170000 Employees
70K-90K Annually

Boeing Logo Boeing

Financial Analyst

Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
In-Office
Hazelwood, MO, USA
170000 Employees
74K-100K 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