Sr. SAS ETL Developer

Sr. SAS ETL Developer

Prosum Technology Services
5 - 8 Years
Not Specified

Job Description

Our client is looking for someone who will design and develop ETL jobs for large data feeds and support complex data warehouse transactions. Also troubleshooting, data analysis, validation, and identify data quality issues. This position utilizes numerous SAS Data management products including DI Studio 4.9 and DM Studio for data quality. Must have experience working on top of a Windows platform with skills in server and SAS software configuration including Metadata. This person must also understand the hardware and software interactions in order to optimize the system settings that will drive out the best solution performance and ensure proper integration of SAS Enterprise Business Intelligence tools.
Sr. SAS ETL Developer Job Details:
• Build and maintain SAS DI Studio jobs, job flows within Platform LSF, and troubleshoot job failures.
• Formulate solutions/recommendations, based on the requirements & technical standards.
• Perform both new development tasks as well as production support.
• Collaborate with developers, subject matter experts and business users in gathering and documenting requirements for data extraction and transformation.
• Integrate and manage the data mappings from data sources (mainly MS-SQL Server) to the Enterprise Data Warehouse using the SAS Data Management solution.
• Develop and improve MS-SQL Server processes as needed.
• Perform code reviews, analyze execution plans, improve ETL jobs efficiencies, correct ETL defects and respond quickly to fixes and enhancement requests.
• Follow design standards for ETL processes.
• Analyze, assess and implement changes to existing solutions in response to business changes.
Sr. SAS ETL Developer Required Skills:
• Skilled in the use of SAS Data Integration Studio 4.9 ETL toolset.
• Minimum of 5+ years experience in an ETL development position.
• Strong Experience with SQL Server databases preferred.
• Strong SQL and analytical skills required.
• 5+ years of industry experience in the data warehouse arena including experience in data warehouse methodologies, including data management, data integration and analytics system architecture.
• Proficient with Linux/Unix shell scripting.

Similar Jobs

People Also Considered

Career Advice to Find Better