Sr Abinitio ETL Developer/Engineer

Back

Sr Abinitio ETL Developer/Engineer

@ CGI

Your future duties and responsibilities:

  • Develop and Unit Test Ab Initio Code
  • Perform Maintenance and Support Activities for application
  • Develop /Update Unix shell scripts
  • Develop and maintain Autosys scripts
  • Design processes that can extract/receive data from various heterogeneous source systems
  • Perform data cleansing and transforming the data according to business rules
  • Develop reusable frameworks for data extraction, loading and cleansing
  • Build capabilities to exchange the data with external partners in various formats (XML, CSV, Flat File, ..)
  • Support System Integration Testing (SIT) and User Acceptance Testing (UAT) as needed


Qualifications:

Required qualifications to be successful in this role:

  • 4-5 years of relevant experience
  • Prior experience with Agile Methodology and Dev Ops
  • JIRA (or other similar)
  • Confluence (or other similar)
  • Work with product owners and other development team members to determine new features and user stories needed in new/revised applications or large/complex development projects.
  • Participate in code reviews with peers and managers to ensure that each increment adheres to original vision as described in the user story and all standard resource libraries and architecture patterns as appropriate.
  • Serve as a technical lead for an Agile team and actively participate in all Agile ceremonies.
  • Participate in all team ceremonies including planning, grooming, product demonstration and team retrospectives.
  • Mentor less experienced technical staff; may use high end development tools to assist or facilitate development process.
  • Data Modeling practices/ concepts
  • Database Concepts (SQL, Joins, Normalization)
  • Databases - Oracle, SQL Server
  • Database performance & Tuning/ query optimization
  • SQL (complex queries, store procedures, partitions, PL/SQL, cursors)
  • Data quality enforcement/ practices/ concepts
  • Use of AWS technologies for building, deploying, and operating applications
  • Understanding of core AWS services and basic AWS architecture best practices (S3,EBS,EC2,SQS/SNS,CloudFront,Route53,Lambda,Cloudwatch,ECS Fargate,API Gateway)
  • Proficiency in developing, deploying, and debugging cloud-based applications using AWS ETL native tools
  • Ability to use a CI/CD pipeline to deploy applications on AWS
  • Understanding of the use of containers in the development process
  • RDS - PostGreSQL / S3
  • Architecting and supporting DataMart load processes
  • Designing and building change data capture processes and updating the DataMart accordingly
  • CICD and Version Control Experience with Jenkins and GIT
  • Experience working in an Agile Environment
  • Team Work, Communication, Problem Solving, Self-Organized and Decision Making


EDUCATION REQUIREMENTS

  • Bachelor degree in Computer Science, Information Systems or related field
  • Professional certification(s) desired
  • Post-graduate degree desired


Skills:

  • Confluence
  • Jenkins
  • Jira
  • SQL


How to Apply:

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

Visit Site to Apply

Location: Lafayette, LA
Date Posted: April 11, 2022
Application Deadline: June 13, 2022
Job Type: Full-time