About the role
Duration : 12 Months
Location : Remote (Physically present in Canada + EST Time Zone)/ Hybrid
Mandatory : Any GoC Reliability/Secret/Top Secret Clearance Required
We are seeking a Data Warehouse ETL Developer for one of our client. The resource designs, develops, and maintains data warehouse and analytics architecture to meet client’s enterprise’s business analysis and reporting needs. The resource also provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment.
Primary Responsibilities
- Designs, maintains, and provides support for data warehouse systems and related data marts;
- Translates business requirements into viable technical solutions;
- Participates in the testing of developed technical solutions;
- Participates in the investigation and resolution of complex Data Warehouse issues;
- Proactively identifies opportunities for process, systems, and other efficiency improvements;
- Works effectively in the team and contributes to team effectiveness through personal style;
- Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment.
Project Requirements
- Minimum of eight years of related experience and knowledge;
- Recent experience working with Cognos Data Manager
- 5+ years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
- Relational data base concepts and design;
- Technical testing techniques and tools;
- Logical and physical data modeling;
- Requirements analysis;
- Technical design skills;
- Proficient technical writing skills;
- Ability to translate business questions and requirements into technical solutions;
- Demonstrated application of technical problem solving and analytical tools and techniques;
- Experience with SQL Server;
Assets
- Bilingualism in both official languages (English and French).
- Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio).
We thank you for visiting the job page. Only candidates closely matching the requirement will be contacted for interview. Wishing you all the best in your job search.
About OGGN Inc.
Based in the vibrant National Capital Region of Canada, we specialize in cutting-edge services tailored for diverse industries. Our offerings include strategic Advisory solutions, thorough Assessments, seamless Implementation, Recruitment and Staffing services. We excel in Data (covering Maturity, Governance, Architecture, Analysis and Security), AI, ML, RPA, Cloud (Assessments, Migrations, Vendor Recommendations), Agile methodologies, and a range of other Professional Services. Trusted by the public sector, private sector, not-for-profit organizations, crown corporations, startups, and Fortune companies, we bring innovation and excellence to various industry verticals.
Our key services and product offerings in Data and AI (www.ElevateX.ai) enables clients to fast-track and adopt GenAI and AI in their ecosystem.
Service Offerings: • Data, Automation, AI/ML and Operations: Implementation, Strategy, Approach, Deployment of AI/ML, RPA, and Ops (DevOps, DevSecOps, AIOps) • Consulting Services: Management, Agile, Scrum, Business, Technology, QA, Integrations, Healthcare Informatics, Content Management, Digital Transformation, Advisory Services • Cloud Services: Cloud Technology Solutions, Migration, Transformation, Modernization, Security, Audits, Assessments, and Recommendations • Recruitment & Staffing: Our deep business & technology expertise, local & global networks allow us to provide top talent be it contract or full-time
Government Procurement Vehicles:
-
Artificial Intelligence (AI) Source List. Qualified and accepted to be on the AI source list to provide responsible and effective AI services, solutions and products.
-
TSPS, Tier 1 and Tier 2 Supply Arrangement Holder.
-
TBIPS, Tier 1 Supply Arrangement Holder.
-
Ontario Ministry of Government and Consumer Services (MGCS).
Connect with us via our Website | Email: info@oggninc.com | LinkedIn
About the role
Duration : 12 Months
Location : Remote (Physically present in Canada + EST Time Zone)/ Hybrid
Mandatory : Any GoC Reliability/Secret/Top Secret Clearance Required
We are seeking a Data Warehouse ETL Developer for one of our client. The resource designs, develops, and maintains data warehouse and analytics architecture to meet client’s enterprise’s business analysis and reporting needs. The resource also provides support to the organization’s business requirements in the application and consumption of information from the Enterprise Data Warehouse (EDW) or from other source systems. The resource works with architects and business partners to fashion out the technical vision for applications in the Data Warehouse. The resource ensures the functionality, security, availability and accuracy of the information within the Data Warehouse environment.
Primary Responsibilities
- Designs, maintains, and provides support for data warehouse systems and related data marts;
- Translates business requirements into viable technical solutions;
- Participates in the testing of developed technical solutions;
- Participates in the investigation and resolution of complex Data Warehouse issues;
- Proactively identifies opportunities for process, systems, and other efficiency improvements;
- Works effectively in the team and contributes to team effectiveness through personal style;
- Design data integration/ETL jobs using DataStage and its foundation tools in a SQL Server and Windows environment.
Project Requirements
- Minimum of eight years of related experience and knowledge;
- Recent experience working with Cognos Data Manager
- 5+ years’ experience with IBMs ETL tool, IBM InfoSphere DataStage;
- Relational data base concepts and design;
- Technical testing techniques and tools;
- Logical and physical data modeling;
- Requirements analysis;
- Technical design skills;
- Proficient technical writing skills;
- Ability to translate business questions and requirements into technical solutions;
- Demonstrated application of technical problem solving and analytical tools and techniques;
- Experience with SQL Server;
Assets
- Bilingualism in both official languages (English and French).
- Experience with IBM Cognos Business Intelligence Technologies (Report Studio, Framework Manager, Transformer and Query Studio).
We thank you for visiting the job page. Only candidates closely matching the requirement will be contacted for interview. Wishing you all the best in your job search.
About OGGN Inc.
Based in the vibrant National Capital Region of Canada, we specialize in cutting-edge services tailored for diverse industries. Our offerings include strategic Advisory solutions, thorough Assessments, seamless Implementation, Recruitment and Staffing services. We excel in Data (covering Maturity, Governance, Architecture, Analysis and Security), AI, ML, RPA, Cloud (Assessments, Migrations, Vendor Recommendations), Agile methodologies, and a range of other Professional Services. Trusted by the public sector, private sector, not-for-profit organizations, crown corporations, startups, and Fortune companies, we bring innovation and excellence to various industry verticals.
Our key services and product offerings in Data and AI (www.ElevateX.ai) enables clients to fast-track and adopt GenAI and AI in their ecosystem.
Service Offerings: • Data, Automation, AI/ML and Operations: Implementation, Strategy, Approach, Deployment of AI/ML, RPA, and Ops (DevOps, DevSecOps, AIOps) • Consulting Services: Management, Agile, Scrum, Business, Technology, QA, Integrations, Healthcare Informatics, Content Management, Digital Transformation, Advisory Services • Cloud Services: Cloud Technology Solutions, Migration, Transformation, Modernization, Security, Audits, Assessments, and Recommendations • Recruitment & Staffing: Our deep business & technology expertise, local & global networks allow us to provide top talent be it contract or full-time
Government Procurement Vehicles:
-
Artificial Intelligence (AI) Source List. Qualified and accepted to be on the AI source list to provide responsible and effective AI services, solutions and products.
-
TSPS, Tier 1 and Tier 2 Supply Arrangement Holder.
-
TBIPS, Tier 1 Supply Arrangement Holder.
-
Ontario Ministry of Government and Consumer Services (MGCS).
Connect with us via our Website | Email: info@oggninc.com | LinkedIn