Our client is looking for a Intermidate Level Data Modeller with experience with PowerDesigner on a 6 month extendable Contract .Desirable Skills :Demonstrates experience in using data modelling tools, specifically PowerDesignerDemonstrates experience in maintenance of conceptual, logical and physical data models for operational and data warehouse projectsDemonstrated experience with database and data warehouse designDesign, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.General Skills:AdvantagesContract will ExtendOpporuntity to work in Ontario Public Sector. Long Term Contract ResponsibilitiesExperience in programming and analysis; specialized software package support at the specified experience levelAbility to collaborate with IT Professionals throughout the Software Development Life CycleExperience in structured methodologies for the development, design, implementation and maintenance of applicationsExperience in design, code, test, debug and document applicationsExperience in the use of object and/or third generation language development toolsExperience in one or more programming languagesExperience in application design, latest design patters, deployment and troubleshootingExperience with relational and hierarchical database technologiesExperience in the use of information retrieval packages using query languagesExperience with one or more communications protocolsExperience in structured methodologies for the design, development, implementation and maintenance of applicationsExperience eliciting and documenting information from diverse business area stakeholders and subject matter expertsExcellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skillsQualificationsETL Experience - 40%3+ years of hands on ETL development experience using Informatica and SSIS/ADF, in a data warehousing environment or large data migration; Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL componentsExperience with data architecture designs and technologies for BI solutionsExperience in debugging mappings, transformations, mapplets, source qualifier files and queriesDemonstrated experience with developing and using re-usable components to assist with ETL processDemonstrates experience with developing, debugging and enhancing the performance of complex SQL queriesExperience working with Oracle and MSSQL databasesExperience with source control and environment managementBI Experience Skills - 40%3+ years of working experience with Cognos and Power BIDemonstrated experience with developing Cognos reports, dashboards, storyboards, and data visualization techniquesDemonstrated experience creating Active ReportsDemonstrated experience with developing Cognos cubes in Cognos Query Studio and SSASDemonstrates experience building cube for Microsoft BI report purposesDemonstrates design and development experience as a full stack Microsoft BI tools (SQL Server, SSIS, SSAS, SSRS, Power BI)General Skills - 15%Demonstrated knowledge and experience with Data Dictionary and data mappingDemonstrates experience with stakeholders to elicit requirements, developing/consulting on options and solutions, facilitating the resolution of I&IT and Business issues, and help translate into technical requirements. Ability to drill down on business pain points and determine the right solution, rather than delivering only the item that’s being requested by stakeholdersDemonstrates development and design experience with SDLC processes, Agile and Waterfall methodologiesExperience with creating documentations such as data dictionary and data source to target mapping; provide feedback/direction to team on how existing documentations can be improvedDemonstrates ability to work in a team, with the ability to coordinate multiple projects with competing priorities and a track record for meeting strict deadlinesSummaryDesign, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests.Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations.General Skills:Randstad Canada is committed to building a diverse workforce reflective of the diversity of Canada. As a result, we promote employment equity and encourage candidates, especially those who identify as a woman, an Aboriginal person, a person with a disability or a member of a visible minority group, and any others who may contribute to the diversification of our workforce, to apply.Randstad Canada is also committed to developing an inclusive, barrier-free selection processes and work environments.If contacted in relation to a job opportunity, you should advise your Randstad Representative or your local Randstad branch in a timely fashion of the accommodation measures which must be taken to enable you to be assessed in a fair and equitable manner.Information received relating to accommodation measures will be addressed confidentially.For all feedback on equity and accommodation needs, please contact your local Randstad Canada Branch.