Principal Database Developer

Fidelity Investments - Smithfield, RI

Full-time - Principal

Smithfield, RI

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

About the position

The Principal Database Developer at Fidelity Investments is responsible for performing Extract, Transform, Load (ETL) data integration and developing data movement design patterns. This role involves utilizing various technologies such as Informatica, Oracle Exadata, and cloud solutions to automate application pipelines and ensure data quality across integrated datasets. The position requires collaboration with data architects and mentoring junior team members, focusing on building scalable data pipelines and overseeing software system testing and validation procedures.

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

• Experience with ETL data integration using Informatica.
• Proficiency in Oracle Exadata 12c Relational Databases.
• Knowledge of Continuous Integration/Continuous Delivery (CI/CD) concepts.
• Experience with Cloud Computing and DevOps practices.
• Familiarity with Azure ADF, Redshift, and Snowflake for cloud native data warehousing and data lake solutions.
• Strong programming skills for developing data intensive applications and data pipeline design patterns.

Nice-to-haves

• Experience with Git and Jenkins for automating application pipelines.
• Familiarity with data governance practices and data quality assurance.

Benefits

• Health insurance coverage
• 401k retirement savings plan
• Paid holidays
• Professional development opportunities