Internal Description
J.P. Morgan's Corporate & Investment Bank is a global leader across banking, markets and investor services. The world's most important corporations, governments and institutions entrust us with their business in more than 100 countries. With $18 trillion of assets under custody and $393 billion in deposits, the Corporate & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.
Description
The role is within Risk and Finance Technology ( Finance group) responsible for supporting various MIS projects in the Finance Data Warehouse Application Platform. It is the corporate book of record for actuals and is the authoritative source of MIS information and the core corporate regulatory reporting tool for product areas such as Deposits, Derivatives and Regulatory Capital. It is the single most critical MIS system across JP Morgan and is used globally across all regions and Lines of Business including executive level management from Corporate and LOB CFOs, Product and Financial Controllers and P&A. to drive key decisions around financial management.
The platform has several components such as ETL ( AbInitio), Database ( Oracle ) , and a reporting/analytics layer ( Business Objects and Essbase) and is the authoritative source for the firm’s actuals , plan and forecast. The application development team develops and supports the MIS applications used by the Corporate Finance group and various lines of business for their monthly MIS reports and analysis.
This role is specifically for an experienced AbInitio ETL Developer to support the ETL component of MIS application. The ETL developer will be expected to work closely with other team members (project managers, business analysts. Operate) in designing and ensuring overall integrity of project including design, build, defining test strategies/approaches , end-to-end System Integration Test creation and execution, providing User Acceptance Testing support and implementation support across multiple projects. They will be working closely with other test team members in multiple global locations primarily in the Columbus (US), India (Mumbai) and Delaware (US).
Roles & Responsibilities:
* Analyze, Design, develop, code, test, debug and document as per the requirements of various projects
* Open minded to take on different roles ( other than the primary skill set) and work on other technologies as needed
* Participate in functional and design reviews , identify efficiencies and provides alternatives
* Participate in / Conduct code reviews and make sure that quality solutions are built to prescribed design and best practices/standards have been followed
* Participate in Test Strategy definition and creation of test scenarios/cases for DEV(Unit Test) /SIT/UAT and execution of the same.
* Identify efficiencies and ways to improve design, development and testing processes through automation or other means
* Troubleshoot systems production/performance issues under tight deadlines
* Works with other team members, including DBA's, Other ETL developers, Technical Architects, QA , Business Analysts & Project Managers
* Excellent knowledge of the Full life cycle of a project
Education and Experience:
* Bachelor's degree in Computer Science or Engineering
* 3-5 years of hands on work experience in Ab Initio (Application development)
* 3-5 years of hands on work experience in Oracle (SQL and Stored procedures)
* Good understanding of UNIX systems and shell scripts.
* At least 5 years of software development experience required in Operational Data Store / Data Warehouse environment
* Knowledge of release management, version control practices and procedures
* Strong knowledge of development life cycles
* Experience with scheduling jobs using a scheduling tool like Control-M
* Solid design, coding, testing and debugging skills
* Must have full life-cycle experience in ETL projects, preferably in the finance industry
Preferred Skills & Experience:
* Demonstrated ability to translate functional/high level design in detailed technical design
* Excellent interpersonal relationship and communication / presentation skills
* Strong technical documentation skills
* Demonstrates initiatives and self-starter
* Prepared to challenge when business requirements seem conflicting
* Drive/Determination and knowledge
* A pro-active approach to problem-solving, taking ownership of issues and following through to resolution.
* Strong partnership skills to ensure the effective management of all stakeholders involved.
* Experience of testing methodologies including test strategy, test plan and script creation and execution.
* Defect management experience.
* Hands on experience with the ALM and QTP.
* Flexibility to work on different projects and support both manual and automation testing
**Job:** **Applications Development*
**Organization:** **CORPORATE SECTOR*
**Title:** *ETL Developer*
**Location:** *IN-KA-Bangalore East-Prestige Technology Park / 86855*
**Requisition ID:** *170006842*