Responsible for analysis, development, documentation, and support of customised migration scripts, packages and reports.
The main focus of the role is to design and develop SQL scripts and procedures for both Oracle and MSSQL, for the dual purposes of Data Migration, and Reporting. The secondary focus will be on employing software packages which invoke these SQL scripts and procedures within an execution framework – either an ETL tool for Data Migration, or a Reporting Engine. There will be a consultative nature to the role with reporting status and progress to Project and Department Managers.
2+ years database SQL scripting experience.
Exposure to general programming experience in a corporate or professional environment;
SDLC, logical and analytical skills.
Demonstrated experience with T-SQL and PL/SQL for developing Procedures and Functions.
Experience working on Data Migration projects and/or Reports development
Experience with or knowledge of reporting tools: Crystal Reports, Microsoft SSRS, Jasper Reports.
Experience with ETL technologies such as SSIS, Informatica, IBM Datastage, or similar
Experience with Jasper Reports (iReports, Jasper Studio, Jasper Server)
Experience with SSRS and Crystal Reports for report development, and exposure to other technologies such as Business Objects, Hyperion, Cognos
Experience with both MSSQL and Oracle RDBMS for SQL development and analysis
Experience with Business Intelligence and Analytics tools and methodologies, such as PowerBI, Tableau, Qlik, Jasper Analytics, or similar
Understanding of Data Warehousing techniques and structures.
The company offers a challenging job in a growing, international, high-tech company with lots of opportunities to extend your expertise or broaden your scope.
You will be part of a growing, international and dynamic work environment with a company that has been in business for over 30 years and is doubling in size every 5 years.
A community-driven organisation supporting you in all aspects of your daily job, heavily focusing on knowledge sharing, best practices, and training.
The possibility to keep learning, acquire the desired skills, and be the driver of your own career.
Apart from work, we also like to make time for fun. We organize several activities throughout the year to maintain the team spirit and to celebrate our successes.
We offer an attractive salary package in line with your knowledge and experience. Including flexible working arrangements.
Full-Time | Macquarie Park, AU | Software Engineering
We are currently recruiting for J2EE/Java Developers for permanent positions.You will be part of a dynamic team which has end to end responsibility to achieve its goals servicing the companies customers. The diverse task set of the&nbs...