Job Classification:

　　Technology - Engineering & Cloud

　　A GLOBAL FIRM WITH A DIVERSE & INCLUSIVE CULTURE

　　As the Global Asset Management business of Prudential, we're always looking for ways to improve financial services. We're passionate about making a meaningful impact - touching the lives of millions and solving financial challenges in an ever-changing world.

　　We also believe talent is key to achieving our vision and are intentional about building a culture on respect and collaboration. When you join PGIM, you'll unlock a motivating and impactful career - all while growing your skills and advancing your profession at one of the world's leading global asset managers!

　　If you're not afraid to think differently and challenge the status quo, come and be a part of a dedicated team that's investing in your future by shaping tomorrow today.

　　At PGIM, You Can!

　　What you will do

　　Our Technology Solutions Group is a dynamic, fast-paced environment, with exciting changes on the horizon under new senior leadership. We are looking for an astute, determined professional like you to fulfil a Database Developer role within our Technology Solutions Group. You will showcase your success in an Agile environment through collaboration, ownership and innovation. Your expertise in emerging trends and practices will evoke stimulating discussions around optimization and change to help keep our competitive edge. This rewarding opportunity will enable you to make a big impact in our organization, so if this sounds exciting, then PGIM might be the place

　　What you can expect

　　Design, develop, and maintain SQL code to process data from various data pipelinesCreate and maintain data storage solutions, such as data warehouses, data lakes, and databases. Optimize data storage structures for performance and cost-effectiveness.Integrate and merge data from different sources while ensuring data quality, consistency, and accuracy.Manage and optimize data warehouses to store and organize data for efficient retrieval and analysis.Cleanse, preprocess, and transform data to meet business requirements and maintain data quality.data pipelines and database performance to ensure data processing efficiency.Implement and maintain security measures to protect sensitive data and ensure compliance with data privacy regulations.Align with the Product Owner and Scrum Master in assessing business needs and transforming them into scalable applications.Build and maintain code to manage data received from heterogenous data formats including web-based sources, internal/external databases, flat files, heterogenous data formats (binary, ASCII).Build new enterprise Datawarehouse and maintain the existing one.Design and support effective storage and retrieval of very large internal and external data set and be forward think about the convergence strategy with our AWS cloud migrationAssess the impact of scaling up and scaling out and ensure sustained data management and data delivery performance.Build interfaces for supporting evolving and new applications and accommodating new data sources and types of data.

　　What you will bring

　　5+ years of experience as a database developerStrong knowledge of various Snowflake development features such as SnowPipe, Streams, SQL REST API, Procedures, User Defined Functions, External Functions, Tagging, Masking, Data Lineage, SnowParkProficiency in SQL, data querying, and performance optimization techniquesProficiency in procedural languages such as MSSQL TSQL, Postgres pl/sqlExperience in developing Datawarehouse and OLTP applicationsProficiency in data modeling, database design, and SQL.3+ years of experience developing and deploying applications in SnowflakeFamiliarity with AWS services like S3, DMS, EC2, Glue, LambdaProficiency in Aurora Postgres database clusters on AWSFamiliarity with Orchestration tools like Airflow, Autosys, etcAbility to communicate the status, challenges and proposed solution with the team.Demonstrating the ability to learn new skills and work as a team.Knowledge of data security and privacy best practices.Working knowledge of data governance and ability to ensure high data quality is maintained throughout the data lifecycle of a project.Knowledge of data visualization and business intelligence tools (e.g., Tableau, Power BI).Ability to prioritize multiple tasks and projects and work effectively under pressure; exceptional organizational and administrative skills; at ease with abundance of details, yet mindful of big picture at all times.Strong analytical and problem-solving skills, with ability to conduct root cause analysis on system, process or production problems and ability to provide viable solutions.Experience working in an Agile environment with Scrum Master/Product owner and ability to deliver.

　　What will set you apart?

　　Good understanding of Snowflake infrastructure - account structure, warehouses, roles, connectivity patterns, AD integration, S3 integration, KMS integration, Cost GovernancePython API Development/Snowflake snowpark coding experienceStreaming or messaging knowledge with Kafka or Kinesis is desirable.Understanding of capital markets within Fixed Income

　　*PGIM welcomes all applicants, even if you don't meet every requirement. If your skills align with the role, we encourage you to apply.

　　What we offer you

