Senior ETL Developer

Think Specialist Recruitment Uxbridge ,
Slough, Berkshire
Salary: £35000 - £50000 per annum

Overview

We are delighted to be working with a fast growing company in the water sector dedicated to innovation and teamwork. They are currently seeking a Senior ETL Developer to join the business. They value their professionals, providing comprehensive benefits, exciting challenges, and the opportunity for growth. This is a Contract or Permanent position and the client is looking for someone to start immediately. Role Description: The Senior ETL Developer would need to have at least 6 years of experience. The Candidate will help work on a wide range of analytics, business intelligence, data warehouse initiatives designed to support RF data-driven business strategies. They will be primarily responsible for implementing ETL processes. The ETL Developer should be well-versed in the design and development of ETL and database developments for a large data warehouse, as well as maintaining and supporting the production jobs. This Candidate should be able to work collaboratively with other team members, as well as users for operational support. Primary Responsibilities - Develop, design, tune and maintain SSIS packages to perform the ETL process. - Develop power BI dashboard, reports and DAX codes - Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process. - Design and develop ETL solutions using data integration tools for interfacing between source application and the Enterprise Data Warehouse. - Develops ETL technical specifications, designs, develops, tests, implements, and supports optimal data solutions. - Documents ETL data mappings, data dictionaries, processes, programs and solutions as per established standards for data governance. - Integrates ETL development with existing projects to maximize object reuse. - Creates, executes, and documents unit test plans for ETL and data integration processes and programs. - Work with the data analysis team to assess and troubleshoot potential data quality issues at key intake points such as validating control totals at intake. - Perform problem assessment, resolution and documentation in existing ETL packages, mapping and workflows in production - Troubleshoot data issues and defects to determine root cause. - Performance tuning of the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques. - Develop and create transformation queries, views, and stored procedures for ETL processes, and process automations. Required Qualifications/Experience: - Minimum 3 years of experience designing, developing, testing, and implementing ETL solutions using any enterprise ETL tools (SSIS). - 3 years of experience working with high volume data bases and/or big data. - Bachelor's degree in information systems or business management. Education: Bachelor's degree Experience: Minimum 6 years Private Medical, Bonus, Rapid career growth For more information please apply by sending your CV This job was originally posted as www.totaljobs.com/job/89912390