Our Client in the Public Sector is looking for a Senior ETL consultant on a 12 month contract
10+ years
ETL Developer/Data Specialist/Analyst
Must Haves:
5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools.
Experience enhancing performance of ETL code and SQL Queries.
...
Experience Designing Data warehouse components and ETL Scripts.
Experience performing the design of data warehouse and related components.
Experience with systems design and development, and related methods, techniques, practices and standards.
Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
Agile, Waterfall
Nice to Haves:
Public Sector
Advantages
Long term Contract
Pay Every week
Office is located near College Subway Station
2-3 days working from home
Responsibilities
Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organziation's I&IT Systems including the use of Oracle Data Integrator and Informatica ETL tools. The Specialized IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance.
Qualifications
Working knowledge of the entire Data Dictionary, data mapping.
Working knowledge of the Business Process Design Re-engineering for applications.
5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools.
Experience enhancing performance of ETL code and SQL Queries.
Experience developing ETL routines using Informatica and/or SSIS in a data warehousing environment or large data migration.
Experience Designing Data warehouse components and ETL Scripts.
Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.
5+ years of experience with Unix scripting.
Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex korn-shell scripts.
Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.
Experience in developing the Application Code package using MS Visual Source Safe Demonstrated experience performing system testing, unit testing, and user acceptance testing.
Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
Experience in leading development and modelling of applications, specifically hierarchical data model applications.
Summary
Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organziation's I&IT Systems including the use of Oracle Data Integrator and Informatica ETL tools. The Specialized IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
Our Client in the Public Sector is looking for a Senior ETL consultant on a 12 month contract
10+ years
ETL Developer/Data Specialist/Analyst
Must Haves:
5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools.
Experience enhancing performance of ETL code and SQL Queries.
Experience Designing Data warehouse components and ETL Scripts.
Experience performing the design of data warehouse and related components.
Experience with systems design and development, and related methods, techniques, practices and standards.
Working Knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure support projects.
Agile, Waterfall
Nice to Haves:
Public Sector
Advantages
Long term Contract
Pay Every week
Office is located near College Subway Station
2-3 days working from home
Responsibilities
...
Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organziation's I&IT Systems including the use of Oracle Data Integrator and Informatica ETL tools. The Specialized IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance.
Qualifications
Working knowledge of the entire Data Dictionary, data mapping.
Working knowledge of the Business Process Design Re-engineering for applications.
5+ years of demonstrated experience and skills using Oracle Data Integrator and/or Informatica ETL tools.
Experience enhancing performance of ETL code and SQL Queries.
Experience developing ETL routines using Informatica and/or SSIS in a data warehousing environment or large data migration.
Experience Designing Data warehouse components and ETL Scripts.
Experience using PowerDesigner to review data models, as well as make changes and generate DDL's.
5+ years of experience with Unix scripting.
Experience working with Oracle Databases (version 10.x or higher), DB2 Database, and with complex korn-shell scripts.
Experience in designing RDBMS SQL, DML and DDL (DB2 and Oracle) and the architectural implications associated with each platform in regards to ETL.
Working experience in debugging mappings, transformations, mapplets and source qualifier files and Unit testing the newly developed ETL components.
Experience in developing the Application Code package using MS Visual Source Safe Demonstrated experience performing system testing, unit testing, and user acceptance testing.
Demonstrates development and solution design experience in an environment where Oracle, Informatica and Cognos are used together for data warehousing and business intelligence.
Demonstrate experience designing, developing and implementing Reports, Dashboards and other Business Intelligence solutions using Cognos 10 or higher and Microsoft Power BI.
Experience in leading development and modelling of applications, specifically hierarchical data model applications.
Summary
Works in partnership with clients, advising them how to use information management (IM) and/or information technology in order to meet their business objectives or overcome problems, work to improve the structure and efficiency of an organziation's I&IT Systems including the use of Oracle Data Integrator and Informatica ETL tools. The Specialized IT Consultant may be used to provide strategic guidance to organizations with regard to IM and Task-based IT technology, IT infrastructures and the enablement of major business processes through enhancements to IT. they can also be used to provide subject matter expertise during the procurement as well as providing highly expert technical assistance.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
