Officer-Ab Initio ETL Developer-C11-Hybrid-Pune

The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

Responsibilities:

• The candidate will be responsible for developing and maintaining systems within SMC ETL stream.

• Work on Client Onboarding and managing reference data static domain tables.

• Work directly with global application development teams, Operations teams/partners to successfully integrate application data.

• Perform unit testing with proper documentation to adhere to application standards.

• Work closely with other team members, onsite and remote to ensure consistent approach to development is used within the application.

• Engage in architecture definition of new processes and review existing processes for improvements.

• Involve in in strategic Tech Migration initiative to setup the ETL architecture.

• Provide on-going maintenance and L3 production support

• Keep up to date with new technologies and their possible adoption within ISG 

• Work on data initiatives within ISG (Automation and utilities)

Qualifications:

• 5+ years of relevant experience in the Financial Service industry

• Knowledge/Experience: 

  • Experience in Abinitio / DataStage and working with relational databases.

  • Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle 

  • Knowledge and experience working with Batch and realtime processes (including micrographs).

  • Experience of working in a demanding and results driven, time critical environment 

• Required Skills:

  • Ab Initio GDE and Co>Op / Datastage ETL Tool

  • Linux/Unix scripting

  • Oracle concepts, SQL, PL/SQL

  • SQL performance tuning

  • Autosys

• Skills that are a plus:

  • Understanding of Securities Reference Data system.

  • Python

  • Java

  • Understanding of ECS architecture / implementation

Education:

• Bachelor’s degree/University degree or equivalent experience