Gather and analyze requirements, convert them into designs, coordinate with SMEs and stakeholders, manage timelines and escalations. Design and optimize Teradata logical/physical schemas, use Teradata utilities (TPT, TPump, BTEQ, FastLoad, FastExport, MultiLoad), tune performance for large datasets, develop SQL objects, and write Unix shell scripts. BI/DW and Big Data experience is a plus.
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.
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
- 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.
- Good knowledge and experience on Big Data related technologies is a plus
- 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 authorized to work in the U.S. are encouraged to apply. We are unable to sponsor at this time.
Note:-
- This is a Fulltime job for you
- Only US Citizen, Green Card Holder, TN Visa, H4-EAD, GC-EAD & L2-EAD can apply.
- No OPT-EAD Consultants please.
- Please mention your Visa Status in your email or resume.
- please mention your visa status
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Elicit and analyze requirements, convert to logical/physical designs, coordinate stakeholders, and implement high-volume Teradata solutions. Develop SQL objects, use Teradata utilities, perform performance tuning, and write Unix shell scripts. Support BI/DW processes and collaborate across teams for on-time delivery.
Top Skills:
Bi/DwBig DataBteqFastexportFastloadFunctionsMacrosMultiloadSQLStored ProceduresTeradataTptTpumpUnix Shell Scripting
Information Technology • Professional Services • Software • Consulting
Lead Teradata consultant responsible for requirements analysis, converting requirements to design, coordinating stakeholders, Teradata logical/physical design, performance tuning, SQL development (views/procs/macros/functions), using Teradata utilities (TPT/TPump/BTEQ/FastLoad/FastExport/MultiLoad), Unix shell scripting, and BI/DW support. Strong communication and project management skills required.
Top Skills:
Bi/DwBig DataBteqFastexportFastloadMultiloadSQLTeradataTptTpumpUnix Shell Scripting
Information Technology • Professional Services • Software • Consulting
Elicit and analyze requirements, convert them to technical designs, coordinate stakeholders and manage timelines. Design and optimize Teradata logical/physical schemas, use Teradata utilities for data loads, perform SQL development and performance tuning, write Unix shell scripts, and apply BI/DW and Big Data knowledge. Communicate status and escalate issues.
Top Skills:
Bi/DwBig DataBteqFastexportFastloadFunctionsMacrosMultiloadSQLStored ProceduresTeradataTptTpumpUnix Shell Scripting
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
