Fidelity is looking to solve the problem of building technical infrastructure required for Extraction, Transformation, and Loading (ETL) of data and designing cloud native applications using Azure, Streamsets, and other technologies to enable greater data scalability and improve software solutions and data services.
Requirements
- Demonstrated Expertise (DE) designing data architecture and models; developing and implementing technology applications to identify data anomalies and patterns using SQL and Shell scripting;
- DE analyzing data across the organization hosted on database platforms by writing complex SQL or PL/SQL queries in Oracle, Microsoft SQL Server, MySQL, Snowflake, and NOSQL datastores -- Mongo DB -- using Toad, SQL developer and MySQL workbench;
- DE performing SQL tuning of complex queries and building technical infrastructure required for efficient transformation of data using ETL tools(Informatica PowerCenter, OWB, and DIH);
- DE writing stored procedures to perform data analytics on OLTP and OLAP data warehouses;
- Generating financial intelligence using Microsoft Power BI and Oracle Business Intelligence (BI) tools;
- Conducting jobs automation using scheduling tools -- Autosys, Control M, Dollar Universe, UNIX, and LINUX Shell Scripts.
- Experience with Java, Informatica, Object-Oriented (OO) scripting languages, Azure, Streamsets, SQL, Snowflake, NoSQL, and Oracle.
Responsibilities
- Develops original and creative technical solutions to on-going development efforts.
- Establishes project plans for projects of moderate scope.
- Performs independent and complex technical and functional analysis for multiple projects supporting several initiatives.
- Collaborates cross-functionally to define, build, refine, and evolve resilient data platforms.
- Develops performance optimization using SQL tuning.
- Supports and performs all phases of testing leading to implementation.
- Assists in planning and execution of user acceptance testing.
Other
- Bachelor’s degree in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field (or foreign education equivalent)
- Three (3) years of experience as a Senior Data Engineer (or closely related occupation) performing data engineering, advanced data analytics, and database performance tuning and automation within an Insurance, Healthcare, or financial services environment.
- Alternatively, Master’s degree in Computer Science, Engineering, Information Technology, Information Systems, Mathematics, Physics, or a closely related field (or foreign education equivalent) and one (1) year of experience as a Senior Data Engineer (or closely related occupation)
- Must work onsite every other week (all business days, M-F) in a Fidelity office.
- Must comply with the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, and other relevant laws and regulations.
