SonSoft Inc. Logo

SonSoft Inc.

Teradata

Reposted 3 Months Ago
Be an Early Applicant
In-Office
Charlotte, NC, USA
Mid level
In-Office
Charlotte, NC, USA
Mid level
Design, develop and support Teradata data-warehouse solutions: write complex SQL and UNIX scripts, create BTEQ and load-utility scripts (FastExport, FastLoad, MultiLoad, TPUMP, TPT), perform query tuning and statistics management, implement DDL and indexing strategies, troubleshoot data issues, and collaborate in a global financial-domain delivery team. Teradata certification required.
The summary above was generated by AI
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

  • Minimum of 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
  • Certification in Teradata.
  • Good Analytical skills
  • High impact communication
  • Ability to ramp up in new technologies
  • Ability to work in a team, in diverse/ multiple stakeholder environment.
  • Experience and desire to work in a Global delivery environment
  • Experience to Financial domain.
  • Analytical 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 4 years of experience within the Information Technologies.

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.

This is a Full-Time / Permanent job opportunity.

• ••

• Only US Citizen, Green Card Holder

H4-EAD, GC-EAD & L2-EAD 

can apply.

.

** All your information will be kept confidential according to EEO guidelines.

Similar Jobs

Yesterday
Hybrid
Mooresville, NC, USA
Senior level
Senior level
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
The Senior Financial Analyst supports forecasting, annual and long-range planning, performance reporting, financial modeling, expense planning, and business analytics. The role develops business cases, analyzes financial and operational data, performs root-cause analysis, communicates insights to leaders, manages forecast accuracy, identifies risks, and recommends improvements. It partners cross-functionally with supply chain and business stakeholders to support strategic initiatives and operational decision-making.
Top Skills: AdobeAlteryxBusiness ObjectsCognosErpEssbaseHadoopHyperionKnimeMicrostrategyPower BIPrestoPythonQlikRSASSQLSsisSupersetTableauTeradataTm1
8 Days Ago
Hybrid
Mooresville, NC, USA
Senior level
Senior level
Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
The Senior Financial Analyst supports forecasting, annual and long-range planning, expense planning, financial modeling, performance reporting, and business case development. The role analyzes financial and operational data, performs root-cause analysis, provides actionable insights to business partners and leaders, and identifies risks, trends, and improvement opportunities. Success requires cross-functional collaboration, financial storytelling, report automation, and the ability to influence stakeholders in a matrixed organization.
Top Skills: AdobeAlteryxBusiness ObjectsCognosErpEssbaseHadoopHyperionKnimeMicrostrategyPower BIPrestoPythonQlikRSASSQLSsisSupersetTableauTeradataTm1
Yesterday
In-Office
Charlotte, NC, USA
135K-163K Annually
Senior level
135K-163K Annually
Senior level
Big Data • Fintech • Mobile • Payments • Financial Services • Data Privacy
Leads quantitative analytics for consumer and small-business products, transforming large datasets into insights, forecasts, performance metrics, and recommendations. Applies statistical and machine-learning methods to customer journeys, product performance, revenue, profitability, and retention. Develops and maintains governed data products, makes data AI-ready through metadata and semantic definitions, communicates findings to senior stakeholders, leads cross-functional initiatives, and mentors junior analysts.
Top Skills: Github CopilotHadoopHiveMicrosoft 365 CopilotPowerPointPythonScalaSparkSQLStarburstTeradata

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account