Senior Software Engineer in Test (SQL, ETL, Data Lake, Reporting) at Fidelity Investments

Merrimack, New Hampshire, United States

Apply Now

Not SpecifiedCompensation

Senior (5 to 8 years)Experience Level

Full TimeJob Type

UnknownVisa

Financial Services, TechnologyIndustries

Requirements

Bachelor’s Degree or equivalent in a technology related field (Computer Science, Engineering, etc.)
7+ years of relevant technical experience and experience in test automation
Experience with PL/SQL and complex queries, views, packages etc
Strong SQL skills plus Java and Python development experience
2+ years of Big Data, Data Lake or Data Warehouse experience (desired)
Experience with ETL Data Pipeline testing of Data Warehouse platforms; exposure to iCEDQ test tool preferred
Experienced in Big Data Reporting Tools (OBIEE / Tableau / Power BI)
Familiarity with business intelligence reporting platforms, such as Power BI (advantageous)
Playwright, Selenium knowledge (good to have)
Strong working knowledge of relational databases, like Oracle or Postgres, and data lake/warehouse concepts, such as Snowflake
Knowledge of data pipeline testing (distinct advantage)
Knowledge of CI/CD Pipelines
ISTQB Certification (nice to have)
Experience as Software Engineer in test automation of RESTful services (Cucumber, Junit, Selenium, RestAssured, Git, Gradle, Maven)
Data Engineer working with the latest Big Data technologies and tools (Snowflake, Airflow, AWS, Azure)
Expert knowledge in test automation frameworks and proficiency, quality and passion in coding ability
Experience with UI and Microservices Architecture, Restful API’s, Enterprise messaging like ActiveMQ, Kafka
Experience with DevOps, Continuous Integration and Delivery tools like Jenkins, Maven, uDeploy, Stash
Experience in executing projects in an Agile environment
Ability to collaborate with other technical and business experts in the team
Curiosity to stay current with new and emerging technologies and concepts

Responsibilities

Design, develop, maintain, and execute automated tests while adopting industry best practices and tools
Keep the focus of the work in terms of Customer obsession
Embrace continuous improvement regarding application quality and stability
Demonstrate strong sense of ownership for the quality of solution delivery
Be candid and honest in all discussions to ensure the best outcomes
Work with a team of business leaders and technologists focused on delivering a modern solution to Client Reporting via Automation, Continuous Integration and Test Data ecosystems
Collaborate significantly between members of various business and IT groups throughout the lifecycle of a typical project
Shape the technology vision and impact the Workplace Investing organization’s success

Skills

SQL

PL/SQL

Java

Python

ETL

Data Lake

Data Warehouse

Snowflake

Oracle

Postgres

Playwright

Selenium

Cucumber

JUnit

RestAssured

CI/CD

Airflow

AWS

Azure

Kafka

Tableau

Power BI

OBIEE

iCEDQ

Fidelity Investments

Investment management and financial services provider

About Fidelity Investments

Fidelity Investments offers a range of financial services and tools designed to help individuals manage their investments and stay informed about the markets. Their products include mobile applications and market monitoring tools that provide users with real-time market quotes, news, and trading capabilities. For example, the Fidelity Market Monitor for Glass delivers daily market quotes directly to Google Glass, while the Fidelity app for Windows Phone 8 allows users to access news and trading tools on their mobile devices. Additionally, features like the Watch List Visualization for iPad help users track stock price changes over time using a heatmap. What sets Fidelity apart from its competitors is its focus on integrating new technologies and user-friendly interfaces to enhance the investment experience. The goal of Fidelity Investments is to empower individuals with the information and tools they need to make informed financial decisions.

Boston, MassachusettsHeadquarters

1946Year Founded

$120,238.8MTotal Funding

DEBT_FINANCINGCompany Stage

Fintech, Financial ServicesIndustries

10,001+Employees

Benefits

Health Insurance

Mental Health Support

Hybrid Work Options

401(k) Retirement Plan

401(k) Company Match

Unlimited Paid Time Off

Parental Leave

Student Loan Assistance

Tuition Reimbursement

Risks

Loss of key personnel like Gita Bal may impact Fidelity's research capabilities.

Increased competition from Vanguard's new division could draw clients away from Fidelity.

Potential reputational risk from Bitcoin ETF outflows could affect Fidelity's offerings.

Differentiation

Fidelity Labs offers innovative beta products like Market Monitor for Google Glass.

Fidelity's mobile solutions are available on multiple platforms, including Windows Phone and iPad.

Fidelity's Open Limit Order Visualization provides unique insights into order execution proximity.

Upsides

Increased adoption of wearable tech could boost Fidelity's mobile solutions.

Growing interest in Bitcoin ETFs suggests expansion in Fidelity's digital asset offerings.

Rise of AI could benefit Fidelity's data analytics and AI-driven investment strategies.

Land your dream remote job 3x faster with AI

Try Jobo Free