Senior SAS Data Integration Developer & ETL Developer
Company Name:
Analytiks International Inc
Senior SAS Data Integration Developer & ETL Developer
Education
Location: Cary, NC
100% Onsite
Contract Position
Contract Duration: 3 Months
Start Date: ASAP
Background & Job Requirements
SAS DI Developer will be responsible for Enterprise Data Warehouse and mapping data from multiple sources (including MS SQL Server, flat files, Excel), building and implementing the data flows and loading the data into a SAS Analytical/Reporting data mart. The consultant will be required to design/develop the data model for the SAS Analytical/Reporting Data mart for optimal efficiencies. The candidate will have demonstrated experience in using DI Studio, MS SQL Server, SAS Metadata Administration and good communication skills providing updates to the Technical Lead.
The consultant will be tasked with the following:
1) Integrating and managing the data mappings from the client's data sources to the SAS Analytical data mart using SAS DI Studio. Designing, developing and implementing the DI Studio job flows to load the data into SAS and MS SQL Server.
2) Creating Stored Processes to provide the users of the Reporting Data Mart easy access to the data.
This position will be responsible for 1) gathering data requirements and designing/developing data marts and 2) performing analytical and programming activities including analysis, design, development, testing, implementation, and documentation of integrating the data management solutions, 3) functioning as subject matter expert for using Data Integration Studio. Successful candidates will possess: 1) experience in designing and developing data marts and using SAS DI tools, 2) strong understanding of standard development methodology (Systems Development Life-cycle) for both implementation and maintenance projects, 3) thorough understanding of and experience in structured programming methodology, 4) skill in gathering and documenting user requirements and writing technical specifications, 5) proven customer relationship skills, 6) strong SAS DI tools, SQL and MS SQL Server knowledge.
Skill Set
The Customer requires a Senior SAS DI consultant.
Essential duties and responsibilities include the following, with hands-on, proven experience with SAS programming to maintain and develop advanced SAS coding techniques to write maximum efficient and performance optimized code.
Services may include focus on and require the Consultant to:
1. SAS DI Studio experience a must.
2. Apply and demonstrate expertise with efficient DATA step, SQL programming, SAS Macro programming, ODS, Reporting and Summary procedures and SAS Array processing.
3. Minimum of 6 (six) years' experience developing technical solutions with SAS Data Integration and reporting tools in a SAS environment
4. MS SQL Server DBMS experience.
5. Must have project experience with implementing advanced SAS coding techniques to optimize performance and have developed best practices for efficient coding due to constraints of hardware storage and memory.
6. Must have project experience with sophisticated Base SAS development for performance enhancement and advanced SAS Dataset storage best practices.
7. UNIX scripting knowledge is required.
8. Have good oral and written communication skills.
9. Lead and/or actively participate in SAS knowledge-sharing activities.
10. Must be able to read, and understand existing coding and processing to troubleshoot and resolved issues as they arise.
Demonstrate the ability to work with little direct supervision; Excellent troubleshooting skills; Imaginative, inquisitive, with a self-motivating personality and a strong work ethic; Customer focused demeanor.
Candidates should also have the following skillsets:
Experience in Data Integration Studio, developing sophisticated data flows in DI Studio.
Experience extracting data from MS SQL Server
Experience manipulating data in SAS using DATA step, ARRAYs, Macros, SQL.
Experience with reporting techniques and procedures in SAS (e.g., PROC REPORT, PROC SUMMARY, ODS and export functionality to Excel).
Ability to develop new data loads to existing data warehouse.
Estimated Salary: $20 to $28 per hour based on qualifications.
Analytiks International Inc
Senior SAS Data Integration Developer & ETL Developer
Education
Location: Cary, NC
100% Onsite
Contract Position
Contract Duration: 3 Months
Start Date: ASAP
Background & Job Requirements
SAS DI Developer will be responsible for Enterprise Data Warehouse and mapping data from multiple sources (including MS SQL Server, flat files, Excel), building and implementing the data flows and loading the data into a SAS Analytical/Reporting data mart. The consultant will be required to design/develop the data model for the SAS Analytical/Reporting Data mart for optimal efficiencies. The candidate will have demonstrated experience in using DI Studio, MS SQL Server, SAS Metadata Administration and good communication skills providing updates to the Technical Lead.
The consultant will be tasked with the following:
1) Integrating and managing the data mappings from the client's data sources to the SAS Analytical data mart using SAS DI Studio. Designing, developing and implementing the DI Studio job flows to load the data into SAS and MS SQL Server.
2) Creating Stored Processes to provide the users of the Reporting Data Mart easy access to the data.
This position will be responsible for 1) gathering data requirements and designing/developing data marts and 2) performing analytical and programming activities including analysis, design, development, testing, implementation, and documentation of integrating the data management solutions, 3) functioning as subject matter expert for using Data Integration Studio. Successful candidates will possess: 1) experience in designing and developing data marts and using SAS DI tools, 2) strong understanding of standard development methodology (Systems Development Life-cycle) for both implementation and maintenance projects, 3) thorough understanding of and experience in structured programming methodology, 4) skill in gathering and documenting user requirements and writing technical specifications, 5) proven customer relationship skills, 6) strong SAS DI tools, SQL and MS SQL Server knowledge.
Skill Set
The Customer requires a Senior SAS DI consultant.
Essential duties and responsibilities include the following, with hands-on, proven experience with SAS programming to maintain and develop advanced SAS coding techniques to write maximum efficient and performance optimized code.
Services may include focus on and require the Consultant to:
1. SAS DI Studio experience a must.
2. Apply and demonstrate expertise with efficient DATA step, SQL programming, SAS Macro programming, ODS, Reporting and Summary procedures and SAS Array processing.
3. Minimum of 6 (six) years' experience developing technical solutions with SAS Data Integration and reporting tools in a SAS environment
4. MS SQL Server DBMS experience.
5. Must have project experience with implementing advanced SAS coding techniques to optimize performance and have developed best practices for efficient coding due to constraints of hardware storage and memory.
6. Must have project experience with sophisticated Base SAS development for performance enhancement and advanced SAS Dataset storage best practices.
7. UNIX scripting knowledge is required.
8. Have good oral and written communication skills.
9. Lead and/or actively participate in SAS knowledge-sharing activities.
10. Must be able to read, and understand existing coding and processing to troubleshoot and resolved issues as they arise.
Demonstrate the ability to work with little direct supervision; Excellent troubleshooting skills; Imaginative, inquisitive, with a self-motivating personality and a strong work ethic; Customer focused demeanor.
Candidates should also have the following skillsets:
Experience in Data Integration Studio, developing sophisticated data flows in DI Studio.
Experience extracting data from MS SQL Server
Experience manipulating data in SAS using DATA step, ARRAYs, Macros, SQL.
Experience with reporting techniques and procedures in SAS (e.g., PROC REPORT, PROC SUMMARY, ODS and export functionality to Excel).
Ability to develop new data loads to existing data warehouse.
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
