JPMorgan Software Engineer III 

India, Maharashtra, Mumbai 

23006527

Job responsibilities

• Design, develop, and optimize complex PL/SQL procedures and functions.
• Perform SQL tuning and optimization to enhance performance.
• Implement resilient setups, including partitioning, indexing, clustering, and debugging.
• Develop and manage materialized views to improve query performance and data retrieval.
• Lead migration efforts of complex procedures to SQL, ensuring seamless integration and functionality.
• Design and implement Snowflake solutions, including external tables and dynamic queries.
• Manage sharing objects and visibility settings to ensure secure and efficient data access.
• Develop and optimize materialized views for enhanced data processing.
• Facilitate data movement in and out of Snowflake, ensuring data integrity and security.
• Optimize compute resources and monitor costs to ensure efficient and cost-effective operations.

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 3+ years applied experience
• Extensive hands-on experience in Oracle PL/SQL development and Snowflake implementation.
• Proven track record in SQL tuning, resilient setups, and migration of complex procedures.
• Strong understanding of materialized views, partitioning, indexing, and clustering in Oracle.
• Experience with external tables, dynamic queries, and compute optimization in Snowflake.
• Proficient in debugging and optimizing database systems for performance and reliability.
• Solid understanding of data sharing, visibility, and security best practices.
• Knowledge of cost monitoring and optimization strategies in Snowflake.
• Excellent communication skills to work effectively with cross-functional teams.
• Ability to provide technical leadership and mentorship to junior developers.

Preferred qualifications, capabilities, and skills

• Familiarity with cloud-based data solutions and integration strategies.
• Exposure to modern data visualization and reporting tools.
• Proficiency in Java and Python for enhanced software development capabilities.
• Experience with AI/ML technologies to drive innovation and data-driven insights.
• Passion for exploring new technologies and driving innovation in database systems.