Job from partner
Send messageDescription of the job
Job Summary:
The Application Developer will contribute to the Justice Information Management System (JIMS) 3.0 project, focusing on the ETL phases for data warehousing activities. This role involves analyzing legacy data, creating mapping specifications, developing and testing ETL processes, and ensuring the new data model aligns with business requirements. The developer will work with senior data architects to translate requirements into queries and batch jobs for a structured data warehouse. Location: Remote, N/A, N/A, Canada, Responsibilities:
- Review existing data marts and perform detailed data profiling.
- Analyze and create mapping specifications for data transformation.
- Develop and test Extract Transform Load (ETL) processes.
- Develop test queries for Dimensions and Facts.
- Test Dimensions and Facts for quality assurance.
- Develop objects such as views, tables, and stored procedures to examine data for business usability.
- Stage required data and address defects in newly developed dimension and fact tables.
- Communicate analysis results with data architects, other developers, and business subject matter experts.
- Provide feedback and lessons learned at project close out.
- Liaise with business units to ensure solutions meet ministry needs.
- Write quality code to fulfill design and pass code reviews.
- Apply configuration on development environments.
- Participate in implementing full product into production.
- Highlight technical impacts of functional design on existing applications.
- Deliver technical design and database structure for medium to high application complexity.
- Maintain technical documentation.
- Identify critical features of system and focus testing effort.
- Setup data for testing.
- Handle and fix production defects efficiently.
- Provide tracking and reporting of time and status on all work.
- 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. Required Skills & Certifications:
- College or Bachelor degree in Computer Science or related field.
- Eligibility for Enhanced Security Clearance.
- 5 years of experience and technical knowledge of Microsoft SQL Server.
- 5 years of experience creating user training materials, technical documentation, and platform.
- 5 years of experience working as an Application Developer within an enterprise IT environment.
- 5 years of experience working in a data warehouse/business intelligence or relevant data.
- 5 years of knowledge of ETL processes and tools, with hands-on experience designing and implementing. Preferred Skills & Certifications: Special Considerations: Scheduling:
