Software Engineer III- ETL/Reporting
JPMorganChase
We have an exciting and rewarding opportunity for you to take your software engineering career to the next level.
As a Software Engineer III at JPMorganChase within the Employee Platforms team, you serve as a seasoned member of an agile team to design and deliver trusted market-leading technology products in a secure, stable, and scalable way. You are responsible for carrying out critical technology solutions across multiple technical areas within various business functions in support of the firm’s business objectives.
Job responsibilities
- Executes software solutions, design, development, and technical troubleshooting with ability to think beyond routine or conventional approaches to build solutions or break down technical problems
- Creates secure and high-quality production code and maintains algorithms that run synchronously with appropriate systems
- 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.
- Hands on 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.
- Relevent comprehensive 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.
Preferred qualifications, 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.
- Strong communication skills with demonstrated experience coordinating development cycles and project management.
- Experience in developing software solutions leveraging Test Driven Development (TDD)
- Strong Experience in Oracle HCM/ICM and data ingestion to Oracle ICM
Design and deliver market-leading technology products in a secure and scalable way as a seasoned member of an agile team