Ottawa job board updated daily with only local opportunities!

ETL Technical Analyst


This is a Contract position in Ottawa region, ON posted August 9, 2017.

Job DescriptionETL Technical Analyst Position Description CGI currently has a requirement for a ETL Technical Analyst for a long term contract OR full-time/permanent opportunity in the Ottawa area. The successful candidate will possess the following skills and experience: Your future duties and responsibilities a)Support Informatica upgrade from version 9.5.1 to version 10 b)Analyze data integration requirements for ( ETA, Biometric and other data sources c)Perform Data profiling d)Perform ETL ( Extract Transformation and Load) design and development for Full load and incremental load e)Design informatica ETL/Data Quality process and workflow; f)Work with EDW data modeller, ETL team, architect; g)Conduct performance tests to optimize Informatica processes h)Document of installation and configuration for IT certification i)Document all development and processes all work for future reference j)Provide technical guidance and knowledge transfer by meeting with the development Required qualifications to be successful in this role -At least 10+ years experience as an ERP Technical Analyst -At least 7 years of experience in the last 10 years providing services in a Siebel Data Warehouse and Business Intelligence environment. -Experience in designing OLAP databases and implementing ETL bases solutions. -Experience in setting technical standards for the use of the Siebel’s Data Warehouse and Business Intelligence tool kits. -Experience working with Oracle Business Intelligence Enterprise Edition (OBIEE) for the purpose of conducting repository analysis and design optimization of ETL processes. -Experience in Transact-SOL programming such as store procedures, creation of triggers and creation and maintenance of indexes.. Build your career with us. It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this changesupporting our clients digital journeys and offering our professionals exciting career opportunities. At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create. Be part of building one of the largest independent technology and business services firms in the world. Learn more about CGI at No unsolicited agency referrals please. CGI is an equal opportunity employer. In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation. Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs.