Skip to content

JobNet: Jobs for Technical People

 

Duluth, Georgia - USD Full Time Posted: Thursday, 8 November 2018
 
 
Position Summary

As a member of the Data Architecture and Reporting (DAR) team, the BI/DW ETL Developer is responsible for loading the brand new data warehouse efficiently. The developer is responsible for data validation, data cleansing, data transformation as well as writing and scheduling complex ETL jobs. This role includes analyzing and understanding the data transformation rules required to extract and transform and load the new Data Warehouse. The developer is responsible for ETL automation and developing the framework to include restartability, error handling, notifications, etc. This position works closely with other DAR team members and other IT functional teams to analyze, create, implement, and support ETL mappings.

Responsibilities

. Design the system components for the extract/transform or conversion of data from source systems to the target application

. Design system components which reconcile and audit the results of the extract/transform or conversion of data from source systems to the target application

. Construct the extract/transform, transfer and audit components of a data warehousing system or data conversion programs through the use of extract development tools or custom developed procedures

. Define and manage the data load procedures; facilitate the change data capture

. In addition to developing new mappings/ETL jobs, also responsible for automation, monitoring and supporting mappings, and re-designing if required to make them run faster and more reliable

. Develop a framework which can scale from batch based ETL to event-driven ETL architecture

. Handle XML and web service as data source in ETL jobs

. Define and implement ETL development standards and procedures

. Define and implement ETL tool configuration

. Ensure ETL quality through inspections and knowledge sharing

. Strong analysis and design skill

. Strong experience with Business Intelligence and data warehousing design principles and industry best practices.

. Deep understanding of relational database design concepts and SQL programming

. Work with closely internal business partners to identify opportunities for improved data analytics capabilities

. Build data models that enable enhanced business decision making capabilities

. Help define a data architecture and infrastructure that enables Data Science capabilities

. Collaborate with business management, domain SME's, and IT teams to understand and prioritize business data analytics requirements

. Research new opportunities for data acquisition

. Integrate technical functionality (eg scalability, security, performance, data recovery, reliability, etc.)

. Meld new systems with existing warehouse structures

Experience

. Hands on working experience of at least 7-10 years' experience working with data profiling tools like Information Analyzer or Informatica Data Explorer and/or other ETL tools

. Ability to design and develop complex ETL mappings, sessions, workflows and identify areas of optimizations

. Ability to read and/or design logical and multi-dimensional data models

. Experience with unstructured databases technologies (ex, Data lakes, Hadoop, NoSQL)

. Experience with MS SQL Server 2016

. Strong communication skills (both oral and written) and the ability to work effectively in a team environment are required

. Experience with relational, multidimensional, and OLAP techniques and technology

. The ability to transcend the theoretical to right size solutions with the understanding that the ideal solution is not always the practical solution

. IT processes and development methodologies including Agile

. Ability to operate in a fast-changing environment

. The ability to work with all levels of the organization

. A can-do attitude

Education A degree in Computer Science, a related discipline, equivalent work experience of 7-10+ years overall IT or the equivalent combination of education, training and experience from which comparable skills can be acquired

Location: Duluth, Georgia

SDL2017



Duluth, Georgia, United States of America
IT
USD
Neptune Technology Group
Neptune Technology Group
JS761005705/566243727
11/8/2018 3:21:15 PM

We strongly recommend that you should never provide your bank account details to an advertiser during the job application process. Should you receive a request of this nature please contact support giving the advertiser's name and job reference.