ETL Developer

  • Alpha People Pty Ltd
  • Port Macquarie NSW, Australia
  • Oct 19, 2018
Full time Information Technology

Job Description

ETL Developer with DBA Role @ Port Macquarie Fly in&out


About the business

You will be working for boutique and a highly successful company with a co-hart of highly talented people, where you shall be delivering solutions to a utility company. This is an opportunity not to be missed and is a way to advance your career.

About the role

Our client is looking for an ELT Developer with DBA Skills who would be responsible for development, support, maintenance and implementation of architect designs.

Work on an exciting transformation project for an established organisation. As an ETL Developer you shall be responsible for the design, implementation and documentation of data load/integration interfaces, you will be required to translate high-level technical designs into ETL processes.

Hands-on experience 6-8 Years with MS SQL Server and MS BI Suite including MS DQS
Excellent experience with ETL Development with SSIS / SSRS
DBA Experience with experience in MDS and understanding of MDM
Skills and experience

Key Responsibilities:

DBA Responsibilities

Load data from sources systems into data lake Microsoft MDS scripting using power shell prepare reconciliation of data loaded into data lake
ELT Responsibilities

End-to-end detail ELT solution design and development covering
Integration, transformation & consolidation, scheduling.
Working closely with EIM Solution & Domain Architects for ensuring
Alignment with high-level solution designs, domain patterns and architecture standards

Understanding data sources, ingestion and consumption use-cases,
data quality, latency and other considerations such as data & storage formats, persistence needs, data volatility, business rules & aggregations, big data consideration
Create and build dimensional models and data schemes.
Establish best practices and drive and facilitate workshops.
Key Requirements:

DBA Skills Set Needed

Microsoft SQL Server DBA
Experience in Microsoft MDS - Master Data Services
Understanding of MDM – Master Data Management
ELT Skills Set Needed

Experience is designing the ETL development, data preparation,
Blending, integration and resolution of data quality.
Hands-on experience with ETL development with SSIS / SSRS
Hands-on experience with MS SQL Server and MS BI Suite including
MS DQS
Hands-on experience with EDH/EDW data ingestion development
Hands-on experience with other RDBMS data sources
Deep understanding of ETL best practices & technical understanding
of the data mart / data cube solutions
Good to have

Industry experience in Utility domain or asset management domain
Any experience in Peoplesoft (FSC, HRMS and CRM)
Added advantage

Hands-on experience in setting up Azure Data lakes or ODLs'