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.
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)
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.