Apply Now    

Software Engineering - SQL Database

Req #: 170069786
Location: Lewisville, TX, US
Job Category: Technology
Potential Referral Amount: 0 US Dollar (USD)
This position is in Chase Mortgage Banking Technology.  The Agile Team Member is responsible for the technical design, development, testing, automation engineering, and deployment of technology solutions that meet stated business and system functional requirements and adhere to coding best practices and architecture standards.  They will work closely with subject matter experts from the business, IT project managers, application developers, and User Acceptance Testers to deliver high-quality database reporting solutions to the Mortgage business.
 
The Agile team member’s primary responsibilities will be to review and recommend data modeling approaches, develop SSIS packages, ab Initio ETL processes, and advanced SQL server stored procedures into automated/functional processes during sprints. You will work closely with our technology partners in Business, Development and Quality Assurance to ensure that what we build validates the business intent of the product.   The successful candidate will possess a strong engineering background and a working knowledge of automated agile methodologies.    The successful candidate will also possess skills necessary to ensure successful coding and maintenance of automated unit, acceptance and regression tests with a focus on early automation.
 
The subject areas in which our team operates (and on which you would be expected to acquire proficiency on), are: 
  • Accountable resource in providing analytical data expertise based on application and process knowledge to recommend solutions that meet the business need.
  • Defines and assists development with designing technology based solutions to meet business requests within established technology frameworks.
  • Provides estimates based on work effort and application knowledge.
  • Experience in researching and resolving data process issues
  • Domain knowledge in US Mortgages and Banking & Finance Services.
  • Strong experience working in Agile methodologies and SCRUM execution
  • Experience in leading technical projects in Development team
  • Good communication skills
  • Experience working with geographically diverse team and coordinating with developers at diverse locations
Qualifications
  • 5+ Years of experience in database design and implementation
  • SQL Server, advanced stored procedures & SSIS package development
  • Developing test strategies, test plans based on functional specifications, use cases, and business requirements
  • Estimation of work based on effort and complexity
  • Proficiency in Visio, MS Word, MS Excel, and MS Powerpoint is required
  • Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modeling
 Preferred Skills:
  • Technical skills in Oracle Databases, Teradata & Unix
  • Experience with Agile SDLC methodology
  • Automation scheduling experience with Control-M
  • ETL extraction using Ab Initio, Spark, Hadoop
  • Data Modeling using ERwin
  • Exposure to web technologies (e.g. HTTP, XML, REST, HTML, etc)
Apply Now    

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.

Things to note

Sign in to our application system to continue your job search or update your profile.

Current employees sign in here. Contractors sign in here.

Any information you provide is confidential and will only be viewed by our recruiters in an effort to fill open positions. In addition, the information you provide is subject to our privacy policy practices.

Please note that J.P. Morgan will not accept unsolicited approaches or speculative CVs, nor will J.P. Morgan be responsible for any related fees, from Third Party Firms who are not preferred suppliers.

The firm invites all interested and qualified candidates to apply for employment opportunities.

Need disability related assistance?

If you are a US or Canadian applicant with a disability who is unable to use our online tools to search and apply for jobs, please click here.

Important links

Click here to view the "EEO is the Law" poster.

Click here to view the "EEO is the Law" supplemental poster.

Click here to view our U.S. Pay Transparency Policy.

JPMorgan Chase is an equal opportunity and affirmative action employer Disability/Veteran.