ETL informatica (4-8 years)
Morgan Stanley
Mumbai , Maharashtra, India, Japan Asia, Non
3d ago

Company Profile

Morgan Stanley is a leading global financial services firm providing a wide range of investment banking, securities, investment management and wealth management services.

The Firm's employees serve clients worldwide including corporations, governments and individuals from more than 1,200 offices in 43 countries.

Department Profile

Operations Technology is looking for a Data Engineer for their Mumbai office. IMRS Platform is a key component of Enterprise Metrics & Analytics Practice Area within Operations Technology.

This practice supports Global Operations Control Group by defining, acquiring, publishing, and analyzing an integrated set of key risk and performance metrics.

These metrics enable managers to make informed decisions, while executing the Firm’s objectives across the domains of Risk, Financial and Manpower.

Responsibilities

  • Responsible for the design, coding, testing, tuning and maintenance of DB2 datamarts, sound Python and Informatica code
  • Work directly with Modelers / Architects / DBA on data modeling, logical / physical schema design, SQL query tuning; and the application of data-related business rules while assisting in troubleshooting, debugging, and issue resolution
  • Communicate effectively with end users, peers, and management regarding assignments, and must have a can-do attitude and a desire to provide solutions
  • Delivering projects with a high-level of data quality and integrity
  • Meet deadlines and possess a proven record of successful project execution and delivery.
  • Demonstrate knowledge of SDLC processes and procedures adjusted for a Rapid Application Development methodology (agile)
  • Delivering projects with a high-level of data quality and integrity
  • Meet deadlines and possess a proven record of successful project execution and delivery
  • Provide support for the resolution of all reporting issues escalated by the Support Operations Team post-implementation.
  • Working with global development team to have designs implemented, tested, productionalized and present to user groups
  • Influencing decisions with divisional partners, internal teams, senior management, and external partners
  • Collaborate with the team to define the information architecture, advocating interaction design best practices with a focus on consistency and usability
  • Organization

    The Successful Candidate Should Have

  • 4-8 Years of strong development experience with Informatica with sound DB knowledge
  • Experience in python for automating data cleansing, data re-formatting, data transformation.
  • Good to have knowledge of one popular python framework (Flask, Django etc.)
  • Experience working with libraries like Numpy, Pandas etc.
  • Sound understanding of Data Architecture Principles, Data Governance, Data Strategy, Data Standards, Data Quality, Data Modelling and Data Definitions.
  • Extensive experience in designing and developing of complex mappings, applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter, joiner and sorter transformations
  • Experience in integration of various data sources like DB2, SQL Server, and Flat Files into the staging area and designing Parallel jobs
  • Strong Data Modeling skills - Enterprise Data Model (OLTP) and Dimensional modeling. Well versed with principles, techniques and best practices of data modeling.
  • Strong Skills in Relational Database (preferably DB2) including database design, performance tuning, writing complex DB programs etc.
  • Experience in closely working with application teams (ETL, Tableau etc.) and managing all the DB related activities such as DB modeling, design, development, maintenance and support
  • Demonstrate proficient skills in analysis and resolution of application performance problems.
  • Secondary Skills / Desired skills

  • Knowledge about Devops implementation in Data space
  • Understanding of Document oriented / NoSQL / Cloud datastore.
  • Cloud basics and Big data especially Spark is good to have
  • Knowledge of debugging & supporting queries arising from ETL tool like Informatica.
  • Financial Services experience will be a strong plus
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form