　　Medical, dental, vision, life insurance and PTO (Paid Time Off)Retirement plans:401(k) plan with generous company match (up to 4%)Company-funded pension planWellness Programs to help you achieve your wellbeing goals, including up to $1,600 a year for reimbursement of items purchased to support personal wellbeing needsWork/Life Resources to help support topics such as parenting, housing, senior care, finances, pets, legal matters, education, emotional health, and career development.Tuition Assistance to help finance traditional college enrollment, approved degrees, many accredited certificate programs, and industry designations.

　　To find out more about our Total Reward package, visit Work Life Balance | Prudential Careers

　　Note: Prudential is required by state specific laws to include the salary range for this role when hiring a resident in applicable locations. The salary range for this role is from $110,000 to $140,000. Specific pricing for the role may vary within the above range based on many factors including geographic location, candidate experience, and skills. Roles may also be eligible for additional compensation and/or benefits. Eligibility to participate in a discretionary annual incentive program is subject to the rules governing the program, whereby an award, if any, depends on various factors including, without limitation, individual and organizational performance.

　　About PGIM Fixed Income Group PGIM Fixed Income is a global asset manager offering active solutions across all fixed income markets. With approximately 1000 employees and $793bn assets under management, the company has offices in Newark, London, Letterkenny, Amsterdam, Munich, Zurich, Tokyo, Hong Kong, and Singapore. Our business climate is a safe inclusive environment, centered around mutual respect, intellectual honesty, transparency, and teamwork. Our leaders are focused on talent & culture; dedicated to fostering growth & development at all levels to develop the industry leaders of tomorrow.

　　About PGIM - Global Asset Management

　　PGIM is the global asset management business of Prudential Financial, Inc. (NYSE: PRU), a leading global investment manager with nearly US$1.27 trillion in assets under management as of June 30th, 2023 With offices in 18 countries, PGIM's businesses offer a range of investment solutions for retail and institutional investors around the world across a broad range of asset classes, including public fixed income, private fixed income, fundamental equity, quantitative equity, real estate and alternatives.

　　With a history dating back 145 years, and experience through more than 30 market cycles, PGIM takes a long-term view, not only in our investment philosophy, but also in how we develop our talent. We want to see our employees excel from their first day with the firm and throughout their tenure with PGIM. We will inspire you, support you, and help you reach your greatest personal and professional aspirations. If PGIM sounds like the place for you, join us. For more information about PGIM, visit PGIM.com.

　　Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom.

　　Our Commitment to Diversity, Equity, and Inclusion

　　Prudential Financial, Inc. is focused on creating a fully inclusive culture, where all employees feel comfortable bringing their authentic selves to work. We don't just accept difference-we celebrate it, support it, and thrive on it. At Prudential, employees have a unique opportunity to build their career path by owning their development, their career, and their future. We encourage employees to hone their skills and explore continued opportunities within Prudential.

　　#LI-MM1

　　Prudential Financial, Inc. of the United States is not affiliated with Prudential plc. which is headquartered in the United Kingdom.

　　Prudential is a multinational financial services leader with operations in the United States, Asia, Europe, and Latin America. Leveraging its heritage of life insurance and asset management expertise, Prudential is focused on helping individual and institutional customers grow and protect their wealth. The company's well-known Rock symbol is an icon of strength, stability, expertise and innovation that has stood the test of time. Prudential's businesses offer a variety of products and services, including life insurance, annuities, retirement-related services, mutual funds, asset management, and real estate services.

　　We recognize that our strength and success are directly linked to the quality and skills of our diverse associates. We are proud to be a place where talented people who want to make a difference can grow as professionals, leaders, and as individuals. Visit www.prudential.com to learn more about our values, our history and our brand.

　　Prudential is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, ancestry, sex, sexual orientation, gender identity, national origin, genetics, disability, marital status, age, veteran status, domestic partner status , medical condition or any other characteristic protected by law.

　　The Prudential Insurance Company of America, Newark, NJ and its affiliates.

　　Note that this posting is intended for individual applicants. Search firms or agencies should email Staffing at [email protected] for more information about doing business with Prudential.

　　PEOPLE WITH DISABILITIES:

　　If you need an accommodation to complete the application process, which may include an assessment, please email [email protected].

　　Please note that the above email is solely for individuals with disabilities requesting an accommodation. If you are experiencing a technical issue with your application or an assessment, please email [email protected] to request assistance.