Informatica Developer 3140230
Morgan Stanley
Montréal, QC

About $98,000 - $130,000 a year

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.

As a market leader, the talent and passion of our people is critical to our success. Together, we share a common set of values rooted in integrity, excellence and strong team ethic. Morgan Stanley can provide a superior foundation for building a professional career - a place for people to learn, to achieve and grow. A philosophy that balances personal lifestyles, perspectives and needs is an important part of our culture.


Technology works as a strategic partner with Morgan Stanley business units and the world's leading technology companies to redefine how we do business in ever more global, complex, and dynamic financial markets. Morgan Stanley's sizeable investment in technology results in quantitative trading systems, cutting-edge modelling and simulation software, comprehensive risk and security systems, and robust client-relationship capabilities, plus the worldwide infrastructure that forms the backbone of these systems and tools. Our insights, our applications and infrastructure give a competitive edge to clients' businesses—and to our own.

Corporate and Funding Technology is comprised of three primary areas: Operations & Risk, Corporate and Client Financing.

  • Operations & Risk helps the Firm’s businesses while maintaining a strong risk profile. The group includes Operations, Funding, Finance and Risk Technology.
  • Corporate improves our operating environment and is made up of Legal, Compliance & Corporate Governance, Digital & Corporate Communications and Human Resources Technology groups.
  • Client Financing platforms provide technology and service to our hedge fund and Asia high-net-worth clients. Groups include Prime Brokerage, Private Wealth Management Asia and Counterparty Risk Technology.
Position Description:
Global Operations Regulatory Reporting is seeking for a 5+ year Informatica Developer with data warehouse experience to build and support regulatory reporting applications. We support Operations and Compliance on their daily filings to regulators. The individual will work with different technology teams to integrate data flows and generate daily disclosures for users to review prior to the filing deadline.

A successful candidate will work with global teams across New York, Montreal and India and will be accountable for

  • Designing, coding, testing, tuning and maintenance of DB2 datamarts 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)
  • 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
Skills Requirements

  • 5+ years of development experience in Informatica
  • Bachelor degree in Computer Science or related field
  • 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, Oracle, SQL Server, and Flat Files into the staging area
  • Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Modify, Aggregator, XML parsing stages. Good experience with ETL tools: Informatica or SSIS/Data Stage
  • Good knowledge in identifying performance bottlenecks and also in tuning the Mappings and Sessions
  • Expert knowledge of DB2, MS-SQL or Oracle, SQL Stored Procedures, Triggers, and data querying optimization
  • Excellent communication, interpersonal, analytical and leadership skills, self-motivated, quick learner and a team player. Ability to work in a team and individually, independent thinker, focused on meeting deliverables in a remote environment
  • Clear understanding of RDBMS, ER, 3rd n forms, OLAP dimensional Models
  • Ability to effectively interact with, present information to, and respond to questions from all levels of the organization and partners.
  • Ability to communicate complex analysis in a clear, precise, and actionable manner
  • Comfortable with ambiguity, creative thinking and leading change
  • Ability to research and troubleshoot technical problems
Nice to have

  • Financial Services experience will be a strong plus
  • Working experience on Java, Perl, Hadoop, Dataiku, Autosys, GIT
Knowledge of French and English is required.

Morgan Stanley is an equal opportunities employer. We work to provide a supportive and inclusive environment where all individuals can maximize their full potential.