Principal Database Developer

$144,550 - $148,700/Yr

Fidelity Investments - Smithfield, RI

Full-time - Senior

Hybrid - Smithfield, RI

Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Principal Database Developer role focuses on performing Extract, Transform, Load (ETL) data integration and developing data movement design patterns using Informatica and Oracle Exadata 12c. The position involves scheduling dependency management, automating application pipelines, and implementing cloud-native data warehousing solutions. The developer will also oversee software testing and validation procedures while mentoring junior team members.

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.
• Mentors junior team members.

Requirements

• Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field and five years of experience as a Principal Database Developer developing data solutions using Oracle.
• Alternatively, a Master's degree in a related field and three years of experience as a Principal Database Developer.

Nice-to-haves

• Experience with Continuous Integration/Continuous Delivery (CI/CD) concepts.
• Familiarity with Azure ADF, Redshift, and Snowflake for data warehousing solutions.

Benefits

• Flexible benefits that support employees through every stage of their career.
• Recognition as a top 10 Best Place to Work in 2024 by Glassdoor.
• Hybrid working model that blends onsite and offsite work experiences.