Etl Developer - Bangalore - Jpmorgan Chase
Jpmorgan Chase as the company that open the jobs vacancy, have some qualification and spesification especially for the Etl Developer jobs vacancy. To find out more information and about qualification and spesification details, walkin interview schedule, the address of the company, the company contact info (email/phone number) of Jpmorgan Chase company, please start to apply for the job vacancy with fill the jobs application with click the 'Apply This Job' button below.
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.
The role is within Corporate 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
IN-KA-Bangalore East-Prestige Technology Park / 86855
JPMorgan Chase & Co.