JPMorgan Chase
Columbus, OH

ETL Ab Initio/Cloud Data Engineer (Columbus, OH)

| Columbus, OH
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Job Description The Finance and Risk Warehouse is an organization within JP Morgan's Corporate Technology group responsible for acquiring and integrating data from various product systems within the bank into a single data lake serving the Finance & Risk consumers, including Liquidity Risk, Interest Rate Risk, Credit Risk, and International Regulatory Reporting.
The team constantly strives to use cutting edge technology in delivering optimal business solutions keeping up with the rapidly evolving tech world of today. This makes the role of senior data integration architects and leads extremely critical to the organization. The role of the data integration developer is of paramount importance to ensure that business requirements are met and that modern technologies are employed to create efficient and maintainable features.
As a member of our Software Engineering Group, we look first and foremost for people who are passionate around solving business problems through innovation and engineering practices. You'll be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner continuously with your many stakeholders on a daily basis to stay focused on common goals. We embrace a culture of experimentation and constantly strive for improvement and learning. You'll work in a collaborative, trusting, thought-provoking environment-one that encourages diversity of thought and creative solutions that are in the best interests of our customers globally.
A data integration developer is responsible for the following key areas:
  • Development of data integration pipelines sourcing financial and ledger data from various systems within the bank into a data lake
  • Creation of ETL Data Pipeline processes to validate, enrich and persist data
  • Build modern software solutions geared towards solving the key business requirements of the organization
  • Adopt cutting edge technologies such as cloud/containers as a part of application evolution and modernization
  • Understand business requirements and collaborate with the architecture team to translate them into technical design
  • Demonstrate the ability to work in an Agile SDLC environment and constantly strive towards improving the practices within the organization

Ideal candidates should possess:
  • Basic concepts of data integration architecture
  • Basic understanding of data modeling concepts
  • In depth grasp of various components of standard ETL Data Pipeline tools (preferably Ab Initio)
  • Extensive design and development experience with data integration solutions using an ETL tool (preferably Ab Initio)
  • Prior experience in working with data pipelines in a cloud or Kubernetes environment
  • Working knowledge of Oracle, especially relating to PL/SQL
  • Understanding of Big data technologies including but not limited to Spark, Hadoop, Hive, Impala and HBase
  • Hands-on experience with understanding Spark processing and debugging graphs and logs
  • Demonstrable knowledge of UNIX operating systems and shell scripting
  • Knowledge on cloud technology is a plus, especially Amazon Web Services.
  • Working knowledge of scheduling tools such as Control-M, Autosys
  • Strong grasp on SDLC concepts including development best practices, code migration procedures and test automation
  • Ability to work in an Agile development environment against challenging project timelines
  • BS/BA degree or equivalent experience

Additionally, an understanding of at least some of these technologies and practices is beneficial:
  • Knowledge of test automation frameworks such as Cucumber
  • Working knowledge of Kafka as a distributed publish-subscribe system
  • Experience with modern big data consumption technologies such as Dremio
  • Working knowledge of Python, Java and Scala
  • Modern web technologies such as NodeJS, AngularJS, React, Redux, or Typescript
  • Understanding of modern cyber security practices such as Kerberos authentication

About Us 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.
The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.
As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.
Equal Opportunity Employer/Disability/Veterans
About the Team Our Corporate Technology team relies on smart, driven people like you to develop applications and provide tech support for all our corporate functions across our network. Your efforts will touch lives all over the financial spectrum and across all our divisions: Global Finance, Corporate Treasury, Risk Management, Human Resources, Compliance, Legal, and within the Corporate Administrative Office. You'll be part of a team specifically built to meet and exceed our evolving technology needs, as well as our technology controls agenda.
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • SqlLanguages
    • SwiftLanguages
    • CloudFoundryLanguages
    • AzureLanguages
    • KubernetesLanguages
    • jQueryLibraries
    • ReactLibraries
    • ASP.NETFrameworks
    • Ember.jsFrameworks
    • HadoopFrameworks
    • Node.jsFrameworks
    • SparkFrameworks
    • SpringFrameworks
    • TensorFlowFrameworks
    • AWS (Amazon Web Services)Frameworks
    • AccessDatabases
    • CassandraDatabases
    • DB2Databases
    • MariaDBDatabases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • DynatraceDatabases
    • Splunk Databases
    • PromtheusDatabases
    • GrafanaDatabases
    • ConfluenceManagement
    • JIRAManagement

What are JPMorgan Chase Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Diversity
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Wellness Programs
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
Game Room
Professional Development Benefits
Tuition Reimbursement
Diversity Program

An Insider's view of JPMorgan Chase

What’s the vibe like in the office?

My favorite thing about JPMorgan Chase is the vast number of problems we solve, and the diversity it takes to do that. Moving money, enabling payments and producing a world class customer experience are just a fraction of what we work on. Because the office is so casual and open, I get to participate in discussions on all of this.

Nick S.

Executive Director, Software Engineering

What projects are you most excited about?

As one of the largest financial institutions in the world, our scope of impact is huge. Knowing that a system we deliver is responsible for things millions do daily such as paying for groceries, withdrawing cash, or getting a loan pushes us toward solutions that scale, which is the most challenging but also the most rewarding part of our projects.

Edwin T.

Executive Director, Site Reliability Engineering

How does the company support your career growth?

JPMorgan has helped me develop as a professional – both as a technologist and as a business leader. I have taken advantage of executive leadership training and development aligned to the firm’s culture of “How We Do Business.” I feel good about working for a firm that invests in its #1 asset – US!

Lupe C.

Executive Director

How do you empower your team to be more creative?

Empowerment for Idea generation, problem solving and innovation is best coming from those who do the work. I engage my technologist in high profile work and foster an environment where ideas are welcome. Empowerment of our technologists is the key to success. Teams dig in, innovate and identify ways to create a better client experience.

Dawn T.

Managing Director, Software Engineering

How does the company support your career growth?

Working at JPMC has been a wonderful experience. I love how much JPMorgan Chase cares about its communities by offering support of technologists to local non-profit organizations through social innovation programs. The company also invests in its employees and provides many learning opportunities to us.

Meng M.

Software Engineer

More Jobs at JPMorgan Chase