ETL Developer

ETL Developer

Job Title: ETL Developer
Contract Type: Permanent
Location: Woodland Hills, California
Salary: US$70000.00 - US$90000.00 per annum + full medical + benefits
Reference: HQ00071868_1524594945
Contact Name: Emma Hage
Contact Email:
Job Published: April 24, 2018 19:35

Job Description

My client is a global and reputable company who are investing heavily within their data management, analytics and development teams. As a result, they are looking for an experienced ETL Developer with a minimum of 3 years experience in SSIS and ideally SAS Design Integration Studio.

The successful candidate will design and develop ETL jobs for large data feeds and support complex data warehouse transactions. Similarly, you will be responsible for troubleshooting, ad hoc data analysis, validation, and identifying any data quality issues.

The successful candidate will possess:
-Minimum of 3+ years' experience in an ETL development position.
-Strong Experience with RDBMS systems SQL Server preferred.
-Strong SQL and analytical skills required.
-Knowledge of SAS Data Integration Studio 4.9 preferred, but not required.
-Skilled in use of some type of ETL toolsets (SAS DI, SSIS, Informatica, DataStage, etc.)

Your day to day tasks will include:
-Collaborate with developers, subject matter experts and business users in gathering and documenting requirements for data extraction and transformation.
-Follow design standards for ETL processes
-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.
-Analyze, assess and implement changes to existing solutions in response to business changes.
-Perform both new development tasks as well as production support.
-Integrate and manage the data mappings from data sources (mainly MS-SQL Server) to the Enterprise Data Warehouse.
-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.

This is a great opportunity to make a direct impact on the growth of a brand as well as work across a range of business areas. This role also offers excellent benefits including full medical for individuals and their families.

Lawrence Harvey is acting as an employment agency in regards to this position.
Visit our website and follow us on Twitter for all live vacancies @lawharveyjobs