Citi Group Applications Development Senior Programmer Analyst 

United States, Florida, Tampa 

203211188

Duties: Design and develop database for large-scale, real-time trade processing and settlement systems. Assess efficiency of business-critical data, identify right data structure, and provide solutions for complex business cases in real time trade processing, accounting, confirmation and settlement process in multi-threaded applications. Develop and optimize database stored procedures or queries using Structured Query Language (SQL), Procedural Language (PL) extension to SQL and Oracle database. Analyze country-specific business requirements of Fixed Income, Foreign Exchange, Money Markets and Quantum Local Markets products for settlement system. Implement cash settlements in applications as per country-specific clearing systems. Design database tables as per business requirements. Prepare and execute database scripts from development to production environment using principles of normalization and SQL. Handle transactions in fail-safe manner using Serializability, Concurrency Control and Locking features. Conduct Extract, Load and Transform (ETL) of data sent by partner systems as per requirements of application. Replicate production data into necessary pre-production user acceptance environment needed to test regulatory reporting enhancements. Design applications backend database using scripting, writing stored procedure and optimizing database programs. Implement optimization routine for long-running database programs and queries. Design and construct software. Maintain quality and optimized coding with proper documentation. Develop unit test plan, perform unit testing and provide continuously improved product experience. Review development team's deliverables for functional and technical implementations and ensure compliance with coding standards and product requirements. Conduct technical design throughout entire lifecycle of development project. Provide database design and optimize data model or database programs associated with application performance. Develop components and processes to ensure safe build and deploy procedures for each module. Validate post-production activity such as environment checks and integration tests for code promotion assurance. Document review comments using Bitbucket. Add integration tests and unit tests for developed functionality. Publish results to management. Develop continuous integration tests and test cases to ensure application stability and functional assurance. A telecommuting/hybrid work schedule may be permitted within a commutable distance from the worksite, in accordance with Citi policies and protocols.

Requirements: Requires a Bachelor’s degree, or foreign equivalent, in Computer Science, Engineering (any) or related field and 5 years of progressively responsible, post-baccalaureate experience as a Systems Analyst, Applications Development Senior Programmer Analyst, Technical Lead, or related position involving software implementation for the financial services industry. 5 years of experience must include: Data extraction, loading and validation using oracle stored procedures and PLSQL programming; Data structures and algorithms; Database archival processes, capacity planning, and security involving Personally Identifiable Information data; Serializability, concurrency control and locking features; Application performance tuning and query optimization; Autosys and Oracle Recovery Manager; Java, J2EE, JSP, Struts, Spring framework (IOC, JMS, and LDAP) and Spring Core libraries; Enterprise Messaging Service, Messaging Queue and Web services; Continuous Integration and Continuous Deployment practices using Unix shell scripting on Teamcity and Udeploy; and Fixed Income, Foreign Exchange asset classes products. 3 years of experience must include: Oracle, ORAAS, SQL Server, Sybase, Java and Cloud Service architecture and principles. Applicants submit resumes at https://jobs.citi.com/. Please reference Job ID #25821054. EO Employer.

Wage Range: $146,120 to $146,120

Anticipated Posting Close Date:

View the " " poster. View the .

View the .

View the