SAS DI Studio and Advanced SAS/SQL

Posted 2 Days Ago
Be an Early Applicant
Charlotte, NC, USA
In-Office
Senior level
Information Technology • Professional Services • Software • Consulting
The Role
Design and develop ETL solutions using SAS DI Studio and Base SAS to extract, transform, and load data from heterogeneous sources. Implement SAS DDS banking models, build data models (conceptual, logical, physical), collaborate with developers/DBAs/analysts, document issues/resolutions, optimize performance in Unix/Linux, and support data warehouse/MDM and BI initiatives.
Summary Generated by Built In
Company Description

Inent is a leading provider of information technology, consulting and business process outsourcing services, dedicated to helping the world’s leading companies build stronger businesses. Great organizations demand great IT. To stay on budget, on schedule and maintain high quality standards for IT initiatives, organizations must align with the right service providers—those that can truly improve and enhance the initiatives they support.

  

Job Description

charlotte, NC 

Duration : 6 months plus 

Rate : C2C/W2/1099

SAS DI Studio and Advanced SAS/SQL Programmer 

The individual selected for this role will be experienced in SAS Data Management Studio (DI Studio) and possess strong SQL and SAS skills as well as be well versed in the SDLC lifecycle processes. The scope of ETL design and development includes but is not limited to data extraction from heterogeneous data sources, data transformation (e.g., data cleansing), database loading, and support to meet the needs of the business. Individual should have experience with various databases platforms, including the Netezza. 

Duties and Responsibilities 

Essential Functions: 

 Demonstrates expertise in a variety of the field’s concepts, practices, and procedures related to ETL/Data design and development.• 

 Implementing solutions using the SAS Detail Data Store (DDS) banking model• 

 Develop and recommend strategies and specifications for (technical) data solutions based on the analysis of the business goals, objectives, needs, and existing data systems infrastructure.• 

 Data Modeling and experience in developing new logical, conceptual, and physical models for data and system flows• 

 Develop technical strategies and architectures for high-performance, scalable and complex enterprise-grade system• 

 Work with SAS developers, business analyst, DBAs, system administrators, to architect data model, design and implement database as well as write ETL related programs.• 

 Work closely with the team responsible for the maintaining the data model, including data dictionary/metadata registry.• 

 Document programming problems and resolutions for future reference.• 

At least 5-7 years experience in providing ETL solutions via SAS/ETL tools 

 5-7 years experience in SAS EDI environment, focused on utilizing SAS Data Integration Studio, Base SAS, SAS macros and SQL.• 

 1 year experience with the SAS DDS banking model• 

 2 years experience in Linux/Unix• 

 Strong understanding of Data Warehouse/MDM concepts (ETL, Star Schema, slowly changing dimensions).• 

 Strong knowledge of relational databases, Data Warehouse a•nd business Intelligence solutions 

 Excellent teamwork and collaboration skills.• 

 Proficient in shell scripting and performance tuning within a Unix/Linux Environment• 

 Excellent written/verbal communications skills.• 

 Ability to meet deadlines with attention to detail and accuracy.• 

 Ability to handle multiple concurrent tasks/projects according to priorities.• 

 Ability to work in a group or team environment• 

Qualifications

Bachelors or any Relevant Degree

Additional Information

Thanks & Regards

Srikanth
INENT INC

Srikanth(at)inentinc(dot)com
909 610 3103 * 128

Skills Required

  • 5-7 years experience providing ETL solutions using SAS/ETL tools
  • 5-7 years experience in SAS environment using SAS Data Integration Studio, Base SAS, SAS macros, and SQL
  • Experience with SAS Detail Data Store (DDS) banking model (1 year)
  • Experience with Netezza and other relational database platforms
  • 2 years experience in Linux/Unix environments
  • Proficient in shell scripting and performance tuning within Unix/Linux
  • Strong understanding of Data Warehouse and MDM concepts (ETL, star schema, slowly changing dimensions)
  • Experience with data modeling (conceptual, logical, physical) and metadata/dictionary maintenance
  • Familiarity with SDLC processes and ability to document programming problems/resolutions
  • Bachelor's degree or relevant degree
  • Excellent written/verbal communication and teamwork skills; ability to meet deadlines and handle multiple tasks
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
12 Employees
Year Founded: 1982

What We Do

Inent Inc is an award-winning IT services and staffing firm founded in 2010. The company specializes in delivering specialized talent and consulting services to Fortune 1000 customers, with core expertise in Salesforce, SAP, Pega, mobile application development, and data services including Hadoop and NoSQL. They focus on optimizing business productivity and growth through strategic IT implementations and talent acquisition solutions.

Similar Jobs

SailPoint Logo SailPoint

Security Engineer

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
174K-294K Annually

SailPoint Logo SailPoint

Technical Program Manager

Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Remote or Hybrid
United States
2461 Employees
122K-206K Annually

Applied Systems Logo Applied Systems

Lead Product Insights Analyst

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
United States
3079 Employees
110K-140K Annually

Applied Systems Logo Applied Systems

Director, Product Analytics & Insights

Cloud • Insurance • Payments • Software • Business Intelligence • App development • Big Data Analytics
Remote or Hybrid
United States
3079 Employees
164K-190K Annually

Similar Companies Hiring

Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account