Required Skills

ETL Developer

Work Authorization

  • Us Citizen

  • Green Card

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 30th Jul 2021

JOB DETAIL


CGI has an immediate need for a Sr. ETL Developer to join our financial services team in one of our several CGI Offsite and Onshore Delivery Center locations. This is an exciting opportunity to work in a fast-paced team environment supporting one of the largest leaders in the secondary mortgage industry. We take an innovative approach to supporting our client, working side-by-side in an agile environment using emerging technologies.

• We partner with 15 of the top 20 banks globally, and our top 10 banking clients have worked with us for an average of 26 years!
• We have over 73,000+ CGI Members in 40 countries and over 5k+ loyal Clients who are leveraging our end-to-end services across the globe

Description
The candidate will be required to be a solid Ab Initio Developer with excellent technical and communication skills. The candidate must be motivated and must be able to perform on their own with little or no guidance.

Your future duties and responsibilities:
As part of this role, it is required to solve moderately complex problems that require some independent thinking while adhering to agile practices, coding standards, testing methods and source management guidelines established by the IT group. In addition, the candidate will need to be part of regular code reviews from their peers and senior staff.

The candidate should be good at problem solving, independently interact with Business users and external partners/vendors for soliciting requirements of what needs to be coded. The candidate will be required provide guidance to junior level developers. Be able to articulate opinions on software development issues to team or work group. Demonstrate an understanding and adherence to Client vision, values, and principles. Must be able to adjust and cater to changing needs from business as they evolve. Foresees potential technical issues and recommends approaches to solve issues. Exhibits positive can do attitude towards peers, colleagues, and customers.​

Required qualifications to be successful in this role:
• Interact with external vendors and internal business/product owner team to understand the business requirements
• Analyze requirements/user stories and come up with Technical design
• Work with Database Administrators, Data Modelers, Business Analysts on solution design and implementation
• Develop and Unit Test Ab Initio Code
• Perform Maintenance and Support Activities for application
• Develop /Update Unix shell scripts
• Develop and maintain Autosys scripts
• Architecting and supporting DataMart load processes
• Designing processes that can extract/receive data from various heterogeneous source systems, perform data cleansing and transforming the data according to business rules
• Developing reusable frameworks for data extraction, loading and cleansing
• Designing and building change data capture processes and updating the DataMart accordingly
• Building capabilities to exchange the data with external partners in various formats (XML, CSV, Flat File etc.)
• Support System Integration Testing (SIT) and User Acceptance Testing (UAT) as needed
• Identify and implement innovation/process improvements and contribute to business value add activities
• Work with Release Management on Production Implementation Planning and support release activities
• Provide guidance to junior developers as needed
• Ability to work in a fast paced Agile environment.
• Key Skills Needed: Ab Initio, Autosys, Unix Shell Scripts, Oracle DB, SQL Server DB, PL/SQL, Jenkins, Confluence, JIRA.
Desired qualifications
​• Prior experience with Agile Methodology and Dev Ops
• Python and AWS (RDS/RedShift/S3)

Company Information