Application Developer - Intermediate

Summary

Join the Government of Alberta as an Application Developer to contribute to the Justice Information Management System (JIMS) 3.0 project. This role involves planning, designing, developing, and testing ETL phases for data warehousing activities. You will analyze legacy data, create mapping specifications, develop ETL processes, and test data quality. Collaboration with senior data architects and business subject matter experts is crucial. The position requires expertise in data modeling, star schema, and data warehouse development. Success in this role will directly impact the efficiency and effectiveness of court data reporting for the GOA.

Responsibilities

• Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements
• An Application Developer applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies, but the focus is to ensure a certain business/functional use case is solved with the help of technology
• Liaises with business units and program areas to ensure solutions meet current and strategic ministry needs and requirements
• Write performing quality code to fulfill design, and pass code review with minimal number of defects
• Apply configuration on development environments when required
• Participate in implementing full product into production, and supports providing application versions and details for implementation plan
• Highlight the technical impacts of the functional design on existing applications based on a detailed analysis
• Deliver technical design and database structure for medium to high application complexity
• Maintain technical documentation
• Identify critical features of system, and focus testing effort on them. Ensure that the unit test covers the right proportion of the application
• Setup data for testing
• Grasp Able to quickly understand application functionalities and process
• Handle and fix production defects efficiently
• Provide tracking and reporting of time and status on all work as required
• Contribute to the creation of the Application Lifecycle Planning
• Identify and coordinate release schedules
• Identify service requests and priorities with customer
• Ensure planned releases remain on schedule and on track
• Reviewing existing data marts
• Performing detailed data profiling
• Analyzing and creating mapping specifications
• Developing and testing extract transform load (etl) processes
• Developing test queries for several dimensions and facts
• Testing of dimensions and facts for quality assurance
• Developing objects such as views, tables, stored procedures to examine data for business usability
• Staging the required data
• Addressing defects in newly developed dimension and fact tables
• Communicating analysis results with data architects, other developers, and business subject matter experts
• Providing feedback and lessons learned at project close out