19 May

Etl Developer - Bangalore - Morgan Stanley

Position
Etl Developer
Company
Morgan Stanley
Location
Bangalore KA
Opening
19 May, 2017 4 days ago

Morgan Stanley as the company that open the jobs vacancy, have some qualification and spesification especially for the Etl Developer jobs vacancy. To find out more information and about qualification and spesification details, walkin interview schedule, the address of the company, the company contact info (email/phone number) of Morgan Stanley company, please start to apply for the job vacancy with fill the jobs application with click the 'Apply This Job' button below.

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.

Overview on Operations Compliance and Technology

Operations and Compliance Technology (OCT) is looking for a DB2 UDB Database Administrator. OCT is a global team responsible for providing technology solutions to Morgan Stanleys global Operations and Compliance departments such as Confirmations, Settlements, Accounting & Risk Analysis & Metrics among others. IMRS Platform is a key component of Enterprise Metrics & Analytics Practice Area within OCT. This practice supports Global Operations and Finance 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 Firms objectives across the domains of Risk, Financial and Manpower.

Operations and Compliance Technology (OCT) is looking for an ETL developer for our Bengaluru office. IMRS Platform is a key component of Enterprise Metrics & Analytics Practice Area within OCT. This practice supports Global Operations and Finance 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.

The successful candidate will work with global teams spread across Mumbai and New York. You will get the opportunity to develop new streams, enhance existing streams and work on critical data sourcing aspect of the project. You will also get the opportunity to work with upstream Technology teams, Report users (Sr. management), internal/external vendors, Support teams related to requirement, design, development and user support.

The successful candidate will work with global teams spread across New York, Montreal and India and will be accountable for
- Responsible for the design, 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

Requirements
- 5+ years of development experience in Informatica
- 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
- 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, 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
- Financial Services experience will be a strong plus
- Ability to research and troubleshoot technical problems

Qualifications

Operations and Compliance Technology (OCT) is looking for an ETL developer for our Bengaluru office. IMRS Platform is a key component of Enterprise Metrics & Analytics Practice Area within OCT. This practice supports Global Operations and Finance 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.

The successful candidate will work with global teams spread across Mumbai and New York. You will get the opportunity to develop new streams, enhance existing streams and work on critical data sourcing aspect of the project. You will also get the opportunity to work with upstream Technology teams, Report users (Sr. management), internal/external vendors, Support teams related to requirement, design, development and user support.

The successful candidate will work with global teams spread across New York, Montreal and India and will be accountable for
- Responsible for the design, 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

Requirements
- 5+ years of development experience in Informatica
- 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
- 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, 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
- Financial Services experience will be a strong plus
- Ability to research and troubleshoot technical problems


Other Etl Developer Jobs Vacancy

19May

Etl Developer. Job Openings in Barclays for Etl Developer, this job opened at 19 May, 2017. Proficient in designing & developing Informatica ETL components. Conduct code reviews with the developers within the development team.... ... (Read more about Etl Developer - Pune - Barclays)


24Apr

Women Technology Bangalore. Job Openings in Morgan Stanley for Women Technology Bangalore, this job opened at 24 Apr, 2017. We are inviting Core Java, Database, JavaScript Angular JS, UI designers, ETL, QA, Application support, Tableau, Data warehouse, Mainframe, MS Office, Teradata... ... (Read more about Women Technology Bangalore - Bangalore - Morgan Stanley)


17May

Python Developer Bangalore Years Tsql Aws. Job Openings in Sonata Software for Python Developer Bangalore Years Tsql Aws, this job opened at 17 May, 2017. Python Developer, Bangalore, [5+ Years],TSQL, AWS. Skillset required in prioritization order 2+ years Experience in Python 5+ years Experience with SQL and... ... (Read more about Python Developer Bangalore Years Tsql Aws - Bangalore - Sonata Software)


05May

Database Developer. Job Openings in Jocata for Database Developer, this job opened at 05 May, 2017. ETL and Big Data experience is a plus. 5+ years working as a database engineer or a related role.... ... (Read more about Database Developer - - Jocata)


  • Company: Jocata
  • Added: 18 days ago

23May

Data Engineer. Job Openings in General Electric for Data Engineer, this job opened at 23 May, 2017. Coach developers on best practices and standards. Development of reports in OBIEE, Tableau and ETL using Informatica and ODI.... ... (Read more about Data Engineer - Bangalore - General Electric)