Software Systems Engineer II , San Diego, CA

Overview

Play Station isn’t just the Best Place to Play — it’s also the Best Place to Work. Today, we’re recognized as a global leader in entertainment producing The Play Station family of products and services including Play Station®5, Play Station®4, Play Station®VR, Play Station®Plus, acclaimed Play Station software titles from Play Station Studios, and more.

Play Station also strives to create an inclusive environment that empowers employees and embraces diversity. We welcome and encourage everyone who has a passion and curiosity for innovation, technology, and play to explore our open positions and join our growing global team.

The Play Station brand falls under Sony Interactive Entertainment, a wholly-owned subsidiary of Sony Group Corporation.

Sony Interactive Entertainment LLC seeks a Software Systems Engineer II in San Diego, CA to implement data quality and validation measures to ensure accuracy and integrity of the data stored in Snowflake. Requires a Master’s in Information Technology, Information Systems or related field or equivalent and three (3) years of experience developing high scale and distributed systems and implementing functions, stored procedures, complex SQL, and performance tuning;

conducting data mining and extract to transform and load data using databases with large-scale and complex datasets; assessing queries and visualizations for ad-hoc requests and ongoing reporting; optimizing ongoing processes to reduce data processing time and monthly expenditures and convert full data load to incremental; troubleshooting systems to reconcile revenues, taxes, and product profitability in the data-warehouse against heterogeneous source systems;

utilizing MySQL and Oracle databases, Powercenter Informatica for ETL, Unix for scripting, and AWS for on demand cloud computing; and integrating enhancements and performing regression and integration testing to migrate code to all environments, capturing evidence, and maintaining track on Microsoft Office. Telecommuting and/or working from home may be permissible pursuant to company policies. Sony is an EOE.

Salary range: $ – $/year

• Implement data quality and validation measures to ensure accuracy and integrity of data stored in Snowflake.
• Develop high-scale and distributed systems; implement functions, stored procedures, and perform performance tuning.
• Conduct data mining and ETL processes (extract, transform, load) for large-scale and complex datasets.
• Assess queries and visualizations for ad-hoc requests and ongoing reporting.
• Optimize data processing to reduce processing time and costs; convert full data loads to incremental loads.
• Troubleshoot systems to reconcile revenues, taxes, and product profitability in the data-warehouse against heterogeneous source systems.
• Utilize MySQL and Oracle databases, Power Center Informatica for ETL, Unix scripting, and AWS for on-demand cloud computing.
• Integrate enhancements and perform regression and integration testing to migrate code across environments, capture evidence, and maintain documentation (e.g., via Microsoft Office).

• Master’s in Information Technology, Information Systems or related field or equivalent.
• Three (3) years of experience developing high-scale and distributed systems and implementing functions, stored procedures, complex SQL, and performance tuning.
• Experience with data mining, ETL, and data warehousing concepts; familiarity with Snowflake is implied by responsibilities.
• Proficiency with MySQL and Oracle databases; ETL tools such as Power Center Informatica;
  Unix scripting; and AWS cloud computing.
• Experience in regression and integration testing and migrating code across environments; ability to capture evidence and maintain tracking in Microsoft Office.

Interested candidates should note:
Telecommuting and/or working from home may be permissible pursuant to company policies. Sony is an Equal Opportunity Employer.

If applicable, the company may conduct background checks at the offer stage for all new employees (which may include criminal background checks for some roles). A Candidate Privacy Notice explains what personal information is…