28
March
Senior Database Engineer - Informatica
Manvision Consulting - North Sydney, NSW
IT
Source: uWorkin
JOB DESCRIPTION
Manvision Consulting provides IT Contracting and Professional Services to the Australian Market since 2008. Join a talented team and work in a culture that stimulates an inclusive and flexible work environment, offering opportunities to grow and contribute to the company.
Roles and Responsibilities
- Experience: 6-12 years
- Database Development including create tables, write SQL queries, Develop Stored Procedures, Functions, Triggers etc.
- Database Design, Data Modeling including Dimensional Modeling for DWH/ Data Marts
- ETL Design & Development
- Database Performance Optimization
- Data Analysis and create Data templates in Excel and create Excel Macros
- Liaison with Operations Teams for Production Issues
- Create Operational Guide for Operations Team for items Released
- Create Release Notes and coordinate with DBA’s for Code Release.
- Deliver code in agile Manner
- Create Batch Job Specifications and design Batch Scheduling
- Optimize Batch Scheduling
Skills Preferred
- SQL Server (writing SQL queries, Stored Procedures, Functions, Triggers etc.)
- Exposure to Batch Scheduling tools
- Dimensional Modeling
- ETL Design and Development
- Informatica – must
- Agile Methodology
- Dev-Ops
- GIT-Hub
- Version Control
- SSIS
**Initially 6 months, possibility to extend the contract