29 Sep
|
Citigroup
|
Pune
We are seeking a highly skilled Senior Oracle PL/SQL Developer / Oracle Lead to join our agile team. As a Senior Oracle Developer, you will be responsible for designing, developing, testing, and implementing Oracle-based solutions to meet our business needs. You will work closely with our cross-functional teams to analyze requirements, develop technical specifications, and deliver high quality solutions. **Responsibilities:** + Design, develop, test, maintain, and optimize Oracle database solutions, including PL/SQL packages, procedures, functions, triggers, ETL processes, data migration scripts, and performance-tuned database objects. + Develop and support Oracle database solutions, including packages, stored procedures, functions, triggers, views, materialized views, and sequences, ensuring high performance, scalability, and maintainability. + Create and maintain database migration scripts, schema updates, release deployment packages, and automated database deployment processes. + Design, build, and support ETL workflows, data transformation processes, validation frameworks, and batch data processing solutions. + Troubleshoot and resolve database issues, data quality concerns, application integration challenges, and performance bottlenecks across environments. + Perform database performance tuning and optimization using execution plans, indexing strategies, partitioning, optimizer statistics, and Oracle diagnostic and monitoring tools. + Support CI/CD initiatives, implementing automated testing, deployment, monitoring, and compliance practices for database solutions. + Develop and support database unit testing, regression testing, data validation testing, and automated test support for SQL, PL/SQL, ETL, and data migration changes.
+ Leverage AI-powered development tools to accelerate SQL and PL/SQL development, code review, troubleshooting, documentation, testing, and knowledge-sharing activities. + Experience in designing tables, data analysis, wiring complex queries (SQL and PL/SQL), performing tuning and table partitions. + Experience with GitHub Copilot or other Dev Assist tools and capabilities + Collaborate with business analysts and stakeholders to gather requirements and translate them into technical specifications. + Troubleshoot and debug issues. + Conduct code reviews, performance tuning, and optimization to ensure code quality and efficiency. **Requirements** + Bachelor's degree in computer science, information technology, or related field. + 8+ years of experience as an Oracle developer, with a proven track record of designing and implementing complex database solutions + Experience working in an Agile environment and familiarity with agile methodologies. + Excellent problem-solving skills and attention to detail. + Robust communication and interpersonal skills, with the ability to affectively collaborate with cross functional teams. + Experience with Git and continuous integration / continuous deployment pipelines **Nice to have** + Oracle Certification + Knowledge of other database technologies (e.g., MongoDB, SQL Server)
+ Experience of using Tableau with Oracle + Starburst or other Data virtualization technology experience + Python Development experience **#LI-KR5** ------------------------------------------------------ **Job Family Group:** Technology ------------------------------------------------------ **Job Family:** Applications Development ------------------------------------------------------ **Time Type:** Full time ------------------------------------------------------ **Most Relevant Skills** Please see the requirements listed above. ------------------------------------------------------ **Other Relevant Skills** For complementary skills, please see above and/or contact the recruiter. ------------------------------------------------------ _Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law._ _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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi's_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
📌 Oracle PLSQL Lead Developer (Pune)
🏢 Citigroup
📍 Pune