DataStage Developer with Python and AWS

Back

DataStage Developer with Python and AWS

@ CGI

Your future duties and responsibilities:

  • Translate requirements and data mapping documents to technical design.
  • Develop, enhance, and maintain code following best practices and standards.
  • Create and execute unit test plans. Support regression and system testing efforts.
  • Debug and problem solve issues found during testing and/or production.
  • Communicate status, issues, and blockers with the project team.
  • Support continuous improvement by identifying and solving opportunities.


Qualifications:

Required qualifications to be successful in this role:

  • Minimum 7 years of experience in Designing and development on IBM DataStage (11.x)
  • Expertise in Data Warehousing ETL Tool DataStage using Components like DataStage Designer, DataStage Director and DataStage Operations Console.
  • Strong understanding of Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodology.
  • Expertise in designing DataStage Server jobs, Parallel Jobs, Job Sequencing, Creating Parameter Sets, Container, Environment Variables and Creating Parallel Routines, Data Cleansing and Writing Transformation expressions to derive values and remove unwanted data. Also should have good working knowledge in different stages like Transformer, look up, merge stage, ODBC connector, Oracle connector etc.
  • In depth experience in troubleshooting of DataStage jobs and addressing issues like performance tuning.
  • Expertise in working and hands-on implementation of AWS services such as Glue, Lambda functions, Redshift and Terraform (good to have)
  • Hands-on experience of working with Python, Spark and Spark
  • Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
  • Should have strong analytic and problem-solving skills.
  • Should have strong Unix shell script skills
  • Should have strong SQL skills with experience of working on Oracle and/or Teradata DB
  • Good communication skills
  • Good team player and co-ordinate with multiple teams
  • Should have experience working in Agile teams in onshore- offshore model
  • Educational Expectations: Bachelor's Degree in Computer Science or Related Field


Skills:

  • IBM WS Datastage Designer
  • Unix
  • Python
  • Spark SQL
  • AWS Developer


How to Apply:

Apply online at https://www.cgi.com/en/careers

Visit Site to Apply

Location: Lafayette, LA
Date Posted: November 22, 2022
Application Deadline: December 22, 2022
Job Type: Full-time