SSIS/SQL Server Developer - Mumbai at JPMorgan Chase Bank, N.A. (Mumbai, India)
Location: Mumbai, India
Type: Full Time
Created: 2021-01-24 05:00:46
Role Definition: Home Lending Capital Markets is looking for a motivated ETL/DB developer/data analyst to interact with the business stakeholders to understand their needs/requirements and contribute independently or directly within a team of developers/analysts to provide optimal technical solution.
Good business background in the mortgage origination and servicing domain / and or capital markets is a plus. Ability to work in a geographically distributed team and the disciplines associated with it is required. Self-starter with proven ability to perform in-depth data and systems analysis and understand the business problem and document it in a structured fashion is necessary. Good communication skills are vital for this role. Ability to write logically organized, performant and maintainable code is a must. Demonstrated ability to manage multiple projects and competing priorities. General idea of component based development model is needed.
Business Domain: The domain of home lending capital markets is large and in general supports the raising of capital (via buying and selling of fixed income assets) to fund primary market mortgage product needs. It supports various critical aspects of the lending lifecycle including but not limited to product structuring, pricing, delivery, risk analysis and valuation of the loan asset. Major stakeholders in this domain range from loan officers to traders and investors as well as pricing and product specialists.
SDLC: We follow an agile methodology for development with an eye to delivering a working solution to the business in an iterative manner. A distributed development methodology requires us to integrate frequently. A test driven development model is encouraged. The candidate is expected to be proficient in understanding and working with large data sets.
Qualification and Experience:
Bachelor degree and / or equivalent.
6-10 years of development experience.
Experience with source code control system (SVN/GIT), code build and packaging (Maven) and deployment is a must.
Experience with an IDE is needed (Visual Studio 2008-2012 / Eclipse)
Sql Server Integration Services (SSIS) 2008 / 2012 with Oracle/ SQL Server databases skill is a must.
SSAS skills is a plus
Database programming knowledge using Oracle PL-SQL / SQL Server T-SQL as well as experience in writing stored procedures and packages is needed. Ability to write complex SQL queries to support reporting and data analysis needs.
Hands on working knowledge of object oriented programming and development practices using .Net / Java platform is a plus.
Basics of database model design - normalization, indexing, data definition etc.
Working knowledge on the Windows Server 2012/2016 platforms as well as Unix/Linux variants is needed.JPMorgan Chase & Co., one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.