Morgan Stanley Wealth Management (WM) needs to design, develop, deliver, and support the technical platform behind the products and services used by the Business, specifically in the area of data warehousing and ETL applications.
Requirements
- 5+ years of experience with the technical analysis and design, development and implementation of data warehousing / Data Lake solutions.
- Strong SQL programming and stored procedure development skills.
- 5+ years of experience developing in Informatica or any other ETL tool.
- Understanding/experience in Hive/Impala/Spark will be a plus
- 5+ years relational database experience (experience with Teradata and Snowflake is a big plus).
- Strong UNIX Shell scripting experience to support data warehousing solutions.
- Process oriented, focused on standardization, streamlining, and implementation of best practices delivery approach.
Responsibilities
- Design and development of ETL and Hadoop applications.
- Undertaking end-to-end project delivery (from inception to post-implementation support), including review and finalization of business requirements, creation of functional specifications and/or system designs, and ensuring that end-solution meets business needs and expectations.
- Development of new transformation processes to load data from source to target, or performance tuning of existing ETL code (mappings, sessions) and Hadoop Platform.
- Analysis of existing designs and interfaces and applying design modifications or enhancements
- Coding and documenting data processing scripts and stored procedures.
- Providing business insights and analysis findings for ad-hoc data requests
- Testing software components and complete solutions (including debugging and troubleshooting) and preparing migration documentation.
Other
- Bachelor's/Master's Degree in Engineering, preferably Computer Science/Engineering
- Good Team player
- Exposure to an Agile Development environment would be a plus.
- Ability to architect an ETL solution and data conversion strategy.
- Good understanding of dimensional modelling
