8 days old

ETL Developer

JPMorgan Chase & Co.
Columbus, OH 43215
  • Job Code
    190080333

ETL Developer

Req #: 190080333
Location: Columbus, OH, US
Job Category: Technology
Potential Referral Amount: 3000 US Dollar (USD)

Our Consumer & Community Banking Group depends on innovators like you to serve nearly 66 million consumers and over 4 million small businesses, municipalities and non-profits.  You’ll support the delivery of award winning tools and services that cover everything from personal and small business banking as well as lending, mortgages, credit cards, payments, auto finance and investment advice. This group is also focused on developing and delivering cutting edged mobile applications, digital experiences and next generation banking technology solutions to better serve our clients and customers.

 

The CCB Data Eco System (DECO) organization is responsible for building the strategic, analytic Data Ecosystem for Consumer and Community Banking (CCB). Within the Data Ecosystem we manage the strategic data platforms, including the Integrated Consumer Data Warehouse (ICDW), and other data warehouse environments as well as provide direction for large data warehouses across the firm.  We publish data from a comprehensive set of Chase applications and support not only traditional data warehousing data consumption but also supply data to decisioning engines, machine learning and other facilities.  We are often involved in the forefront of new products and capabilities such as our newest internet and mobile offerings and new branch and ATM servicing options.

 

As an ETL Developer, you will have responsibilities in the following areas. Your focus will be distributed across these areas based on your experience and skill set.  However,  development of skills and execution in each area is expected  in order to optimize team effectiveness by understanding all team functions and having flexibility in workload balancing.

 

Business Requirements Analysis and Functional Design

Engage with the business and multiple I/T teams to understand new and existing business requirements and data source system design and capabilities, especially as it relates to data. For solutions requiring new data publication and/or new data structures within DECO, understand how the business functionality maps to the source system data. Perform data analysis and profiling using SQL or other data tools.  Understand the DECO platforms, facilities and capabilities and work with team leads, design authorities and architects to formulate a high level design of the solution. 

 

Create optimal functional designs from the high level designs, intersecting business requirements, business and source system data knowledge, DECO platform and facilities, best practices, and regulatory and security controls requirements.  This includes detailed source to target data mappings, with any needed transformations.  For solutions requiring new or modified data structures, work with the data modeling team to create detailed specifications for the new or modified structures. 

 

Technical Design and Solution Development

Create technical designs from data publication driven functional specifications and develop and implement the solutions based on this design.  This may include designing, creating, testing and migrating new components into a number of platforms or facilities such as Teradata/Informatica, Hadoop/Ab Initio, Cloud, Java/Spark or Kafka.  For infrastructure and technology oriented initiatives, analyze requirements and create technical designs intersecting requirements, DECO platforms and facilities, best practices and regulatory and security controls requirements. Implement the solutions based on these technical designs including preparing for and overseeing the installations.

 

End user support

Field questions from end users of the published data of the Data Ecosystem to help them find the data they need, understand how the data relates to the business functionality, formulate queries to retrieve the data needed to address their business objective, and resolve data quality issues.  The latter will often require in-depth analysis of the data and an in-depth research of the source system data as well as designing data remediations.

 

Technical support

Research production processing issues which cannot be resolved by the production support team as first level support.  Research data quality related issues. Design and implement solutions for both types of issues and drive and oversee the implementation of the remediations.

 

You will work as a member of an agile team, with the following teamwork, business, and controls oriented responsibilities:  

  • As a priority, comply with risk, controls and conduct standards, exercising sound judgement to protect our company, clients and customers.
  • Learn and apply data warehousing best practices along with DECO specific architecture, standards and design patterns and best practices.
  • Utilize best practices across all aspects of the SDLC cycle to deliver high quality, lasting ETL solutions that meet the needs of our clients and are consistent with long-term DECO, controls and business strategies.
  • Build long-term relationships with end user groups, and outside and internal technology groups, especially by employing the good communications practices of being responsive and using clear, concise and properly structured verbal and written communications at the appropriate level of detail.
  • Learn business functionality, and technology in in both our source systems and within DECO and share across the team through KT sessions and long-term sustainable knowledge capital documentation. 
  • Document our functional and technical solutions as a contribution to our long-term, sustainable knowledge capital documentation.
  • Ensure that requirements documentation supports development of test plans and ensure that proper test plans have been completed.
  • As part of the project demand management process, review high level business requirements and concept designs for new projects, identify the high level DECO solution and provide LOE estimates.
  • Embrace the agile process and function with a teamwork approach. This includes actively working on multiple projects in each sprint and mentoring of other resources within the team.

This role requires a wide variety of strengths and capabilities, including:

  • 5+ years hands on experience in a data oriented role
  • 3+ years experience working in a Data Warehouse environment (or equivalent)
  • 5+ years experience in analysis of data or complex processes and systems, demonstrating strong analytical skills.
  • 3+ years using SQL
  • 3+ years working with financial services oriented applications
  • Demonstrated ability to work in a team environment with a structured SDLC and interface and coordinate with a variety of business and I/T groups
  • College degree or specialized training / equivalent work experience
  • Business Requirements Analysis and Functional Design
  • 2+ years of Business Analyst work experience
  • 2+ years creating complex functional designs which included data mapping and required understanding and aligning with organizational and architectural goals and strategy.
  • Technical Design and Solution Development
  • 5+ years of professional experience as a developer in a data warehousing or other data oriented, batch processing environment
  • 5+ years of hands on experience with Extract/Transform/Load (ETL) tools such as Ab Initio or Informatica.
  • 3+ years of hands on experience with relational databases such as Teradata, Oracle or DB2
  • 2+ years creating complex technical designs which included data mapping and required understanding and aligning with organizational and architectural goals and strategy.
  • 2+ years of hands on experience with Unix shell scripting
  • Experience with Java/Spark is a plus.
  • Experience with a scheduling tool, especially Control-M, is a plus.
  • Experience with issue analysis and resolution including usage of issue resolution processes for application production problems.
  • Experience with release management and installations including preparing for and overseeing the installations

When you work at JPMorgan Chase & Company, you're not just working at a global financial institution. You're an integral part of one of the world's biggest tech companies.  In 14 technology hubs worldwide, our team of 40,000 technologists design, build and deploy everything from enterprise technology initiatives to big data and mobile solutions, as well as innovations in electronic payments, cybersecurity, machine learning, and cloud development.  Our $9.5B+ annual investment in technology enables us to hire people to create innovative solutions that will not only transform the financial services industry, but also change the world.

 

At JPMorgan Chase & Company we value the unique skills of every employee, and we're building a technology organization that thrives on diversity.  We encourage professional growth and career development, and offer competitive benefits and compensation.  If you're looking to build your career as part of a global technology team tackling big challenges that impact the lives of people and companies around the world, we want to meet you.


Keyword: consumer%20banking

Categories

Posted: 2019-10-10 Expires: 2019-11-15

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

ETL Developer

JPMorgan Chase & Co.
Columbus, OH 43215

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast