Software Systems Engineer II
The Software Systems Engineer II position at Sony Interactive Entertainment LLC in San Diego, CA, focuses on implementing data quality and validation measures to ensure the accuracy and integrity of data stored in Snowflake. This role is integral to maintaining the high standards of data management that support PlayStation's global operations.
Key responsibilities include developing high-scale and distributed systems, implementing functions, stored procedures, complex SQL, and performance tuning. The engineer will conduct data mining and ETL processes using databases with large-scale and complex datasets, assess queries and visualizations for ad-hoc requests and ongoing reporting, and optimize processes to reduce data processing time and monthly expenditures. Additionally, the role involves troubleshooting systems to reconcile revenues, taxes, and product profitability in the data warehouse against heterogeneous source systems.
The ideal candidate will possess a Master's degree in Information Technology, Information Systems, or a related field, along with three years of experience in developing high-scale and distributed systems. Proficiency in MySQL and Oracle databases, Powercenter Informatica for ETL, Unix scripting, and AWS for on-demand cloud computing is required. Experience in integrating enhancements, performing regression and integration testing, and maintaining documentation using Microsoft Office is also essential.
The position offers a competitive salary range of $150,528.00 to $225,100.00 per year. Sony Interactive Entertainment provides a comprehensive benefits package, including medical, dental, vision, matching 401(k), paid time off, wellness programs, and employee discounts for Sony products.
Sony Interactive Entertainment fosters an inclusive environment that empowers employees and embraces diversity. The company encourages individuals with a passion for innovation, technology, and play to join their growing global team, offering opportunities for professional growth and development within a leading entertainment brand.