Oracle PL/SQL Developer

Job Description

This is an excellent opportunity to join the Index IT team, as part of a delivery-focused IT group responsible for designing, developing and supporting internal, client and public-facing distribution solutions. If selected, you will work as part of a delivery focused and talented software development team responsible for designing, developing and supporting the index and product generation platforms. You will use cutting edge software development techniques and technologies, following the best practices of the industry. MSCI provides a very attractive compensation package, an exciting work environment and opportunities for continuous self-development and career advancement for the right candidates. Your Key Responsibilities Design, develop, and maintain database structures and data pipelines in Snowflake and Oracle environments Write efficient SQL queries, stored procedures, and functions to support application requirements Create and optimize ETL processes for data migration between different database platforms Implement database security measures and access control protocols Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions Develop Python scripts for data processing, analysis, and automation Monitor database performance and recommend optimization strategies Participate in code reviews and implement best practices for database development Create and maintain comprehensive documentation for database structures and processes Required Qualifications Bachelor's degree in Computer Science, Information Technology, or related field 5+ years of experience with Software/database development. 3+ years of experience with Relational database development Python programming skills, particularly for data manipulation and analysis Proficiency in SQL query optimization and performance tuning Experience with ETL/ELT processes and data migration strategies Knowledge of database security best practices Strong analytical and problem-solving abilities Preferred Qualifications Experience with Snowflake data warehouse architecture and development Experience with Oracle databases or Oracle cloud infrastructure. Knowledge of data modeling and dimensional modeling concepts Familiarity with version control systems (Git) Experience with CI/CD pipelines for database changes Background in financial services or experience with financial data Understanding of agile development methodologies Certification in Snowflake, Oracle, or related technologies