Teradata with ETL Informatica Architect

Reposted An Hour Ago
Be an Early Applicant
Charlotte, NC, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Architect and design Teradata-based ETL frameworks using Unix and Informatica; automate ETL development, write SQL and shell scripts, performance-tune large-volume data processes, and coordinate stakeholders and project timelines.
Summary Generated by Built In
Company Description

Sonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

Job Description

  • Strong Requirement Elicitation & Analysis skills
  • Should have the capability to understand requirements and convert to design
  • Should have capability to architect and design ETL frameworks using Unix and Teradata
  • Should have capability to automate the ETL development using ETL framework
  • 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 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(atleast 6 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

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

Additional Information

** U.S. citizens and those who are authorized to work independently in the United States are encourage to apply. We are unable to sponsor at this time.

Note:-

  1. This is a Fulltime & Permanent job opportunity.
  2. Only US CitizenGreen Card HolderGC-EADH4-EAD & L2-EAD can apply.
  3. No OPT-EAD, H1B and TN Visa candidates please.
  4. Please mention your Immigration Status while applying .
  5. All your information will be kept confidential according to EEO guidelines.

Skills Required

  • Bachelor's degree (or equivalent experience)
  • At least 7 years of experience in Information Technology
  • Strong requirement elicitation and analysis skills
  • Ability to convert requirements into design and architecture
  • Architect and design ETL frameworks using Unix and Teradata
  • Automate ETL development using ETL frameworks
  • Coordinate with SMEs and stakeholders, manage timelines and escalations (project management)
  • Good knowledge of Teradata concepts and logical/physical database design
  • At least 5 years experience with Teradata utilities (TPT, TPump, BTEQ, FastLoad, FastExport, MultiLoad)
  • In-depth performance tuning and optimization for large-volume data in Teradata
  • SQL programming experience (views, stored procedures, macros, functions)
  • At least 6 years experience in Unix shell scripting (writing shell scripts is a must)
  • Experience with Informatica ETL tool
  • Good knowledge of BI/DW concepts
  • Excellent communication skills
  • Authorized to work in the U.S. 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

SonSoft Inc. Logo SonSoft Inc.

Architect

Information Technology • Professional Services • Software • Consulting
In-Office
Charlotte, NC, USA
87 Employees
Easy Apply
Remote or Hybrid
USA
208 Employees
16K-200K Annually

Cox Enterprises Logo Cox Enterprises

Customer Care Specialist II (Manheim)

Artificial Intelligence • Automotive • Greentech • Information Technology • Machine Learning • Software • Cybersecurity
Hybrid
Statesville, NC, USA
50000 Employees
18-27 Hourly

CrowdStrike Logo CrowdStrike

Staff Engineer

Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Remote or Hybrid
USA
11000 Employees
195K-290K 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