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
Load data from sources systems into data lake Microsoft MDS scripting using power shell prepare reconciliation of data loaded into data lake
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.
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
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)
Hands-on experience in setting up Azure Data lakes or ODLs'