Sonsoft
Fintech & PaymentsDirect SmartRecruiters career site

Datastage Consultant

Location
Charlotte, NC · On-site
Work authorization
US citizens or permanent residents only
Job type
Full-time
Level
Senior
Experience
4+ years
Education
Bachelor's degree
Listed
Yesterday

Skills & highlights for this role

  • Teradata certification
  • Teradata
  • BTEQ
  • Teradata utilities (FastLoad, MultiLoad, TPT)
  • query tuning
  • data warehouse modeling

Also useful

  • UNIX scripting
Free · No account needed

How well does your resume fit this job?

Upload your resume to see your score for this Sonsoft role, what matches, what's missing, and your best other matches.

Scored on our server and not saved there. The file stays in this browser so you don't have to upload it again after you sign up.

About the role

  • At least 4 years of experience in software development life cycle stages
  • Certification in Teradata.
  • At least 4 years of experience in Project life cycle activities on development and maintenance projects
  • At least 2 years of experience in Design and Architecture review
  • At least 2 years of experience in application support and maintenance (including some experience on-call support)
  • Ability to ramp up in new technologies
  • Ability to work in a team, in diverse/ multiple stakeholder environment.
  • High impact communication
  • Ability to ramp up in new technologies
  • Experience in Financial domain
  • Strong analytical skills
  • Experience and desire to work in a Global delivery environment

Basic Qualification

  • 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 work experience in Information Technology
  • At least 4 years of hands on Teradata experience
  • Experience in full software development lifecycle of the Data Warehousing Project
  • Strong knowledge of Teradata Architecture: Nodes (AMP &PE), VProcs, BYNETS
  • Efficient usage of Teradata DDL Statements – Derived Tables, Volatile Tables and Global Temporary Tables
  • Hands on Knowledge on Teradata Concepts – Primary Index, Partitioned Primary Index, Secondary Index, Join Index and Compression Techniques
  • Understand the Concept of Locking Mechanisms in Teradata
  • Experience on Query Tuning mechanisms using indexes & proper usage of Statistics in Teradata
  • Efficient in Writing SQL’s with complex joins,aggregations, UNIX Scripts,
  • Good understanding of Data Warehouse Modeling concepts
  • Experience in using the built in Teradata Functions
  • Efficient in writing Dynamic SQL’s,creating a BTEQ Scripts and executing the scripts.
  • Hands on experience on creating scripts for Load Utilities Fast export, Fast Load, Multi Load, TPUMP and TPT for exporting and loading the data
  • Responsible for writing efficient views based on user and reporting requirements
  • Must be able to provide Solutions or Enhancements to fix the data issues quickly when reported by the clients or users
  • Flexibility to Self learn and understand the system, further assist with query tuning and application performance.

Additional Information

  • U.S. citizens and those authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.

Note

  • This is a Full-Time Permanent job opportunity for you.
  • Only US Citizen, Green Card Holder, TN Visa, GC-EAD, H4-EAD & L2-EAD can apply.
  • No OPT-EAD & H1B Consultants please.
  • Please mention your Visa Status in your email or resume.

About the Company

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.

Read the original posting

From Sonsoft's careers page, first listed on Rolev.ai on November 20, 2026. Rolev.ai is not the employer.

How Rolev.ai helps with this application

Rolev.ai is a job search and application tool for US job seekers. For this Datastage Consultant role at Sonsoft, it shows how your resume fits, tailors your resume to the posting, and prepares the application for you to review.

  • See how you fit

    Openings from employer career sites are ranked against your whole resume—and searchable inside Claude, ChatGPT, and Cursor via Rolev.ai MCP.

  • Tailor without inventing

    Every change to your resume is checked against your original. New experience goes in only with your yes—zero fabricated claims.

  • Draft the full kit

    Tailored and Full Match resumes, role-specific cover letters, and answers to employer screening questions are prepared in seconds.

  • 1-Click Extension Autofill

    The Chrome extension fills the employer's Greenhouse, Workday, Lever, or Ashby form in 1 click. You review it and press Submit.

Common questions

Where is the Datastage Consultant job at Sonsoft located?

This Datastage Consultant position at Sonsoft is located in Charlotte, NC (On-site). Always check Sonsoft's application page for specific state eligibility or relocation policies.

What qualifications are required for Datastage Consultant at Sonsoft?

For the Datastage Consultant role, Sonsoft highlights 4+ years of relevant experience; a bachelor's degree; experience with Teradata, BTEQ, Teradata utilities (FastLoad, MultiLoad, TPT), query tuning, data warehouse modeling. Rolev.ai can score your existing resume against these requirements and show any skill gaps before you apply.

How do I apply for the Datastage Consultant position at Sonsoft?

This listing links directly to Sonsoft's SmartRecruiters application page. You can apply directly on Sonsoft's site, or use Rolev.ai to check your resume fit, generate a zero-hallucination tailored resume and cover letter for this posting, and autofill the SmartRecruiters application form in 1 click with the Rolev.ai Chrome extension. You always review the form and press Submit yourself.