Teradata Technical Consultant - MSTR developer in Pune, India

As the global leader in data warehousing and analytic technologies, Teradata solutions make smart companies smarter. Teradata gives companies the people, technology, innovation and a world-class network of customers and partners enabling them to gain competitive advantage in their respective Industries and markets. Learn more at www.teradata.com

Job Title: Microstrategy Consultant

Job Category: Permanent

Job Location: Mumbai/Pune

Teradata Professional Services is looking for BI Consultants for supporting their DW/BI/Analytics Implementation projects for one of their leading customers in India, a global Sales and Marketing Consultancy providing expert technology services

Teradata Professional Services provides a unique, results oriented and challenging work environment with excellent opportunities to learn and grow with the organization through focused technology training and development programs for its Consultants

Our customer is recognized as a world leader in developing sales and marketing strategies for their clients and their ability to use technology solutions innovatively to solve complex business problems. They deliver technology projects in the area of DW/BI/Analytics for major clients in US, Europe and APAC through their technology centres in India.

Roles and Responsibilities of the BI Consultant

The BI Consultant will be a key member of the Teradata Professional Services team with expertise in working across the Microstrategy product line and versions. The Consultant is expected to take full responsibility of tasks assigned for developing and/or configuring BI application development work packages for managing the visualization aspects of any proposed BI solution. The Consultant shall work very closely with a project team and be responsible for the following:

  • Understanding the customers’ business requirements thoroughly and being able to translate them into BI reporting requirements

  • Designing the solution in the form of reporting design documents including format and layout designs along with building the integration of the semantic data model with the BI application, where necessary, to meet the reporting requirements of customers and adapt the solution to changing business needs and environment

  • Developing the solution using Microstrategy with a combination of any third party tools or customer’s proprietary applications

  • Possessing working knowledge and expertise in (a) Data Warehouse databases like Teradata, Oracle, DB2 or SQL Server; (b) working with sales and marketing data, processes, and analytical tools and applications; (c) pharmaceutical industry sales and marketing issues (preferable), and (d) designing and developing the most optimal and efficient semantic model layer for BI (e) help in logical/physical data modeling and solution design, (f) Develop crisp and user friendly reports MSTR according to the mockup designed across client, web, mobile or any other deployment options as agreed to.

  • The Consultant should also help develop and maintain data management standards and conventions, data dictionaries, data element naming standards and data dictionary metadata standards

  • Tuning and Optimizing any BI reports and user queries that have been designed and developed before

  • Create high level and low level design docs for BI solution.

  • Prepare and execute test cases for BI using appropriate test data

Qualifications and Skills:

  • 3-8 years of relevant BI Design/Development experience

  • Software engineer (BE/BTech/MTech/MS) from reputed Tier 1 or Tier 2 educational institutions

  • Experience as BI Technical Lead for a minimum of 3 years is must for candidates applying for the BI Technical Lead position

  • Strong PL/SQL and SQL analysis, development and tuning skills

  • Should have hands on experience to work on UNIX & Shell Scripting

  • Strong understanding of Logical and Physical data models as it relates to the customers Data warehouse

  • Working knowledge of Microstrategy with Teradata will be preferable

  • Strong focus and understanding of project scope with the ability to identify and work based on defined scope boundaries.

  • Experience in working to deliver assigned tasks based on agreed project plan and timelines

  • Proven analytical and problem solving skills and experience working in challenging and complex project environments

  • High level of attention to detail

  • Strong communication skills with ability to coordinate with local and overseas teams, including Project Managers and Leads

  • Strong team player with high work ethics and positive attitude