Principal Database Developer

2 days ago


Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time
Job Description:

As a Principal Database Developer at Fidelity Investments, you will play a key role in designing and implementing database solutions that drive business growth and customer satisfaction. Your expertise in database development, data integration, and data governance will be essential in delivering high-quality solutions that meet the needs of our customers.

Key Responsibilities:
  • Design and implement database solutions using Oracle and other database management systems.
  • Develop and maintain data integration pipelines using Informatica and other ETL tools.
  • Collaborate with data architects to craft and implement data governance policies and procedures.
  • Develop and implement tests to ensure data quality and proper governance across all integrated datasets.
  • Provide 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.
Requirements:
  • Bachelor's degree in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field.
  • Five years of experience as a Principal Database Developer (or a closely related occupation) developing data solutions using Oracle.
  • Demonstrated expertise in 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.
  • Demonstrated expertise in building complex data transformation workflows and procedures with Azure Cloud-based Oracle, on-prem Oracle, SQL Server, or DB2 Databases.
  • Demonstrated expertise in 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.
Salary:

$144,550.00 - $148,700.00/year.

Certifications:

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.



  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Description:Fidelity Investments is seeking a highly skilled Principal Database Developer to join our team. As a key member of our database development team, you will be responsible for designing, implementing, and maintaining complex database solutions using Oracle and other technologies.Key Responsibilities:Design and implement database packages,...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Description:Fidelity Investments is seeking a highly skilled Principal Database Developer to join our team. As a key member of our database development team, you will be responsible for designing, implementing, and maintaining complex database solutions using Oracle and Informatica.Key Responsibilities:Design and implement database packages, functions,...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job DescriptionJob Title: Principal Systems AnalystJob Summary:We are seeking a highly experienced Principal Systems Analyst to join our team. As a key member of our organization, you will be responsible for analyzing complex business problems and developing innovative solutions to drive business growth and improvement.Key Responsibilities:Collaborate with...

  • Principal Architect

    4 weeks ago


    Smithfield, Rhode Island, United States Fidelity Investments Full time

    Job Title: Principal ArchitectFidelity Investments is seeking a highly skilled Principal Architect to lead the development of a modern, digital API ecosystem. As a key member of our Enterprise Architecture team, you will be responsible for crafting a scalable and extensible architecture that delivers better customer experiences faster.The Purpose:Our team is...


  • Smithfield, Rhode Island, United States Mastech Digital Full time

    Job Title: Salesforce DeveloperMastech Digital Inc. is a leading provider of digital transformation solutions. As a Salesforce Developer, you will play a key role in helping our clients achieve their business goals through the effective use of Salesforce technology.About the Role:We are seeking a highly skilled Salesforce Developer to join our team. The...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Description:As a seasoned professional, you will design and implement end-to-end software solutions using.Net Technology stack, SQL Server Database, Oracle Datawarehouse, Snowflake EDL, Business Intelligence Tools, Salesforce CRM, and Internal C2C Cloud Technology tools. Your expertise will be utilized to perform analytics, extract, transform and load...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Description:As a seasoned professional, you will design and implement end-to-end software solutions using.Net Technology stack, SQL Server Database, Oracle Datawarehouse, Snowflake EDL, Business Intelligence Tools, Salesforce CRM, and Internal C2C Cloud Technology tools. Your expertise will be utilized to perform analytics, extract, transform and load...


  • Smithfield, Rhode Island, United States Eliassen Group Full time

    Job Title: Full Stack EngineerAre you a skilled software engineer looking for a challenging opportunity? We have an exciting contract position available for a Full Stack Engineer to join our team at Eliassen Group.Job Summary:We are seeking a highly motivated and experienced Full Stack Engineer to join our team. As a Full Stack Engineer, you will be...


  • Smithfield, Rhode Island, United States Compunnel Inc. Full time

    About the RoleWe are seeking a highly skilled Full Stack Engineer to join our team at Compunnel Inc.This is a 50/50 Full Stack role that requires hands-on experience with Angular, Java, Springboot, SQL, EKS, AWS Cloud, and DevOps.Key ResponsibilitiesPerform independent technical and functional analysis for determining and developing the best delivery...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Title: Principal, Full Stack EngineerJob Summary:We are seeking a highly skilled and experienced Principal, Full Stack Engineer to join our team. As a key member of our development chapter, you will be responsible for leading the engineering and development of quality software components and applications for brokerage products. You will help drive and...


  • North Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Title: Senior Java DeveloperWe are seeking a highly skilled Senior Java Developer to join our team at Fidelity TalentSource LLC. As a Senior Java Developer, you will be responsible for designing and developing microservices that can handle large volumes of data and integrate with other distributed systems in a scalable manner.Key Responsibilities:Design...

  • Data Analyst

    3 weeks ago


    Smithfield, Rhode Island, United States Pyramid Consulting, Inc Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Pyramid Consulting, Inc. in Smithfield, RI. This is a 15+ months contract opportunity with long-term potential.Job Summary:The successful candidate will be responsible for analyzing and interpreting complex data to inform business decisions. This will involve working with...

  • Senior Data Engineer

    3 weeks ago


    Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Title: Senior Data EngineerJob Summary:Fidelity Investments is seeking a highly skilled Senior Data Engineer to design and develop resilient data infrastructure for our 401k recordkeeping platform. The ideal candidate will have expertise in Oracle databases on Azure, Azure Data Factory, and data replication using Oracle GoldenGate or IBM Change Data...


  • Smithfield, Rhode Island, United States Yoh Full time

    Java Software EngineerYoh, a Day & Zimmermann company, is seeking a skilled Java Software Engineer to join our team. As a Java Software Engineer, you will be responsible for designing, developing, and maintaining large-scale Java applications.Key Responsibilities:Design and develop Java applications using AWS, Terraform, and Kubernetes.Work with databases,...


  • Smithfield, Rhode Island, United States Neighborhood Health Plan of RI Full time

    Job SummaryThe Enrollment Manager will oversee the accurate and timely processing of Medicare enrollments, re-enrollments, and disenrollments. This role will ensure compliance with regulatory requirements and maintain strong relationships with internal and external stakeholders.Key ResponsibilitiesManage enrollment activities for Medicare-Medicaid lines of...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Job Description:We are seeking a highly skilled Business Solutions Architect to join our team at Fidelity Investments. As a key member of our operations team, you will be responsible for designing and implementing end-to-end software solutions using.Net Technology stack, SQL Server Database, Oracle Datawarehouse, Snowflake EDL, Business Intelligence Tools,...


  • Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    About the RoleFidelity TalentSource is seeking a skilled Software Engineer in Test to join our team. As a key member of our QA team, you will be responsible for ensuring the quality and reliability of our software applications.Key ResponsibilitiesDesign and implement automated test scripts using tools such as Cucumber, Fitnesse, and SeleniumCollaborate with...

  • Lead Systems Analyst

    2 months ago


    Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Senior Business Systems ConsultantThe Senior Business Systems Consultant role at Fidelity TalentSource involves serving as the primary knowledge expert and key advisor for intricate projects within the organization. This position necessitates proficiency in translating business needs into system specifications for development teams, alongside providing...


  • Smithfield, Rhode Island, United States Goli Tech Full time

    Job Title: Senior Data EngineerWe are seeking a highly skilled Senior Data Engineer to join our team at Goli Tech. As a key member of our Cash and Positions Development team, you will be responsible for designing, developing, and implementing data engineering solutions to support our clients' Managed Account and Portfolio Solutions team.Key...

  • Lead Systems Analyst

    2 months ago


    Smithfield, Rhode Island, United States Fidelity TalentSource LLC Full time

    Senior Business Systems ConsultantThe Senior Business Systems Consultant position at Fidelity TalentSource entails serving as the primary authority on business knowledge and a crucial advisor for intricate projects within the organization. This role necessitates proficiency in converting business needs into system specifications for development teams,...