AWM - SQL Developer - Associate

JPMorgan Chase & Co. (NYSE: JPM) is a leading global financial services firm with assets of $3.4 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. 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.

Global Finance & Business Management (“GF&BM”) India is a combined LOB-aligned (Line of Business-aligned) finance & business support team located in India and is part of JPMorgan’s global capability center (GCC). We are part of the Office of the CFO (OCFO) organization within JPMorgan, which has 13000+ people across the globe, majority of whom are tasked with managing the firm’s Finance function, responsible for reporting quarterly earnings and complying with regulatory requirements along with managing the firm’s capital.

GF&BM India was established in September 2002 and currently we have a network of more than 3400+ professionals based out of our Mumbai, Bengaluru and Hyderabad offices who support four main “pillars” of work - Controllers, Planning & Analysis, Finance Operations and Business Client & Products. The teams in India are aligned to the respective LOBs that they support which include Corporate and Investment Banking (CIB), Commercial Banking (CB), Consumer and Community Banking (CCB), Asset & Wealth Management (AWM) and Corporate/Firmwide functions.

We have a strong culture that embodies the principles that guide us in how we do business across the firm. We strive to create a workplace that values and respects individual viewpoints, while at the same time challenging the status quo to make continuous improvements in our processes.

JPMorgan is an equal opportunity employer and places high value on diversity and inclusion. We recognize that our people are our strength and diversity of thought and practices makes us more successful.

Role Description:

As part of AWM MIS team, the BI Developer(SQL) is expected to perform the following roles and responsibilities.

• Analyzes, designs, develops, codes and implements programs in one or more programming languages, for Web/Intranet Applications.
• Supports applications with an understanding of system integration, test planning, scripting, and troubleshooting.
• Assesses the health and performance of software applications and databases.
• Establishes, participates, and maintains relationships with stakeholders and subject matter experts in order to remain apprised of direction, project status, architectural and technology trends, risks, and functional/integration issues.
• Defines specifications and develop programs, modifies existing programs, prepares test data, and prepares functional specifications.
• Analyzes program and application performance using various programming languages, tools and techniques.
• 
  Identifies potential process improvement areas and suggests options and recommends approaches.
• Scope, prioritize and co-ordinate activities with the product owners.
• Partner with cross functional teams and business stakeholders to convert business requirements to wireframes/design.
• Work on the agile improvements by sharing experiences and knowledge with the team.

Qualifications:

• Experience Required: 5 to 8 yrs in SQL Development
• Proficient in SQL coding and Stored Procedures in SQL Server and building ETL through SSIS.
• Proficient in writing complicated yet efficient SQL queries and stored procedures.

• Looking to get Placed? Try our Placement Guarantee Plan

  Get Hired
  Proficient in query optimization/performance tuning of stored procedures/ETL packages.
• Experience in API layer like security, request and response modifications etc.
• Experience in end-to-end implementation of Business Intelligence (BI) reports & dashboards.
• Proficient of Jira, Confluence,
• Knowledge of Git/Bit Bucket, Jenkins/Jules other Devops tools
• Knowledge on other ETL tools like Alteryx scripting using Python and BI/Visualization tools like Tableau will be added advantage.
• Exposure to cloud technologies will be advantage
• Bachelor’s Degree in MIS, Computer Science, or Engineering. Different field of study, with significant professional experience in Software Development, is acceptable.

• Shift: EMEA