4 days ago
Chennai, IndiaSenior
Responsibilities
- Lead application systems analysis, programming activities, and technical solutions.
- Mentor developers and conduct design, code, and documentation reviews.
- Manage the software development lifecycle from analysis and design through coding, testing, and continuous integration.
- Design, manage, optimize, and troubleshoot relational and NoSQL databases.
- Develop complex SQL and PL/SQL queries, stored procedures, functions, packages, tables, indexes, and other database objects.
- Build data management components and support data sharing between systems.
- Design end-to-end database and data warehouse systems, including data modeling and ETL.
- Implement application security, assess third-party software compatibility, and follow engineering standards.
- Improve database architecture, processes, technologies, and operating standards.
- Communicate with clients and project teams while operating with limited supervision.
Requirements
- Bachelor’s or university degree, or equivalent experience; a master’s degree is preferred.
- At least 5 years of relevant experience in the financial services industry.
- 8–10 years of RDBMS database development experience, preferably with Oracle.
- Extensive experience in system analysis and database application programming.
- Subject matter expertise in database systems and development.
- Proficiency in SQL, complex and analytical queries, PL/SQL, database objects, data manipulation, and database design principles.
- Knowledge of data warehouses, dimensional modeling, ETL, and end-to-end database system design.
- Performance tuning and troubleshooting experience, including Explain/Execution Plan analysis, is a plus.
- Knowledge of database security practices such as privilege control and industry standards.
- Experience with GitHub, Jenkins, and continuous integration tools.
- Strong written and verbal communication skills and the ability to mentor team members.
About Citi
Citi is a public financial-services company offering consumer and institutional banking, credit cards, wealth management, treasury and trade solutions, and capital-markets services. It serves individuals, corporations, financial institutions, and governments in more than 160 countries and jurisdictions, earning interest and fee income from lending, payments, trading, and advisory. Founded in 1812 and headquartered in New York, it trades on the NYSE under the ticker C.