Overview We are seeking a talented Data Engineer with a strong background in on-premise data processing technologies, especially Informatica PowerCenter. The ideal candidate should be passionate about data, have excellent command over database management, SQL, and performance tuning, and enjoy collaborating with diverse teams to deliver robust data solutions. Key Responsibilities > Design, develop, and maintain data integration workflows using Informatica PowerCenter. > Work extensively with relational databases (DB2, or similar) including database design, writing and optimizing complex SQL queries, and performance tuning. > Implement and optimize data models for both OLTP and analytical workloads. > Troubleshoot and resolve performance issues in ETL jobs and database queries. > Collaborate with application teams and business analysts to understand data requirements and translate them into scalable solutions. > Ensure data quality, governance, and security standards are met throughout the data lifecycle. > Maintain and support existing ETL processes and database systems, proactively identifying areas for improvement. Required Skills and Experience > 3-4 years of hands-on development experience with Informatica PowerCenter. > Strong expertise in relational databases (preferably DB2), including schema design, complex SQL development, and performance tuning. > Solid understanding of Data Architecture Principles, Data Governance, Data Strategy, Data Standards, Data Quality, and Data Modeling (both enterprise and dimensional models). > Experience with designing and developing complex ETL mappings, including the use of various Informatica transformations (lookup, aggregator, router, joiner, etc.). > Proven analytical and problem-solving skills with the ability to identify root causes and implement practical solutions. > Effective communication skills and ability to work in a team-oriented environment. Good-to-Have (Secondary Skills) While not mandatory, experience in the following areas will be considered a plus: > Exposure to cloud data platforms such as Snowflake. > Experience with scripting/programming languages (e.g., Python) for automating data cleansing, transformation, or workflow orchestration. > Familiarity with popular Python libraries for data (e.g., Pandas, Numpy). > Knowledge of one popular Python framework (Flask, Django, etc.). > Experience working with data visualization or BI tools (e.g., Tableau). > Awareness of modern data warehousing and big data concepts. WHAT YOU CAN EXPECT FROM MORGAN STANLEY: We are committed to maintaining the first-class service and high standard of excellence that have defined Morgan Stanley for over 89 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 opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential. At Morgan Stanley, we advise, originate, trade, manage and distribute capital for people, governments and institutions, always with a standard of excellence and guided by our core values. Morgan Stanley is dedicated to providing first-class service to our clients, in a way that reflects our commitment to creating a more sustainable future and fostering stronger communities around the world. In each line of business, we strive to demonstrate our belief in the power of transformative thinking, innovative strategies and leading-edge solutions—and in the ability of capital to work for the benefit of all society. What We Do
