Lead Software Engineer - Data Engineer - Oracle PL/SQL, Informatica
Lead Software Engineer - Data Engineer - Oracle PL/SQL, Informatica
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
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 Banks 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.
Employment Type
Full-Time
