1 month ago
Westlake, TX, USAStaff+
Responsibilities
- Develop reusable frameworks, cross-project components, complex applications, subsystems, and application-level architectures.
- Design and implement Oracle database applications, data warehouses, operational data stores, database optimizations, and performance-tuning solutions.
- Architect and deliver enterprise data integration and ETL solutions using Informatica, including workflow orchestration, deployment packaging, and Control-M scheduling.
- Develop analytical data models, optimize PL/SQL data access, and create Tableau reports and dashboards for business intelligence users.
- Perform advanced impact analysis, root-cause analysis, technical and functional analysis, and system modernization across interconnected applications and data pipelines.
- Participate in architecture design teams, define development testing approaches, review test plans, and ensure QA readiness of software deliverables.
- Create technical documentation, project life-cycle plans, schedules, assignments, estimates, risk strategies, and delivery plans for multiple complex projects.
- Act as a liaison with business units, resolve technology issues, advise senior management on technical strategy, and mentor junior team members.
Requirements
- Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, or a closely related field and five years of relevant experience, or a master’s degree in one of those fields and three years of relevant experience.
- Experience developing software applications in a defined contribution environment using Oracle, Azure, Informatica, and Tableau.
- Expertise with Oracle database applications, data warehouses, operational data stores, SQL Developer, PL/SQL, Control-M, and UNIX.
- Experience with Oracle Exadata, Oracle 19c, Oracle Enterprise Manager, SQL Profiling, Optimizer Hints, database objects, partitioning, and performance tuning.
- Expertise designing and developing Informatica enterprise data integration and ETL solutions in UNIX/Linux environments.
- Experience designing analytical data models, optimizing PL/SQL data access, and developing Tableau reports and dashboards.
Benefits
- Fidelity is transitioning to a full-time onsite working model through a phased regional and role-based rollout; onsite requirements currently vary and may evolve, while fully remote roles are excluded from the transition.
About Fidelity
Fidelity Investments provides brokerage, retirement plan recordkeeping, wealth management, and asset management services to individuals, employers, advisors, and institutions, plus online trading platforms and mutual funds and ETFs. It earns fees from managing and administering assets, advisory services, and brokerage transactions. Founded in 1946 and headquartered in Boston, it is privately held and administers trillions of dollars for U.S. and global customers.