Apply Now    

Reporting Software Engineer

Req #: 180028131
Location: Bangalore East, KA, IN
Job Category: Technology
Job Description:
  
JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2.6 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small business, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United  States and many of the world's most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com .
 
The Corporate Technology (CT) organization develops applications and provides technology support for corporate functions across JPMorgan Chase, including Global Finance, Corporate Treasury, Risk Management, Human Resources, Compliance, Legal, and all functions within the Corporate Administrative Office (CAO). CT teams are aligned with corporate partners’ evolving technology needs and the firm’s ever expanding technology controls agenda. A top Corporate Technology priority is building scalable corporate systems.
Role Description
The role is for an Application Developer (Associate) within the Credit Risk Reporting team. The application developer will be responsible for designing, implementing, maintaining and supporting the CRRT data warehouse. These responsibilities include building ETL (Extract Transform Load), data exchanges, data modeling and data integrations as well as working with a multi-member team globally
 
Responsibilities
  • Design, analyze, develop, debug and unit test  for different application components
  • Implements business rules via stored procedures, ETL tools, middleware, or other technologies.
  • Translating operational and business needs into technical solutions.
  • Knowledge of best practices/methodologies in Data Warehousing and Multi-dimensional data modeling (OLAP)
  • Develops, implements, refines, and supports a data warehouse used for analytics and reporting and optimizes processes while working closely with internal stakeholders.
  • Develop and implement data extraction procedures from all systems.
  • Acts a liaison between Information Technology and business units.
  • Performs source-to-target data mapping.
  • Review FSD/business requirement documents and consult on project scope and timeline
  • Complete project documentation/TDD according to SDLC requirements
  • Release management including implementation planning
  • Rapid resolution of issues impacting release
  • Analyze and troubleshoot production issues / L3 Support
Qualifications
  • Bachelor's degree in Computer Science or related field required.
  • 7+ years of extensive experience in Oracle SQL, PL/SQL.
  • NoSQL database experience is a plus
  • 2+ years of experience in Unix shell scripting. 
  • Extensive experience in tuning complex queries (Performance Tuning)
  • Extensive experience with ETL, coding and debugging using native SQL/PLSQL
  • Extensive experience in writing and modifying PL/SQL codes including Packages, Materialize Views, Nested tables, Triggers, and Functions
  • Develop and maintain batch programs using Perl and UNIX shell scripting to support the import of data into oracle database and export the data into external interfaces
  • Strong analytical, attention to detail, organizational and core project management skills
  • Strong understanding of the infrastructure, applications, hardware and software environment
 
Personal Skills:
  • Demonstrable ability to work in a highly energetic, multi-faceted, international environment showing ability to quickly assess technical challenges and respond appropriately
  • Experience in working on projects with demanding timescales
  • Should keep abreast of current industry trends and be able to bring industry standards and best practices, lessons learned to the project
  • Strong communication skills as this individual will need to work closely with clients, users and global stakeholders
  • Strong client focus
  • Excellent analytical and problem-solving skills
  • An understanding of quality and process improvement

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $2.6 trillion and operations worldwide. The firm is a leader in investment banking, financial services for consumers and small business, commercial banking, financial transaction processing, and asset management. A component of the Dow Jones Industrial Average, JPMorgan Chase & Co. serves millions of consumers in the United  States and many of the world's most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands. Information about JPMorgan Chase & Co. is available at www.jpmorganchase.com .

 

The Corporate Technology (CT) organization develops applications and provides technology support for corporate functions across JPMorgan Chase, including Global Finance, Corporate Treasury, Risk Management, Human Resources, Compliance, Legal, and all functions within the Corporate Administrative Office (CAO). CT teams are aligned with corporate partners’ evolving technology needs and the firm’s ever expanding technology controls agenda. A top Corporate Technology priority is building scalable corporate systems.

Role Description

The role is for a Software Engineer (Associate) within the Credit Risk Reporting team. The engineer will be responsible for designing, implementing, maintaining and supporting the CRRT data warehouse. These responsibilities include building scalable reporting solutions in Business Objects and Tableau. The engineer should also possess strong database skills to analyze/participate in building ETL (Extract Transform Load), data exchanges, data modeling and data integrations.

 

Responsibilities

  • Develops scalable reports using Business Objects/Tableau reporting tool
  • Strong Business Objects/Tableau administration skills
  • Design, analyze, develop, debug and unit test  for different application components
  • Strong Database skills to analyze/implement business rules via stored procedures, ETL tools, middleware, or other technologies.
  • Translating operational and business needs into technical solutions.
  • Knowledge of best practices/methodologies in Data Warehousing and Multi-dimensional data modeling (OLAP)
  • Develops, implements, refines, and supports a data warehouse used for analytics and reporting and optimizes processes while working closely with internal stakeholders.
  • Develop and implement data extraction procedures from all systems.
  • Acts a liaison between Information Technology and business units.
  • Performs source-to-target data mapping.
  • Analyze and troubleshoot production issues / L3 Support

Qualifications

  • Bachelor's degree in Computer Science or related field required.
  • 4-6 yrs of strong experience in Business Objects reporting including universe design, security management, BO report build
  • 2-3 yrs strong experience in Tableau reporting
  • Strong Oracle DB skills, experience in Oracle SQL, PL/SQL.
  • Strong experience in writing and modifying complex SQL, PL/SQL codes including Packages, Materialize Views, Nested tables, Triggers, and Functions
  • NoSQL database experience is a plus
  • Strong analytical, attention to detail, organizational and core project management skills
  • Strong understanding of the infrastructure, applications, hardware and software environment

 

Personal Skills:

  • Demonstrable ability to work in a highly energetic, multi-faceted, international environment showing ability to quickly assess technical challenges and respond appropriately
  • Experience in working on projects with demanding timescales
  • Should keep abreast of current industry trends and be able to bring industry standards and best practices, lessons learned to the project
  • Strong communication skills as this individual will need to work closely with clients, users and global stakeholders
  • Strong client focus
  • Excellent analytical and problem-solving skills
  • An understanding of quality and process improvement

 

Apply Now    
Link for schema

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.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.