Current opportunities >> Position Details >>

Position Details

Job order - J0921-1993 - Permanent Full Time
Title DataStage Developer
Category Software Development/ Engineering
City Toronto, Ontario, Canada

Job Description DataStage Developer

Position Description
CGI is looking for a DataStage Developer to design, build, and implement ETL solutions. In this role, you will develop processes and frameworks with the DataStage platform to assist with the successful deployment and maintenance of ETL processes.

To ensure success as a DataStage developer, you should be skilled at applying ETL principles and practices, and be able to implement complex solutions to problems at an enterprise level. Ultimately, a top-notch DataStage developer will be able to apply their knowledge to a diverse range of cases.



Your future duties and responsibilities
• Collection of requirements; analysis of the raw data; participation in creation of the ETL design; work with BAs on the ETL flow and Data Analytics, code of the ETL processes.
• System testing, participation in User Acceptance Testing (UAT) and implementation of the process
• Onshore – offshore Coordination
• Adhere to the Agile methodology and for every development and produce necessary documentation that will include plans, diagrams, data dictionaries
• Participate in off hours production support on revolving basis.
• Respond to scheduled and ad hoc requests for off hours resolution of production problems
• Designing and building scalable DataStage solutions.
• Updating data within repositories and data warehouses.
• Assisting project leaders in determining project timelines and objectives.
• Monitoring jobs and identifying bottlenecks in the data processing pipeline.
• Testing and troubleshooting problems in system designs and processes.
• Improving existing ETL processes for the business.
• Providing support to customers about issues relating to the storage, handling, and access of data.



Required qualifications to be successful in this role
Minimum 5 years of experience in ETL development with below skills:

• Working knowledge of IBM InfoSphere Data Stage 11.x / 9.x ETL tool with an ability to deliver efficient, reliable and error-free code,
• Working knowledge on Db2 Database and SQL
• Hands-on experience with designing, creating and maintaining a centralized data repository
• Lead or provide expertise in defining and managing detailed system design for data integration and ingestion (to Data Lakes) processes or data marts/ warehouse builds or extensions.
• Good knowledge of ETL development best practices
• Highly competent working in and creating ETL frameworks to manipulate data
• Good to have - knowledge of Data Warehouse data modeling principles
• Good understanding of db2 / Hive database and fluent in SQL
• Good verbal and written communication skills - articulating and communicating information and ideas to varying audiences and in multiple written styles (persuasive, informative, narrative) in order to work with large/multiple teams.
• Working exp with Global Teams.



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 change—supporting 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 www.cgi.com.

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.




Skills
  • DataStage
  • Application Design
  • Application Development
  • Big Data
  • Financial Services

Reference 860315

Click here to apply