Job Description:
Position Description:
Develops applications using Oracle SQL, PL/SQL, Oracle APEX. Sets up and monitors batch jobs using Autosys scheduler. Creates data pipelines, SOD data quality checks, and delivers reports/feeds to downstream applications. Creates TABLEAU extracts, data source, and dashboards for reporting and analytics. Deploys and maintains Spring Boot Application Program Interfaces (APIs) on AWS EC2 instances. Establishes and maintains code quality using utPLSQL framework for test cases. Establishes Continuous Integration/Continuous Delivery (CI/CD) of code using Bitbucket, Jenkins, Concourse pipelines, and uDeploy. Uses business knowledge to translate the vision for divisional initiatives into business solutions by developing complex or multiple software applications and conducting studies of alternatives. Analyzes and recommends changes in project development policies, procedures, standards, and strategies to development experts and management.
Primary Responsibilities:
Participates in architecture design sessions.
Defines and implements application level architecture.
Develops applications on complex projects, components, and subsystems for the division.
Responsible for QA readiness of software deliverables.
Develops comprehensive documentation for multiple applications or subsystems.
Responsible for meeting project goals on-time and on-budget.
Advises on risk assessment and risk management strategies for projects.
Plans and coordinates project schedules and assignments for multiple projects.
Provides technology solutions to daily issues and technical evaluation estimates on technology initiatives.
Mentors junior team members.
Performs independent and complex technical and functional analysis for multiple projects supporting several divisional initiatives.
Develops original and creative technical solutions to on-going development efforts.
Education and Experience:
Bachelor s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five (5) years of experience in the job offered or five (5) years of experience designing and developing databases using Oracle, Unix, and Autosys in a financial services environment.
Or, alternatively, Master s degree (or foreign education equivalent) in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and three (3) years of experience in the job offered or three (3) years of experience designing and developing databases using Oracle, Unix, and Autosys in a financial services environment.
Skills and Knowledge:
Candidate must also possess:
Demonstrated Expertise ( DE ) performing Oracle PL/SQL and SQL tuning; developing Oracle databases using Snowflake, Oracle APEX, Informatica (for ETL), Linux shell scripts, and Autosys; and setting up and monitoring batch jobs using Autosys scheduler.
DE designing and developing data loaders to retrieve data from feed files, transform, and load in operational datastore and data warehouses using Oracle, Informatica, and Unix shell scripts; tuning SQL queries to enhance cycle performance; and developing and enhancing UI screens for end users to manipulate data using SQL, and Oracle APEX.
DE performing data profiling, extraction, cleansing, and analysis for large data warehouses using Oracle; designing conceptual and physical data models; generating visual insights for business and end users using Tableau reports; and establishing code quality processes using utPLSQL framework and SonarQube.
DE developing data APIs to support varied application requirements using native AWS services (EMR, EC2, S3, and Cloud formation); and deploying ETL scripts, Oracle DDL/DML statements, and PLSQL objects on CI/CD pipelines using Jenkins, BitBucket, Concourse, and uDeploy.
Certifications:Company Overview
Fidelity Investments is a privately held company with a mission to strengthen the financial well-being of our clients. We help people invest and plan for their future. We assist companies and non-profit organizations in delivering benefits to their employees. And we provide institutions and independent advisors with investment and technology solutions to help invest their own clients money.
Join Us
At Fidelity, you ll find endless opportunities to build a meaningful career that positively impacts peoples lives, including yours. You can take advantage of flexible benefits that support you through every stage of your career, empowering you to thrive at work and at home. Honored with a Glassdoor Employees Choice Award , we have been recognized by our employees as a top 10 Best Place to Work in 2024. And you don t need a finance background to succeed at Fidelity we offer a range of opportunities for learning so you can build the career you ve always imagined.
Fidelity's working model blends the best of working offsite with maximizing time together in person to meet associate and business needs. Currently, most hybrid roles require associates to work onsite all business days of one assigned week per four-week period (beginning in September 2024, the requirement will be two full assigned weeks).
At Fidelity, we value honesty, integrity, and the safety of our associates and customers within a heavily regulated industry. Certain roles may require candidates to go through a preliminary credit check during the screening process. Candidates who are presented with a Fidelity offer will need to go through a background investigation, detailed in this document , and may be asked to provide additional documentation as requested. This investigation includes but is not limited to a criminal, civil litigations and regulatory review, employment, education, and credit review (role dependent). These investigations will account for 7 years or more of history, depending on the role. Where permitted by federal or state law, Fidelity will also conduct a pre-employment drug screen, which will review for the following substances: Amphetamines, THC (marijuana), cocaine, opiates, phencyclidine.
We invite you to Find Your Fidelity at .
Fidelity Investments is an equal opportunity employer. We believe that the most effective way to attract, develop and retain a diverse workforce is to build an enduring culture of inclusion and belonging.
Fidelity will reasonably accommodate applicants with disabilities who need adjustments to participate in the application or interview process. To initiate a request for an accommodation, contact the HR Accommodation Team by sending an email to .