Cloudtrend Inc. specializes in building and managing an exclusive network of IT professionals to better their career opportunities and meet the demand of the market. We provide career management services and opportunities.
Position
Our client is looking for Application Developer to assist in the planning, design, development, and testing of the Extract, Transform and Load (ETL) phases for the data warehousing activities within the project. Additionally, the role is expected to help make sense of the large amount of legacy data through analysis and insight to ensure new data model correctly reflects business requirements.
Working with Senior Data Architects, this role will primarily be as the Data Developer who understands data models and design specifications, understands star schema and data warehouse development life cycle, and is able to translate requirements and design specifications into queries and batch jobs that move data into a structured data warehouse. This Data Developer role will specifically focus on: • 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.
Requirements
University graduation, diploma or certificate in Computing Science (CS) or other related discipline
Experience delivering Extract, Transform and Load (ETL) solutions utilizing Microsoft SQL Server Integration Services (SSIS) in data warehousing projects.
Experience with SQL programming, stored procedures, views, and user defined functions (SSMS, TFS).
Experience building data warehousing solutions in a collaborative, agile development environment
Experience in facilitating meetings and communicating with project team members, subject matter experts and senior management.
Experience with written and verbal communications including specific experience in drafting strategic business and technical documentation.
Proposed resource has agreed to an Enhanced Security Check upon contract award, which will be coordinated by GoA. Must have the last 3 years continuous residency in either Canada or United States as minimum.
Experience with unit testing, and test-driven development tools.
Desirables
Experience with the Agile and scrum development methodology
Experience with User Acceptance Testing processes on large, complex, multi-stakeholder environment.
Experience in the design, development and implementation of complex IT solutions.
Demonstrated experience communicating and interacting with all levels in an organization, from front line staff to high-level executives, to facilitate change and foster successful delivery of project objectives.
Experience doing SQL Server development including ad-hoc queries, procedures, views, user defined functions.
Experience with unit testing, mock testing frameworks, integration testing, and release management
Do you have related Canadian education (e.g. certificate, diploma or degree) or your foreign credentials certified by Immigration Canada, IQAS or any accreditation acceptable to the Government of Canada or Alberta?