JPMorganChase
Lead Software Engineer - Data Engineer - Oracle PL/SQL, Informatica
Be an Early Applicant
As a Lead Software Engineer, you will drive data management innovations and lead the development of ETL processes within an agile team.
Job Description
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
Required qualifications, capabilities, and skills
Preferred qualifications, capabilities, and skills
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.
Top Skills
Data Lake
Data Warehouse
ETL
Informatica
Java
Oracle
Pl/Sql
Postgress
Python
Snowflake
SQL
Similar Jobs at JPMorganChase
Financial Services
As a Lead Solutions Analyst, you will analyze data, drive technical delivery, and translate business requirements into effective solutions while mentoring team members.
Top Skills:
AgileData Visualization PlatformsScrumWaterfallYardi
Financial Services
Lead the development and innovation of AI applications focusing on ML and Generative AI technologies, and deploy scalable solutions.
Top Skills:
AWSJavaPythonPyTorchTensorFlow
Financial Services
The Planning & Analysis Associate will support financial processes, reporting, and ad-hoc analysis, ensuring data integrity and compliance while partnering with senior management for insights and recommendations.
Top Skills:
AlteryxEssbaseExcelPowerPointSAPTableau
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
