Are you looking for a New Job or Looking for better opportunities?
We got a New Job Opening for
Full Details :
Company Name : Citi
Location : Chennai, Tamil Nadu
Position : C10 -Oracle Data Model/PLSQL – Chennai (R22006864)
Job Description : The Applications Development 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:
Excellent Knowledge in RDBMS(Oracle) and Data Warehouse concepts.
Excellent knowledge of SQL, PL/SQL (ideally Oracle 11g/12c/19c) along with query tuning and optimization
Hands-on experience in Loading database tables based on external files.
Hands-on experience in migration project like Sybase IQ/Others to Oracle.
Concept on banking ERD and DWH models.
Very good understanding on business requirements and expertise on translating the same into data models.
Analyze data-related system integration challenges and propose better solutions.
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 experience in Unix & shell scripting
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.
Evaluate data models and physical databases for variances and discrepancies.
Perform reverse engineering of physical data models from databases and SQL scripts.
Qualifications:
4+ years of relevant experience in Data modeling , RDBMS, SQL (Oracle SQL, PL/SQL), Unix scripting.
Hands-on 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:
Bachelor’s degree/University degree or equivalent experience
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
–
Job Family Group:
Technology
–
Job Family:
Applications Development
–
Time Type:
Full time
–
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries (“Citi”) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View the “EEO is the Law” poster. View the EEO is the Law Supplement.
View the EEO Policy Statement.
View the Pay Transparency Posting
This post is listed Under Chennai jobs
Disclaimer : Localpublic.in works to publish latest job info only and is no where responsible for any errors. Users must Research on their own before joining any company