Share this Job

Software Development Specialist - SAS and Teradata Bteq Developer

Apply now »

Date: Sep 3, 2021

Location: Plano, TX, US

Company: NTT DATA Services

Req ID: 138213 

NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Software Development Specialist - SAS and Teradata Bteq Developer to join our team in Plano, Texas (US-TX), United States (US).

Join an enterprise data warehouse team environment with focus on customer-centricity, quality, forever learning and teamwork. The Software Development Specialist - SAS and Teradata Bteg Developer Opportunity will encompass all of the following: SAS Programmer / SAS DI Consultant / BTEQ Developer. If you enjoy all of these values and can work completely remote, this could be a position for you!

 

  • Should have sound Working knowledge with BASE & Advanced SAS using SAS 9.4, SAS MACROS and Stored Procedures.
  • Strong SAS analytics and programming skills.
  • Experience with developing, analyzing and manipulating large SAS datasets.
  • Be proficient in Base SAS programming (DATA step), SQL programming (i.e., use of SQL pass-through or PROC SQL), as well as the SAS Macro language for use in making code more efficient and format libraries.
  • Knowledge of SAS best practices to write optimized and efficient codes to minimize runtime.
  • Should have sound working knowledge with TERADATA SQL/utilities.
  • Must have strong technical and problem solving skills.
  • Strong written and verbal communication skills. 
  • SAS Programming expertise on Base SAS, Macro, SAS EG and SAS DI.
  • Proven expertise in data integration and ETL tools like SAS DI Studio etc.
  • Should have expertise in application of various transformations in SAS DI Studio.
  • SAS DI Studio- Job Creation, Job Scheduling/debugging etc.
  • Awareness of dimensional modelling, Star Schemas, Data Marts.
  • Sourcing data from various systems and in multiple formats using SAS Code, SQL, ETLs.
  • Strong experience in Data Validation, Data Quality and Error handling.
  • Experience in Type I, Type II handling in ETL.
  • Should have experience in Data Handling through various Databases such as Oracle, SQL Server, Teradata etc.
  • Ability to translate business rules into programming logic.
  • Experience over SAS BI platform and UNIX Operating System will be added advantage.
  • Should have working experience on Teradata and Teradata is the primary skill with utilities mentioned.
  • Experience working on Teradata Utilities such as MLOAD, FLOAD etc.
  • Should have good experience in writing Teradata BTEQ Scripts
  • Expertise in writing complex SQL queries using multiple joins, aggregated functions, arithmetic functions.
  • Performance tuning including collecting statistics, analyzing explains
  • Experience of Optimizing Teradata SQL
  • Experience in creating scripts using UNIX shell scripting to execute Teradata utilities.
  • Good analytical and resolution skills
  • Excellent verbal and written communication and interpersonal skills
  • Ability to work independently and within a team environment

 

Basic Qualifications:

  • Minimum 5 years of SAS experience developing, configuring, and administering SAS solutions.
  • Minimum 5 years of experience as a SAS DI developer
  • Minimum 5 years Data and Intelligence - Data Warehouse - Teradata
  • Minimum 5 years in Application Management - Development

 

About NTT DATA Services

NTT DATA Services is a global business and IT services provider specializing in digital, cloud and automation across a comprehensive portfolio of consulting, applications, infrastructure and business process services. We are part of the NTT family of companies, a partner to 85 % of the Fortune 100.

NTT DATA Services is an equal opportunity employer and will consider all qualified applicants for employment without regard to race, gender, disability, age, veteran-status, sexual orientation, gender identity, or any other class protected by law.


Nearest Major Market: Plano
Nearest Secondary Market: Dallas

Job Segment: Developer, Business Intelligence, Data Warehouse, Consulting, Database, Technology