ETL Application analyst
Chennai, Tamil Nadu
Primary Location: India,Tamil Nadu,Chennai
Education: Bachelor's Degree
Job Function: Technology
Schedule: Full-time
Shift: Day Job
Employee Status: Regular
Travel Time: Yes, 10 % of the Time
Job ID: 19013746


Job Title: Apps Dev Sr. Programmer Anlyst
Business: Institutional Clients Group (ICG) Technology
Function: Treasury and Trade Solutions
C Level/Officer Title: C12/AVP
Job Location: Chennai

Function Overview:
Citi’s Treasury and Trade Solutions group is built on the power of our network. Citi Treasury and Trade Solutions (TTS), provides integrated cash management and trade finance services to multinational corporations, financial institutions and public sector organizations across the globe. With a full range of digital and mobile enabled platforms, tools and analytics, TTS continues to lead the way in delivering innovative and tailored solutions to its clients. TTS offers the industry’s most comprehensive suite of treasury and trade solutions including cash management, payments, receivables, liquidity management and investment services, working capital solutions, commercial card programs, trade finance and services
TTS counts 80% of Global Fortune 500, over 1,100 public sector entities and thousands of financial institutions amongst its diverse client base
Doing business In 160 countries and jurisdictions, and transacting in over 140 currencies, TTS processes some USD 4.0 trillion of client payments everyday
Collaborates with clients to deliver next-generation financial solutions using TTS Innovation Labs

Application/Team Overview:
Citi’s STARS application is used by customer service and operations staff to enter, research, track, and resolve customer inquiries and investigations. The STARS application supports both Cash and Securities businesses, and is a mission-critical 24x7 global application
The STARS application consists of a number of technical components, including Pega7 platform, web servers, application servers, middleware, and database assets. Pega7 product is highly regarded in the BPM/BRE market, and the Pega Application Developer will gain valuable experience working in a large, dynamic banking environment
The Apps Developer will develop, enhance, and maintain application, support of onshore and offshore development and testing teams, and act as Level 3 resource for the global Production user base

Role Description:
Act as an owner in designing the application, and provide direction for system integration points with continuous focus towards building high quality software, and be a to-go person for any technical roadblocks
Contribute to complex design projects and has expert Pega7 and Pega 8 knowledge based on in-depth experience and history of successful projects
Manage technical implementation tasks to ensure work is delivered on-time and on-budget
Use Pega7 architecture, security model, and service interfaces to build effective software solution
Ability to translate complex business requirement into functional technical requirement using DCO and available industry standard tools
Ensures that systems are built for change, are reusable, and are maintainable
Development support and design consultation for development activities
Effectively troubleshoot technical issues as they arise during the project life cycle
Performance monitoring, tuning and optimization
Interaction with the Production Support and Development Teams (Citi and Vendor) to deliver end-user support, defect resolution, etc. To include emergency off-hours support
Interaction with partner development, testing, and support teams to deliver end-to-end solutions
Candidate should be willing stretch to overlap with NY and/or Asia hours, when project demands


Detail Role Specifications & Requirements:
Bachelor degree (in science, computers, information technology or engineering) Or, Master degree in Computer Science

Technical/Functional Proficiency:
Be proficient/expert in ETL tool Data Stage and Talend
Experience in working multiple OS (Unix, Linux, Win)
Experience in working Scripting
Experience in performance tuning of large technical solutions with significant volumes
Strong understanding of database queries (Oracle/SQL)

Leadership Skills:
Builds talent and teams for Citi by creating a culture of meritocracy and transparency, and celebrating excellence, initiative and courage
Enables economic value and positive social impact for clients, companies, governments, and communities
Works collaboratively across the firm and encourages others to achieve the best results for Citi and our clients
Ensures systemically responsible outcomes while driving performance and balancing short- and long-term risks
Sets high standards and achieves performance objectives by creating a clear path toward ethical and sustainable results