ETL Developer - Associate- Software Engineering

We’re seeking someone to join our CDRR Technology team as a ETL Developer, in Non-Financial Risk Technology to support Litigation and other Legal services. Applications provided by the department aim to provide stakeholders with a strategic technology vision, technical expertise, and implementation and support services enabling them to conduct and manage their activities in an innovative, efficient, and effective way.

In the Technology division, we leverage innovation to build the connections and capabilities that power our Firm, enabling our clients and colleagues to redefine markets and shape the future of our communities.

This is Associate position that develops and maintains software solutions that support business needs.

Since 1935, Morgan Stanley is known as a global leader in financial services, always evolving and innovating to better serve our clients and our communities in more than 40 countries around the world.

What you’ll do in the role:

• Collaborating with stakeholders to understand business requirements and developing optimized data transformation workflows for multiple data sources and destinations.

• Optimizing Database jobs for performance by collaborating with DBAs and implementing SQL coding and design changes within the job structure.

• Actively participated in troubleshooting and resolving issues related to data loading delays and database server outages, ensuring minimal disruption to data flow and system operations.

• Engaged in periodic reviews of job logs and performance metrics to identify trends, proactively addressing potential issues.

• Troubleshooting production issues through meticulous job log reviews, implementing necessary design changes via change management, and adhering to the code promotion process.

• Contributed to the development and maintenance of documentation for troubleshooting procedures, best practices, and system configurations, facilitating knowledge sharing within the team and managing Change Requests

• Resolving data issues arising from load delays or database server downtimes, with a focus on ensuring customer satisfaction.

What you’ll bring to the role:

• 4+ years of experience with data pipeline design and ETL jobs development using prominent tools such as Informatica, Talend, pySpark, Scala and other open-source ETL frameworks.

• Extracting data from various data sources, transforming, and loading it into target systems.

• Ensuring data quality, integrity, and consistency across different systems.

• Optimizing ETL processes for performance, scalability, and reliability.

• SQL proficiency (intermediate skill level minimum)

• Ability to manage complex data mappings and parallel process workflows.

• Troubleshooting and resolving data integration issues.

• Solid skills with writing/translating SQL queries and SQL data validation.

• Performance tuning of SQL queries.

• Defining, managing, and monitoring job schedules, as well as troubleshooting issues within the Autosys environment.

• Understanding and implementing job schedules, dependencies, and workflows within Autosys.

• Analyzing and resolving issues with ETL jobs and processes

WHAT YOU CAN EXPECT FROM MORGAN STANLEY:

At Morgan Stanley, we raise, manage and allocate capital for our clients – helping them reach their goals. We do it in a way that’s differentiated – and we’ve done that for 90 years.  Our values - putting clients first, doing the right thing, leading with exceptional ideas, committing to diversity and inclusion, and giving back - aren’t just beliefs, they guide the decisions we make every day to do what's best for our clients, communities and more than 80,000 employees in 1,200 offices across 42 countries. At Morgan Stanley, you’ll find an opportunity to work alongside the best and the brightest, in an environment where you are supported and empowered. Our teams are relentless collaborators and creative thinkers, fueled by their diverse backgrounds and experiences. We are proud to support our employees and their families at every point along their work-life journey, offering some of the most attractive and comprehensive employee benefits and perks in the industry. There’s also ample opportunity to move about the business for those who show passion and grit in their work.

To learn more about our offices across the globe, please copy and paste https://www.morganstanley.com/about-us/global-offices​ into your browser.

Morgan Stanley is an equal opportunity employer committed to building and maintaining a workforce that is diverse in experience and background.  Our recruiting efforts reflect our strong commitment to a culture of inclusion, where individuals are hired, developed, and advanced based on their skills and talents.

Our workforce reflects a broad cross-section of the global communities in which we operate, bringing a variety of backgrounds, talents, perspectives, and experiences.

For more information, please visit: https://www.morganstanley.com/people-opportunities/eeo.