Apply Now    

Software Engineer - Informatica Powercenter

Req #: 170119164
Location: Plano, TX, US
Job Category: Technology
Potential Referral Amount: 0 US Dollar (USD)

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity.

 

Within Chase, 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 a Chase employee, you’ll be part of a company that makes a real difference every day for our customers, our communities and ourselves. With a focus on customer service, you’ll put others first, do what’s right and create solutions that make lives better. We invite you to build your career on our strong foundation and help shape what’s next – for you and for us.

 

Job Description:

 

The Informatica Applications Developer will design, create and support objects in Informatica PowerCenter using an Oracle 11g database.  Interface with the user community to collect and document requirements for various projects. Additional development will be in Oracle, PL-SQL. We have Cognos platform to meet Business Intelligence and Reporting needs. Currently we support under 1000 users that performs data analysis using the current BI platform

 

Key Responsibilities:

• 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 issues

 

The points below have been carefully considered as being essential for the role. Your background must accurately reflect all of these, with or without a reasonable accommodation, for your application to be considered.

 

Basic Qualifications:

  • Bachelor's degree in Computer Science or related field with 3+ years experience as a software developer
  • Minimum 3+ years’ experience with Informatica PowerCenter
  • Minimum 2+ years Oracle, PL/SQL including triggers, stored procedures, queries, etc. (Oracle 11g)
  • Minimum 2+ years’ experience with large Data Warehouse and handling high data volumes

 

 

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
  • Experience with Java & Cognos BI Platform
Apply Now    

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

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