JPMorgan Chase Informatica/ETL/Oracle, Software Engineer in Plano, Texas

When you work at JPMorgan Chase & Co., you’re not just working at a global financial institution. You’re an integral part of one of the world’s biggest tech companies. In 14 technology hubs worldwide, our team of 40,000+ technologists design, build and deploy everything from enterprise technology initiatives to big data and mobile solutions, as well as innovations in electronic payments, cybersecurity, machine learning, and cloud development. Our $9.5B+ annual investment in technology enables us to hire people to create innovative solutions that will not only transform the financial services industry, but also change the world.

Commerce Solutions is a leading provider of merchant services, offering proprietary platforms that enable integrated solutions for all payment types, including credit, debit, prepaid stored value and electronic check processing as well as digital, alternative and mobile payment options.

As an Informatica Software Engineer you will design, create and support objects in Informtica PowerCenter using an Oracle 11g database. Interface with the user community to collect and document requirements for various projects.

Key Responsibilities:

  • Designs, analyzes, develops, codes, tests, debugs and documents programming to satisfy business requirements.

  • Adheres to architecture standards, risk management and security policies, leading presentations in architecture review, strategic technology directions, best practice development (e.g., estimating models), mentoring less experienced team members, code reviews

  • Responsible for design, build and maintenance of software applications for Chase Card Services Data Warehouse

  • Designs, analyzes, develops, codes, tests, debugs and documents programming to satisfy business requirements

  • Will deliver the assigned work within specified timelines with high quality

  • Should possess good communication skills and solid knowledge on software delivery lifecycle in large Warehouse environment

  • Will participate in every phase of software delivery life cycle including Requirement, Analysis & Design, Build Code, Unit Test, Support system and Integration testing, Implementation phase and post implementation support

  • Will write and enhance Technical specifications based on functional specifications

  • Will produce Unit test case results, Implementation plans, Application Support Guide using Word, Excel, PowerPoint, Visio

  • Develop code using Informatica, Oracle, Unix (Korn Shell scripts), PL/SQL, and Scheduling tools

  • Thoroughly perform unit testing ensuring minimal code defects out of build phase into system test phase

  • Should have solid knowledge of Informatica Power Center, Repository and client

  • Development of ETL concepts, Oracle Table partitioning

  • Provides the project manager/supervisor with timely and accurate information regarding the performance of the assigned projects(s)

  • Understand scope of work and work closely with PM's, BSA's, UAT team, Tech Ops and individuals from other groups

  • Identify and communicate potential impacts of a change/issue to other areas

  • Demonstrates sound analytic and diagnostic skills dealing with issue


  • B.S or M.S (Computer Science preferred), should have proven course work in computer software subject areas like algorithms, data structures, programming languages, software engineering.

  • 8+ year minimum experience in programming.

  • Minimum 5+ years’ experience with Informatica PowerCenter

  • Minimum 5+ years’ experience with large Data Warehouse and handling high data volumes

  • Experience with SQL/Stored Procedures on Oracle database

  • Experience with working in a Linux environment

  • Experience with high volume, mission critical applications

  • Experience working on large and medium scale software projects

  • Experience building distributed systems

  • Experience working in a fast-paced financial services focused delivery environment

  • Strong written and verbal communication skills

  • Strong interpersonal skills and team playing skills

  • Strong analytical and troubleshooting skills

  • Experience with high volume applications

  • Thorough knowledge of SDLC(Software Development Life Cycle)

Preferred Skills:

  • Experience in Informatica upgrade

  • Experience in Informatica Adminsitration

  • Experience with other Informatica Component Modules including PowerExchange, IDQ, etc.

  • Experience with Unix and Shell Scripting

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.