Lead requirements elicitation and design for data warehouse solutions. Act as client-facing coordinator with SMEs and stakeholders. Design logical/physical DB, optimize and tune Teradata, develop stored procedures, use BTEQ and Teradata utilities for load/export, and create Unix shell scripts. Provide estimations, resource and risk inputs, and work in on-site/offshore model.
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 and provide
- pass the same seamlessly to the team who is working on the same.
- Ability to coordinate with SMEs, stakeholders, manage timelines, escalation & provide on
- time status.
- Good knowledge in DWH concepts and Logical/physical database design
- Extensive knowledge of Teradata database, data warehousing and information
- management best practices.
- Excellent understanding of Teradata architecture. Knowledge of Teradata CLDM will be an
- added advantage
- Hands on experience in performing optimization/tuning activities in Teradata
- Hands on experience in Stored Procedures, Bteq, Teradata utilities for load and export data
- Should come up with the work estimation and should provide inputs to managers on
- resource and risk planning.
- Strong knowledge and hands-on experience on Unix shell scripting
- Excellent interpersonal, organizational, written communication, oral communication and
- listening skills
- Should have played client facing roles
- Must have worked in on-site/offshore model
Qualifications
Basic 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 within the Information Technologies.
** 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, GC-EAD, H4-EAD & L2-EAD can apply.
- No OPT-EAD & H1B Consultants please.
- Please mention your Visa Status in your email or resume.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Lead requirement elicitation and translate requirements into DWH designs. Architect and optimize Teradata environments, perform tuning, develop stored procedures and BTEQ scripts, use Teradata utilities for load/export, write Unix shell scripts, estimate work, coordinate stakeholders/SMEs, manage onshore/offshore delivery, and perform client-facing duties.
Top Skills:
BteqData WarehousingStored ProceduresTeradataTeradata CldmTeradata UtilitiesUnix Shell Scripting
Information Technology • Professional Services • Software • Consulting
Lead Teradata data warehousing design and development: elicit requirements, produce logical/physical designs, optimize and tune Teradata systems, create stored procedures and BTEQ scripts, perform data loads/exports, coordinate SMEs/stakeholders, manage onshore/offshore delivery and client interactions.
Top Skills:
BteqData WarehousingLogical Database DesignPhysical Database DesignStored ProceduresTeradataTeradata CldmTeradata UtilitiesUnix Shell Scripting
Information Technology • Professional Services • Software • Consulting
Lead DWH requirements analysis and design, translate requirements into technical designs, and coordinate with SMEs and stakeholders. Perform Teradata architecture design, optimization/tuning, stored procedures, BTEQ and utilities-based data load/export. Provide estimations, resource and risk inputs, use Unix shell scripting, work client-facing in an on-site/offshore model.
Top Skills:
BteqData WarehousingDwh ConceptsLogical/Physical Database DesignStored ProceduresTeradataTeradata CldmTeradata UtilitiesUnixUnix 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
