Citi Applications Developer Intermediate Programmer Anlyst in Pune, India

  • Primary Location: India,Maharashtra,Pune

  • Other Location: Asia Pacific, Europe, Middle East, and Africa, Latin America; Canada

  • Education: Bachelor's Degree

  • Job Function: Technology

  • Schedule: Full-time

  • Shift: Day Job

  • Employee Status: Regular

  • Travel Time: No

  • Job ID: 16040048


Job Purpose:

  • To design, implement and maintain business intelligence function that will allow the different constituencies (management, bankers and finance) to obtain the data they require

Job Background/Context:

  • The position is based in Pune, India and will report to the CTC Pune Tech lead

  • The successful candidate will be responsible for developing ETL /DWH solutions developed using SSIS stored procs, T-SQL and other related SQL server technologies

  • Team is looking for candidates to develop and maintain the ETL process for the enterprise data warehouse on Microsoft SQL Server Platform

  • The person will directly report to a Analytics lead in Citi-Pune, India

Key Responsibilities:

  • Interaction with business and team lead to understand the business requirements

  • Produce high quality Technical & Release documents and work in collaboration with other teams

  • Create business rules using SQL stored procedures, functions, triggers to meet project requirements

  • Tune data model and relational implementation to ensure excellent response times

  • Be able to model schema for complex data fetch and data input scenarios

  • Design and develop database infrastructure based upon the business requirements provided by the business stakeholders

  • This will require investigating and learning various internal data models

  • Extend the data model to support new data sources required by the project requirements

  • Create processes to load data from internal sources and outside vendors into environment by using Microsoft SSIS and relational technology

  • Quality assure stored proc output and response times meet business requirements



  • 6-8 years working experience in developing SSIS packages and stored procs on SQL platform

  • Ability to write SQL queries on MS SQL Server

  • Have good understanding of the workings of SQL Server platform, and the workflow of deployment

  • Exposure of MSTR reporting tools is good to have

  • Bachelor’s degree MCA /B.Tech / M.E. / M.Tech (in computers, information technology or engineering)

  • Ability to work as part of global team and independently

  • Interpersonal skills to interact with team members and clients

  • Excellent verbal and written communications skills

  • Candidate should be willing to work extended hours in order to interact with onshore team or as per project demand