Data Warehouse Developer​/Analyst

It is an $800 million Company and the leading developer of mathematical computing software. They have over 3000 employees in the world. They has over 90 products well known in the market and these are primarily used in various industries like automotive, aerospace and defense, biotech, semiconductor, etc. It is a US based company headquartered in Natick, MA. In India they have branches in Bangalore, Delhi and Pune.

ABOUT KGiSL:

KGiSL Group of Companies is a part of KG group, which is a 500 million USD premier industrial group in South India, with 70+ years of multi-vertical focus on textile, engineering, healthcare, finance, IT & ITES services, infrastructure and education. It is a CMM Level-4 company.

The Data Warehouse Developer-Analyst will be supporting a new area of analysis involving User Experience data with our products. Through the new Marts supporting analysis of this data, the incumbent would be responsible for making important contributions to the company’s product features and refinement. This role performs the complete Mart lifecycle, including data profiling, design and development, debugging/testing, and support and enhancements, and will work closely with our Product Development team and with the rest of the Data Warehouse team within the company’s IT.

• Profile and understand the large amounts of source data available, including structured and semi-structured/web activity data.
• Work with data originators to fill in gaps in the data collected, and/or to adjust source-system data structures to facilitate analysis and integration with other company data.
• Gather reporting and analysis requirements and translate into reporting structures data models, including aggregate tables, pivoted tables, and relational and dimensional (star-schema) marts.
• Use data mining techniques to analyze the source data and determine the best reporting structures to build.
• Map sources to the target design using a variety of tools, including Business Objects Data Services/BODI. Design and develop ETL code to load and transform the source data from various formats (including key-value pair and variable-structure data) into a SQL database.
• Conduct ETL performance tuning, troubleshooting, support, and capacity estimation.
• Conduct thorough testing of ETL code changes to ensure quality of data produced.
• Provide day-to-day support and mentoring to end users who are interacting with the data.

The incumbent should possess excellent verbal and written communication along with the ability to work in a fast-paced, flexible environment, and take the initiative to learn new tools quickly.

Interested candidates may submit resume to sean.s at (or) call (x1375).