Senior Data Specialist

Job Description

Location(s): Tower -11, (IT/ITES) SEZ of M/s Gurugram Infospace Ltd, Vill. Dundahera, Sector-21, Gurugram, Haryana, Gurugram, Haryana, 122016, IN Line Of Business: Data Estate(DE) Job Category: Engineering Technology Experience Level: Experienced Hire At Moodys, we unite the brightest minds to turn today s risks into tomorrow s opportunities. We do this by striving to create an inclusive environment where everyone feels welcome to be who they are-with the freedom to exchange ideas, think innovatively, and listen to each other and customers in meaningful ways. If you are excited about this opportunity but do not meet every single requirement, please apply! You still may be a great fit for this role or other open roles. We are seeking candidates who model our values: invest in every relationship, lead with curiosity, champion diverse perspectives, turn inputs into actions, and uphold trust through integrity. Job Summary: We are seeking an experienced Senior Data Specialist to join our team. The ideal candidate will have extensive hands-on experience with the latest Oracle database versions and Databricks, particularly in a large enterprise environment. You will be responsible for designing, developing, optimizing, and maintaining complex SQL and PL/SQL solutions to support business analysis and data transformations. Key Responsibilities: Design and develop advanced PL/SQL packages, procedures, and triggers for high-volume transactional systems. Write and optimize complex SQL queries for efficient data retrieval and manipulation. Leverage Oracle analytical functions, collections, and advanced features to build high-performance solutions. Perform query performance tuning using optimizer hints and execution plan analysis. Collaborate with cross-functional teams to support application development and data integration. Work within large-scale enterprise database systems, ensuring high availability and data integrity. Provide support for database design, schema management, and data modeling activities. Document technical specifications, procedures, and best practices. Required Skills and Qualifications: Minimum 5 6 years of hands-on experience with Oracle Database (latest versions preferred). Proven experience working in large-scale enterprise database environments. Strong expertise in SQL and PL/SQL programming, including the ability to write complex logic and efficient code. In-depth understanding of Oracle analytical functions, collections, and advanced PL/SQL features. Solid knowledge and hands-on experience in query tuning using optimizer hints. Experience with Python and HTML for scripting and integration tasks. Experience with DataBricks. Excellent verbal and written communication skills. Preferred Qualifications: Bachelor s degree in Computer Science, Information Technology, or a related field. For more information on the Securities Trading Program, please refer to the STP Quick Reference guide on ComplianceNet Please note: STP categories are assigned by the hiring teams and are subject to change over the course of an employee s tenure with Moody s.