As a Software Engineer III, design and develop ETL workflows, optimize SQL queries, monitor ETL jobs, and collaborate with data teams to meet business objectives.
Job 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
Preferred qualifications, capabilities, and skills
* Working knowledge of Java
* Experience with cloud-based data integration (e.g., AWS Glue, S3)
About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans
About the Team
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.
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
- Posses substantial hands-on experience with Informatica
- Proven expertise and extensive hands-on experience in implementing advanced performance tuning techniques for both Informatica and SQL
- 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
- Possesses a solid grasp of data warehousing principles and expertise in data modeling
- 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)
About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans
About the Team
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.
Top Skills
Autosys
Aws Glue
Ci/Cd
Control-M
Git
Informatica
Oracle
Postgres
SQL
SQL Server
Similar Jobs at JPMorganChase
Financial Services
As an Associate, you will lead transactional execution, develop client content, conduct financial analysis, and mentor junior team members.
Top Skills:
Financial Modeling
Financial Services
Analyst will support M&A execution, build financial models, draft presentations, and liaise with clients while developing skills in investment banking.
Top Skills:
Accounting SoftwareFinancial Modeling
Financial Services
The Senior Lead Architect will develop architecture solutions for software applications, engage stakeholders, modernize platforms, and drive product delivery strategies.
Top Skills:
Artificial IntelligenceCloudMachine Learning
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.