Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Bangalore |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | Banking / Financial Services |
Functional Area | General / Other Software |
EmploymentType | Full-time |
*Company ProfileMorgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, wealth management and investment management services. With offices in more than 41 countries, the Firms employees serve clients worldwide including corporations, governments, institutions and individuals. For further information about Morgan Stanley, please visit www.morganstanley.com.Legal, Compliance and Governance TechnologyThe Legal, Compliance and Governance Technology organization provides IT support to the Morgan Stanley Legal and Compliance division. The Fraud Technology Department is responsible for detecting, preventing, notifying, and reporting on all Fraud outside and inside the firm. We provide technology solutions, consultation, controls, governance, and expertise to fraud analysts in operations and cybersecurity, define technology strategy and architecture, implement analytical, real-time, batch, and data-oriented solutions, and release custom and vendor-based solutions in partnership with other technology and business.Job ProfileDesigning and implementing effective data models and structures that meet our user requirements and needs. Analyzing our current data stores and determining how to more efficiently store data through consolidation, de-duplication, and other data management techniquesWorking closely with our data providers as we source data and maintaining relationships with them throughout the data lifecycleLeading a team of Data Analytics to accurately analyze user requirements, profile incoming data, and document relevant metadata within our data catalog and system dictionaryWorking closely our ETL Developers and Data Analytics Developers to provide necessary guidance on how data models should be used by the ETL workflows and analytics queries that they developHelping ensure that the LCG usage of data adheres to our Firmwide Data Policy, and that proper governance is enforced, *Skill SetAtleast 5+ years of SQL / PLSQL experience with the ability to write ad-hoc and complex queries and with developing complex stored procedures, triggers, MQTs and views on IBM DB2 (experience with v10.5 a plus)At least 4+ years of experience developing complex stored procedures, triggers, MQTs and views on IBM DB2 (experience with v10.5 a plus)Experience with various data source types (RDBMS, XML, JSON, etc.),Familiarity with common ETL / ELT tools (i.e. Informatica, Talend, etc)Experience with Data Cataloging tools and concepts (e.g. Collibra,),Strong oral and written communication skillsQualifications/CriterionBachelor s Degree7+ years of Data Warehousing experience. 5+ years of experience producing data models to support OLTP and OLAP platforms Strong understanding of advanced data warehouse concepts (Factless Fact Tables, Temporal BI-Temporal models, etc.)Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximise their full potential. Our skilled and creative workforce is comprised of individuals drawn from a broad cross section of the global communities in which we operate and who reflect a variety of backgrounds, talents, perspectives and experiences. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talents.
Keyskills :
ibm db2it supportdata modelsdata analyticsdata managementdata warehousingwealth managementstored proceduresuser requirementsinvestment bankingfinancial servicesequal opportunitiesfinancial accounting