Assignment: RQ07236 SoftwareDeveloper Senior
Start Date:
EndDate:
Office Location: 5700 Yonge Street
Organization: Children Youth & Social ServicesCluster
Ministry: Ministry of Children Community andSocial Services
# Business Days: 240.00
Title: Software Developer
Candidate is required to comein office 3 days a week
MustHaves
Extensive experience with IBM ContentManager and using the Content Manager Java API to query and extractdata.
Extensive experience developing softwareespecially with Java for large scale data processing and datamigration projects.
Proficient in the Java programminglanguage and Java 8 features such as Lamdas Java Stream API(java.util.stream) New Input/Output API (java.nio) andmultithreading (java.util.concurrent).
Strong SQL skillsand a good understanding of databases to query manipulate andoptimize data during migration.
Experience and Skill SetRequirements
Essential Skills 60%
Extensive experience developing software especially with Java forlarge scale data processing and data migration projects
Extensive experience with IBM Content Manager and using the ContentManager Java API to query and extract data.
Experiencein programming and analysis; specialized software package supportat the specified experience level.
Ability tocollaborate with IT Professionals throughout the SoftwareDevelopment Life Cycle.
Experience in structuredmethodologies for the development design implementation andmaintenance of applications.
Experience in designingcoding testing debugging and documenting applications.
Experience in the use of object and/or third generation languagedevelopment tools.
Experience in one or more programminglanguages.
Experience in application design latestdesign patterns deployment and troubleshooting.
Experience with relational and hierarchical databasetechnologies.
Strong SQL skills and a good understandingof databases to query manipulate and optimize data duringmigration.
Proficiency in analyzing source and targetdata structures to design effective migrationstrategies.
Understanding of Extract Transform Load(ETL) principles and best practices to design efficient datamigration workflows.
Experience in the use ofinformation retrieval packages using query languages.
Experience with one or more communications protocols.
Experience in structured methodologies for the design developmentimplementation and maintenance of applications
Experience eliciting and documenting information from diversebusiness area stakeholders and subject matter experts.
Excellent analytical problemsolving and decisionmaking skills;verbal and written communication skills; interpersonal andnegotiation skills.
A team player with a track recordfor meeting deadlines.
Software Development Skills30%
Enhance and operate a Java 8basedextraction and migration tool using the IBM Content Manager 8.6Java API and the target systems REST API.
Develop a dataintegrity solution to crosscheck and reconcile extracted metadatacontained within many JSON files against data stored in a MicrosoftSQL Server database.
Develop an Azure Data Factorypipeline to load extracted files to Azure Storage and updateDataverse tables.
Develop an Azure Data Factory pipelineto migrate structured case management data from an onpremises SQLServer to the Dataverse.
Investigate issues resultingfrom sample migrations to revise and enhance Java 8based extractiontool and Azure Data Factory pipelines.
Handle largescaledata migration including batch processing and efficient datastorage in XML and JSON formats.
Work with the internalteam for requirement analysis integration and ensuring dataconsistency between systems.
Translate technical systemsspecifications into working tested applications. This includesdeveloping detailed programming specifications writing and/orgenerating code compiling datadriven programs maintaining andconducting unit tests.
Implement error handling loggingreporting and data integrity checks to compare source data on thefile system with imported data in the target system.
Conduct thorough testing and quality assurance toensure the reliability and accuracy of the migrationprocess.
Resolve and troubleshoot technical problemswhich arise during the use and operation of software packagesincluding technical assistance in implementation conversion andmigrations.
Cloud Skills 10%
Knowledgeand experience building pipelines with Azure DataFactory.
Demonstrated ability to develop implement andmaintain complex SQL queries stored procedures and reportingsolutions in Azure SQL and SQL Server environments ensuring datasecurity and compliance.
Familiarity with cloudplatforms (e.g. AWS Azure Google Cloud) for cloudbased datamigration projects
Familiarity with other relevant Azureservices such as Azure Storage Azure SQL Database Azure BlobStorage etc. to effectively utilize and manage data duringmigration.
Knowledge and understanding of InformationManagement principles concepts policies and practices.
Experience reviewing analyzing and modifying product installationscripts including encoding testing and debugging.
Ability to provide postimplementation support and resolve anypostimplementation technical issues
Experienceconducting design walkthrough sessions with project team
Ability to provide user and system documentation asrequired