Job Description
Job Title: Software Developer - ETL
Location: Toronto
Work Model: Onsite
Duration: 6 months
Extension: 1 Time
Must Haves
- 5+ years' Experience with analysis, design, developing, unit testing, defect fixing and other necessary tasks in data warehousing, BI environment.
- 5+ years' experience in designing and developing Crystal reports, Power BI, and BOE reports
- 5+ years' experience in Designing, developing and testing Oracle SQL and PL/SQL.
- 5+ years' experience in Designing, developing and testing in Informatica.
- Experience with technology solutions and development methodologies
- Experience in analyzing and designing changes to existing web-based software solutions
- Complete knowledge of SDLC methodologies, e.g. Agile development.
- Experience in RDBMS design concepts.
- Experience with Data Warehouse design, Reporting and ETL concepts.
- Experience with Data Warehouse architecture, design, dimensional modeling, development and deployment of business intelligence systems.
Description / Responsibilities / Skills
Description
- 'Employment Ontario' is one of the major programs delivered by the Employment and Training Division of the Ontario Ministry of Training, Colleges and Universities.
- The Employment Ontario Information Systems (EOIS) is the major IT system that supports the administration of these programs.
- The operating Environment includes JEE, CURAM, Crystal Reports, Oracle SQL/PL SQL, Power BI, Oracle Database, Business Objects Universe and Dashboarding, WebI, Bursting technologies, and Informatica ETL.
Responsibilities
- Develop ETL scripts to transfer and transform data from OLTP database to Data Warehouse and Data marts
- Develop and maintain BOE reports
- Communicate your progress clearly and timely to the management team
General Skills
- Ability to collaborate with IT Professionals throughout the Software Development Life Cycle
- Experience in design, code, test, debug and document applications
- Experience in the use of object and/or third generation language development tools
- Experience in the use of information retrieval packages using query languages
- Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts
- A team player with a track record for meeting deadlines
Desirable Skills
- Knowledge and experience with programming Internet-ready applications
- Knowledge and experience in rapid application development (RAD) methodologies
- Experience with middleware and gateways
- Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging
- Ability to provide post-implementation support and resolve any post-implementation technical issues
- Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
Experience & Skill Set Requirements
Communication & other Skills - 20%
- Ability to build good working relationships.
- Positive team player.
- Good verbal and written communication skills.
- Good analytical and problem-solving skills.
- Excellent ability to present to a technical and non-technical audience.
Knowledge of Methodologies - 10%
- Working knowledge of SDLC and the Agile development methodology.
- Demonstrated knowledge and experience with RDBMS design concepts.
- Demonstrated experience in identifying risk and providing solutions.
- Strong analytical and problem-solving skills.
- Ability to mentor junior developers and lead technical discussions.
Job Tags