Citi Senior Developer – ETL in Pune, India

  • Primary Location: India,Maharashtra,Pune

  • Education: Bachelor's Degree

  • Job Function: Technology

  • Schedule: Full-time

  • Shift: Day Job

  • Employee Status: Regular

  • Travel Time: No

  • Job ID: 16064024


Job Background/Context:

  • Collaborate with the Technical Manager to plan, design and create ETL programs to address requirements from new data sources

  • Provides guidance on strategies that minimize implementation risk and time and/or improve system reliability and performance

  • Reviews ETL programs developed for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts

  • Conduct root cause analysis and resolve performance/production problems and data issues

  • Provide ongoing maintenance and support of assigned ETL applications

  • Development and maintenance of physical database model

  • Develop queries and stored procedures in SQL on Oracle

  • Development of processes and procedures to monitor and tune databases

Key Responsibilities:

  • Requirement gathering & understanding, effort estimation, technical design, project planning and monitoring

  • Work proactively & independently to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks

  • Providing expertise in technical analysis and solving technical issues during project delivery

  • Customer interfacing - understand customer requirements, propose technical solutions

  • Full Software Development Lifecycle

  • Code reviews, test case reviews and ensure code developed meets the requirements

  • Component Design/ Coding/ Unit Testing/ Debugging

  • Carry out adaptive changes necessitated by changes in Business Requirements and Technology


  • 3-7 years of experience in any ETL techniques

  • Hands on experience with TALEND (TDQ 4.1.3 or higher) highly desirable. Strong knowledge of SQL (ORACLE)


  • Banking experience would be advantage

Skills Required:

  • Must be able to write complex Oracle database stored procedures/packages

  • Comfortable creating scripts in Unix/Java

  • Strong database development capabilities


  • Bachelor’s Degree in Computer Science & Engineering. Master’s Degree in Computer Science & Engineering is a plus

  • Candidate should be willing to work late in the evening India time on need basis in order to interact with US onshore team and to meet urgent requests by Clients