Lead Software Engineer - Data Engineer - Oracle PL/SQL, Informatica

Join our dynamic team and contribute to the advancement of our data management capabilities, driving innovation and excellence in the financial industry.

As a Lead Software Engineer at JPMorgan Chase within the Commercial and Investment Bank's Prime Finance Technology Team, you are an integral part of an agile team that works to enhance, build, and deliver trusted market-leading technology products in a secure, stable, and scalable way.

Job Responsibilities

• Demonstrate proficiency in application, data, and infrastructure architecture disciplines, especially in managing high-volume data.
• Utilize strong Oracle database knowledge, including Oracle, PL/SQL, performance tuning, and ETL-Informatica.
• Handle complex SQL joins, correlated sub-queries, aggregate functions, analytic functions, materialized views, indexing, partitioning, and performance tuning using explain plans.
• Lead the analysis, design, development, testing, and implementation of ETL processes, preferably using Informatica.
• Provide maintenance and support for enterprise-level data integration solutions.
• Implement solutions using Postgress and cloud-based technologies.
• Apply knowledge of Data Lake and Data Warehouse concepts and implementation within an agile software delivery lifecycle.
• Understand and contribute to architecture and design across systems.
• Work proficiently with developmental toolsets to enhance system capabilities
• Manage the issue resolution process for application production problems, ensuring minimal disruption.

• Provide Level 3 support for production and business-as-usual activities, ensuring system reliability and performance
  

Required qualifications, capabilities, and skills

• Formal training or certification on software engineering concepts and 5+ years applied experience.
• Over 10 years of proven experience in database solution implementation and ETL processes.
• Strong analytical skills and the ability to work with complex data sets.
• Excellent problem-solving abilities and attention to detail.
• Ability to work independently and lead projects with minimal supervision.
• Strong communication skills to effectively collaborate with cross-functional teams.
Collaborate effectively within large teams to achieve organizational goals, demonstrating strong team player qualities and project ownership.

Preferred qualifications, capabilities, and skills

• Knowledge of big data technologies, such as Snowflake, and integration experience is a plus.
• Experience with Python and Java is highly advantageous.
• Stay informed about industry-wide technology trends and best practices.