Principal Database Developer

$144,550 - $148,700/Yr

Fidelity Investments - Smithfield, RI

Full-time - Senior

Smithfield, RI

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

About the position

The Principal Database Developer is responsible for performing Extract, Transform, Load (ETL) data integration and developing data movement design patterns using Informatica and Oracle Exadata 12c. This role involves scheduling dependency management for distributed systems, automating application pipelines using CI/CD concepts, and developing cloud-native data warehousing solutions. The position requires collaboration with data architects and mentoring junior team members, ensuring data quality and governance across integrated datasets.

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.

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.
• Or, alternatively, a Master's degree in a related field and three years of experience as a Principal Database Developer developing data solutions using Oracle.
• Demonstrated expertise in designing and implementing database packages, functions, stored procedures, triggers, tables, and views; and writing complex queries using SQL/PLSQL and Native Stored Procedures on DB2 Database for ETL operations using Informatica according to Agile methodologies and CI/CD.
• Expertise in building complex data transformation workflows and procedures with Azure Cloud-based Oracle, on-prem Oracle, SQL Server, or DB2 Databases.
• Expertise in implementing data storage designs using normalized forms and defining system architecture and component interaction functionalities using UML.

Benefits

• Salary range of $144,550.00 - $148,700.00/year.