Apps Dev Intmd Programmer Analyst - C11 - PUNE

Team/Function Overview

Markets Data team is building the next generation Data fabric to solve for Business, Analytics and growing regulatory needs. Vast amounts of data assets have been accumulated through the years. Data fabric built on emerging technologies will facilitate the data being inspected, cleansed, transformed for support decision-making

Role / Position Overview

Olympus (Re-platforming of Ocean), the regulatory reporting infrastructure is being re-built strategically starting with Equities. As part of Olympus build out, the developer will be working on to rebuild the Markets data Risk Enterprise Program on Cancel & Corrects along with Open and Unconfirmed trades data.

We need a strong database developer with thorough understanding of advanced Database concepts to understand the existing application and then migrate the same to Olympus. The specific skill sets required are exposure to any RDBMS Database, Python, PySpark or JavaSpark. Experience in any ETL Tools is a good to have skill set.

Key Responsibilities:

The role will include but not be limited to the following:

• Design/implement data objects using Data Warehousing methodologies including Oracle or similar relational database tools, SQL and PL/SQL. Implement DWH solution using Spark SQL  and Python on Big Data.
• Identify re-usable database components and develop recommendations for ALPS target architecture
• Align to database programming standards and best practices.
• Develop ETL jobs using Talend 8x for processing of data in a Datawarehouse.
• Collaborate with project teams to refine functional requirements and translate into technical architecture/design
• Continuously monitor/tune database performance identifying potential issues/opportunities for improvement and outline recommendations to improve performance
• Work with development teams ensuring adherence to database standards
• Oversee change management process for database objects across multiple projects
• Accountable for delivery of the database objects through SIT, UAT and Production.
• Liaise with clients to determine requirements and interpret into solutions
• Mentoring and training of junior team members

Development Value:

Candidate has the opportunity to be a major contributor to the Citi Markets Data Strategy and contribute towards the goal of increasing revenue using key metrics for decision making. The candidate will work with bright and innovative individuals both on the business and technology side and the successful candidate can make a significant difference to the business performance.

Team/Function Overview

Markets Data team is building the next generation Data fabric to solve for Business, Analytics and growing regulatory needs. Vast amounts of data assets have been accumulated through the years. Data fabric built on emerging technologies will facilitate the data being inspected, cleansed, transformed for support decision-making

Role / Position Overview

Olympus (Re-platforming of Ocean), the regulatory reporting infrastructure is being re-built strategically starting with Equities. As part of Olympus build out, the developer will be working on to rebuild the Markets data Risk Enterprise Program on Cancel & Corrects along with Open and Unconfirmed trades data.

We need a strong database developer with thorough understanding of advanced Database concepts to understand the existing application and then migrate the same to Olympus. The specific skill sets required are exposure to any RDBMS Database, Python, PySpark or JavaSpark. Experience in any ETL Tools is a good to have skill set.

Key Responsibilities:

The role will include but not be limited to the following:

• Design/implement data objects using Data Warehousing methodologies including Oracle or similar relational database tools, SQL and PL/SQL. Implement DWH solution using Spark SQL  and Python on Big Data.
• Identify re-usable database components and develop recommendations for ALPS target architecture
• Align to database programming standards and best practices.
• Develop ETL jobs using Talend 8x for processing of data in a Datawarehouse.
• Collaborate with project teams to refine functional requirements and translate into technical architecture/design
• Continuously monitor/tune database performance identifying potential issues/opportunities for improvement and outline recommendations to improve performance
• Work with development teams ensuring adherence to database standards
• Oversee change management process for database objects across multiple projects
• Accountable for delivery of the database objects through SIT, UAT and Production.
• Liaise with clients to determine requirements and interpret into solutions
• Mentoring and training of junior team members

Development Value:

Candidate has the opportunity to be a major contributor to the Citi Markets Data Strategy and contribute towards the goal of increasing revenue using key metrics for decision making. The candidate will work with bright and innovative individuals both on the business and technology side and the successful candidate can make a significant difference to the business performance.