Data Engineer

Role : Data Engineer Location : Durham, NC Duration : 12 Months Visa : No OPT, CPT, H1B Job Description Fidelity 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 required 10+ years of hands-on experience in Data engineering, data warehousing and analytics technologies Expert-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 techniques Strong working knowledge of Datawarehousing patterns and Dimensional Modelling techniques using Oracle. Experience building scalable patterns for data integration in a cloud-based as well as on-prem environments Working knowledge of Batch scheduling tools like Control-M, Autosys. Experience with business intelligence and analytics tools such as OBIEE / OAS Working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice. Experience working on projects in an Agile environment The TeamYou 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.