Software Engineer III- Informatica & Java

Description

We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.

As a Software Engineer III at JPMorgan Chase within the Corporate Technology: Corporate Oversight and Governance Tech, you serve as a seasoned member of an agile team to design and deliver trusted market-leading technology products in a secure, stable, and scalable way. You are responsible for carrying out critical technology solutions across multiple technical areas within various business functions in support of the firm’s business objectives.

Job responsibilities

* Design and develop robust ETL workflows using Informatica

* Write, debug, and optimize complex SQL queries and stored procedures

* Deploy and monitor ETL jobs in various environments

* Troubleshoot and resolve issues in Informatica jobs and underlying data pipelines

* Perform root cause analysis on database and performance issues

* Collaborate with data architects and analysts to understand requirements

* Maintain and enhance existing Informatica mappings and workflows

* Implement error handling, logging, and performance tuning strategies

* Participate in code reviews and enforce development standards

* Ensure data quality and integrity across ETL processes

Required qualifications, capabilities, and skills

Formal training or certification on software engineering concepts and 3+ years applied experience

Strong SQL skills with experience in writing complex joins and stored procedures

Experience with at least one RDBMS (e.g., Oracle, SQL Server, or PostgreSQL)

Ability to debug and troubleshoot ETL and database issues independently

Experience with job scheduling tools like Autosys, Control-M, or similar

Familiarity and hands experience with performance tuning techniques for Informatica and SQL

Possesses a solid grasp of data warehousing principles and expertise in data modeling

Capable of adhering to Agile or iterative development approaches

Experience working in production support and handling incident escalations

Experience with Git or bitbucket

Experience with DevOps and CI/CD for ETL pipelines

Preferred qualifications, capabilities, and skills

* Working knowledge of Java

* Experience with cloud-based data integration (e.g., AWS Glue, S3)