Software Engineer III -ETL

Job Description
If you are keen on taking your software engineering career to the next level this is the right opportunity.
As a Software Engineer III - ETL Associate at JPMorgan Chase, you will be responsible for the implementation and maintenance of ETL jobs using AWS services like S3, Lambda, Glue, SWS, Cloud watch etc.. in incentive compensation space. Responsibility includes understanding comprehensive ETL requirements and the ability to translate design into working solutions, while maintaining and troubleshooting existing reports. Job requires an analytical and technical background, with the ability to adhere to the Agile Methodology best practices and conform to strict timelines
Job Responsibilities

• Designs, analyzes, develops, tests, debugs and delivers software and/or new products as part of ETL using AWS Services within JP Morgan's Legal Technology
• Work with development leads/scrum masters & product owners to identify solutions to their analytic needs, develop new Data Ingestion and Transformation jobs.
• Identify process simplification opportunities for overall ETL and Analytic environment. Work with Cloud COE team and business partners to automate or simplify existing processes, and to remove any manual steps from data ingestion and delivery.
• Demonstrates good understanding of Agile framework for end to end software development and deployment tool chains.
• Collaborates with fellow team members and keeps the team and other key stakeholders well informed of progress of application business features being developed.

Required Qualifications, Capabilities, and Skills

• Formal training or certification on software engineering concepts and 3+ years applied experience
• Proficient in application development skills for more than one Cloud and Traditional Data Engineering technology including AWS Services like Glue, EMR, data warehouse.
• Recent experience developing data ingestion from on premise applications to private cloud AWS using related services like S3, Lambda, SQS, Event Bridge, Glue/Glue Studio/Glue workflows/Glue Data Catalogue, Cloud watch, Aurora MySQL/PostgreSQL databases, and EMR with Python /Pyspark
• Good understanding of KMS and IAM services.
• Experience in omprehensive analysis and design experience with demonstrated knowledge of RDMS systems like Oracle, good in writing and understanding SQL, PL/SQL constructs.
• Has knowledge in CI/CD process in AWS Cloud environments, has hands on experience on any of the Infrastructure as Code service (Iac) like Terraform, Cloud Formation etc.
• Qualification: Bachelor's Degree in MIS, Computer Science, or Engineering.
• Strong communication skills with demonstrated experience coordinating development cycles and project management.

Preferred Qualification, Capabilities and Skills

• Working proficiency in a selection of software engineering disciplines and demonstrates understanding of overall software skills including business analysis, development, testing, deployment, maintenance and improvement of software.
• Experience in working with streaming services like Kafka/AWS MSK/Confluent Kafka or equivalent services.
• Experience in developing software solutions leveraging Test Driven Development (TDD)
• Strong Experience in Oracle HCM/ICM and data ingestion to Oracle ICM

About Us
JPMorganChase, 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. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
About the Team
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.