Data Engineer - Fidelity SOW (3 Openings) - Westlake, TX

Senior Data EngineerFidelity Investments Workplace Solutions (WS) organization is looking for senior Data Engineers. This person will be playing a key role in designing and crafting a modern data and information delivery and analytics platform in the cloud to support equity compensation products for the global markets. This person will be working closely with architects and engineers and business SMEs to build and release solutions that help customers get the information they need fast and intuitively.The expertise and skills you bring:Bachelor’s degree or equivalent in a technology related field (e.g. computer science, engineering, etc.) required10+ years of hands-on experience in data engineering, data warehousing and analytics technologiesExpert-level knowledge of writing complex SQL queries using Oracle.Expert-level knowledge of Oracle PL/SQL (stored procedures, functions, packages, triggers)Strong working experience in ETL tools like Informatica (Power Center)Working experience in scripting and automation using Unix, Python in a data engineering environment.Extensive experience with relational databases like Oracle including being able to implement performance tuning techniquesStrong working knowledge of data warehousing patterns and dimensional modeling techniques using Oracle.Experience building scalable patterns for data integration in a cloud-based as well as on-prem environmentsWorking knowledge of batch scheduling tools like Control-M, Autosys.Experience with business intelligence and analytics tools such as OBIEE/OASWorking experience using GitHub for source code management (SCM) in a data engineering practice.Experience working on projects in an agile environmentThe team:You will be part of the technology team in stock plan services business unit that administers equity compensation programs on behalf of public and private companies offering various compensations programs such as: employee stock purchase plans, restricted stock awards/units, stock option plans, stock appreciation rights and performance based awards. Currently SPS services approx. 3M participants employed by over 500 clients and spread out in 150 countries. The business is looking to further expand in the international equity compensation markets and servicing. As part of that we are modernizing our legacy reporting and business intelligence platform to provide data and analytics in real-time running in the cloud.