Technology
Principal Database Developer
- Smithfield, RI
Salary depends on a variety of factors including location and experience. Your recruiter will discuss with you.
Salary: listed in the job description
or discussed with your recruiter
Job Description:
Position Description:
Performs Extract, Transform, Load (ETL) data integration and develops data movement design patterns using Informatica and Oracle Exadata 12c Relational Databases. Schedules dependency management using Baseboard Management Controller (BMC) Control-M for distributed systems. Uses Continuous Integration/Continuous Delivery (CI/CD) Cloud Computing and DevOps concepts to automate application pipelines using Git and Jenkins. Performs Cloud native data warehousing and data lake solutions with Azure ADF, Redshift, and Snowflake. Develops data intensive applications, data integration, and data pipeline design patterns on a distributed platform. Develops and oversees software system testing and validation procedures, programming, and documentation.
Primary Responsibilities:
- Establishes full project lifecycle plans for complex projects.
- Documents designs, operational procedures, and standards for highly complex business critical databases.
- Builds data pipelines optimized for scaling.
- Troubleshoots potential platform issues.
- Collaborates with data architects to craft and implement solutions and improvements to ingest, transform, connect, store, and expose data to a range of users.
- Incorporates new data sources by building pipelines for automated and semi-automated data ingestion and data refresh.
- Develops and implements tests to ensure data quality and proper governance across all integrated datasets.
- Provides insights on data warehouse technical architectures, infrastructure components, ETL/ELT, and design and reporting/analytic tools and environments.
- Confers with systems analysts and software engineers/developers to design systems and obtain information on project limitations and capabilities, performance requirements and interfaces.
- Develops and oversees software system testing and validation procedures, programming, and documentation.
- Mentors junior team members.
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 as a Principal Database Developer (or a closely related occupation) developing data solutions using Oracle.
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 as a Principal Database Developer (or a closely related occupation) developing data solutions using Oracle.
Skills and Knowledge:
Candidate must also possess:
- Demonstrated Expertise (DE) designing and implementing database packages, functions, stored procedures, triggers, tables, and views; and writing complex queries to retrieve data using SQL/PLSQL and Native Stored Procedures (NSPs) on DB2 Database to perform ETL operations using Informatica according to Agile methodologies and CI/CD.
- DE building complex data transformation workflows and procedures with Azure Cloud-based Oracle, on-prem Oracle, SQL Server, or DB2 Databases.
- DE implementing data storage designs using normalized forms — Third Normal Form (3NF), Boyce-Codd Normal Form (BCNF), Key Value Pair, and denormalized forms; and defining system architecture and component interaction functionalities using Unified Modeling Language (UML) — State Diagram, Flow Charts, and Sequence and Activity Diagrams.
- DE performing maintenance activities — gathering statistics, analyzing database objects, and conducting data profiling and data mappings; and conducting database performance tuning of complex Oracle PL/SQL queries by analyzing query plans and generating SQL Trace and TKProf.
Salary: $144,550.00 – $148,700.00/year.
#PE1M2
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 hybrid working model blends the best of both onsite and offsite work experiences. Working onsite is important for our business strategy and our culture. We also value the benefits that working offsite offers associates. Most hybrid roles require associates to work onsite all business days of every other week in a Fidelity office.
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 fidelitycareers.com.
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 accommodations@fmr.com.
Company overview
At Fidelity, we are passionate about making our financial expertise broadly accessible and effective in helping people live the lives they want! We are a privately held company that places a high degree of value in creating and nurturing a work environment that attracts the best talent and reflects our commitment to our associates. We are proud of our diverse and inclusive workplace where we respect and value our associates for their unique perspectives and experiences. For information about working at Fidelity, visit FidelityCareers.com. Fidelity Investments is an equal opportunity employer. Fidelity will reasonably accommodate applicants with disabilities who need adjustments to complete the application or interview process.
Apply Now
All fields are required.
What tech makes you tick?
Benefits that adapt to everything life sends your way
401(k) with company match
Medical, dental, vision and prescription drug coverage
16-week maternity leave & 12-week parental leave
Student loan assistance
Fidelity is invested in you
Committed to Professional Development
At Fidelity, we are constantly adapting to the changing needs of our customers, new technologies, and better ways of working. And we empower our employees to do the same, with an emphasis on developing skills and connections that will help propel you forward in your career while being able to make an impact for Fidelity’s customers around the world.
Licenses & Certifications
- Pursue excellence in new coding languages or tech applications across a broad range of technical paths.
- Tuition reimbursement for online or in-person course work in pursuit of new certifications.
Continuing Education & Training
- Assess, build, and align your development plan through resources like our skill-building classroom and online courses.
- Video-based training for technology, leadership, management & more.
- Paid training with a facilitator who is dedicated to your onboarding and will track and evaluate your progress, giving you strategies to improve.
- A range of talent development programs to support career mobility.
Mentoring
- Utilize the skills of experienced leaders to enrich your career.
- Dedicated mentors to help you grow into new areas of Fidelity’s business as you develop new skills.
- An open atmosphere of knowledge sharing and collaboration.
- Opportunities to pay it forward, sharing the knowledge you develop and as you help others define how they want their career to take shape.
Web-Based Learning
- Online, video-based training that covers a broad range of technology, leadership, and management topics.
- Access to thousands of the latest and most relevant business books – all summarized in just a few pages.
- Train from your desk or the comfort of your home.
Our Commitment to Diversity and Inclusion
"Fidelity believes in, and is committed to, fair and equitable treatment for every associate and customer, and to creating a safe and respectful environment, in which everyone is treated with kindness, compassion and respect." Abby Johnson | Chairman and CEO Fidelity Investments
At Fidelity, we are committed to building an enduring culture of inclusion and belonging that will attract, develop and retain a diverse workforce.
Fidelity’s ten affinity groups are self-organized groups of employees with common interests in areas such as race, ethnicity, gender or sexual orientation, or who share similar interests based on similar sets of experiences.
These Employee Resource Groups and Special Interest Groups are models of inclusion for Fidelity. They’re also a powerful form of engagement and development and can provide a pathway to visible leadership roles. Our affinity groups make a large contribution on the business, helping to ensure our products and services are delivered in a welcoming and equitable environment.
- Over 22K employees participate in an affinity group.
- Over 1,400 affinity group members volunteered for Fidelity Cares in 2020.
- 74% increase in affinity group memberships over the last three years.
Giving Back to Our Communities
Throughout Fidelity, you’ll find a genuine commitment to social responsibility – where we strive to make an impact for customers, while also making an impact on the world.
Fidelity Cares
- Provides associates with opportunities to actively volunteer and share their talents.
- Hosts numerous company-wide volunteer events (in-person and virtual).
- Partners with nonprofit organizations to support our local communities.
- More than 12,000 associates donate time annually – from interns to SVPs.
- Impact includes refurbishing schools, donating books and supplies, and teaching financial literacy.
Fidelity Charitable®
- Created to make it easy for people to support charitable organizations they care about.
- Helped deliver $7.3 billion in donor-recommended grants to charity in 2019.
- Supported more than 300,000 unique charities around the world.
- Since its inception, more than $42 billion has been given to public charities.
