Job Description

Responsibilities The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.
Responsibilities:
Knowledge in RDBMS(Oracle preferred) and Data Warehouse concepts.
Excellent knowledge of SQL, PL/SQL (ideally Oracle 11g/12c/19c)
Hands-on experience in Loading database tables based on external files.
Hands-on experience in migration project like Sybase IQ/Others to Oracle and other RDBMS.
Good in writing packages/Stored Procedures, functions based on existing script or code in other tech stack.
Very good in optimizing view/SP SQL and able to create, alter views.
Hands-on expertise in performance tuning, optimization and advanced PLSQL.
Hands-on experience in analyzing the query plans and make changes to improve the performance accordingly.
Develop packages/procedures and scripts for data migration & provide timely scheduled management reporting
Hands-on experience in Partitioning tables, partition exchange, global temporary tables, compute stats and index management.
Knowledge of Scripting Languages like shell for automating the tasks.
Create logical and physical data models adheres to CITI best practices to ensure high data quality and minimal redundancy.
Maintain conceptual, logical and physical data models along with corresponding metadata.
Optimize and update logical and physical data models to as per enhancement or new request.
Follow best practices for standard naming conventions and coding practices to ensure consistency of data models.
Evaluate data models and physical databases for variances and discrepancies.
Qualifications:
4 years of relevant experience in SQL, PL/SQL
Experience in Data warehousing, data analysis, database design and ETL concepts
Consistently demonstrates clear and concise written and verbal communication
Demonstrated problem-solving and decision-making skills
Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
Education:
Bachelors degree/University degree or equivalent experience
Education: Any Graduate
Industry: Banking

Skills Required