• DATA WAREHOUSE DEVELOPER / ANALYST Jobs in Delhi,India - 25090921

  • KG TIGER

Job Description:

Company Description ABOUT THE COMPANY

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 companys 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 companys IT

Responsibilities

He or She will

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

Qualifications 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

Must Have

1 Bachelors degree in Engineering with three (3) years of professional work experience, or a Masters degree in Engineering

2 Expertise with data warehouse

3 Expert-level ETL development using tools such as Informatica PowerCenter or SAP Data Services

4 Expert-level SQL coding/querying skills in SQL Server and/or MySQL

5 Experience with Business Intelligence tools such as Crystal, Business Objects, Microsoft SSRS, or Oracle OBIEE

6 Exposure to Amazon RDS and RedShift, and/or Google BigQuery

7 Experience with relational database design/modeling using tools such as ERstudio or ERwin

**Desired**

1 Exposure to dealing with unstructured or semi-structured data

2 Exposure to dealing with the challenges of large relational data sets, including load performance, query performance, archiving, etc

3 Experience with big-data technologies such as Hadoop/Hive, MongoDb, or other NoSQL-based data stores

4 Exposure to one or more of these tools MATLAB, Python, SAS, SPSS

Additional Information Interested candidates may submit resume to seans at kggroupcom (or) Call 888-738-5815 (x1375)

Im interested

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Consulting Services
Functional Area : IT Software : Software Products & Services
Role : Software Engineer
Salary : As per Industry Standards
Deadline : 12th May 2020

Key Skills:

Would you like to try out these free online tutorials?

People who search this job also searched for the following Keywords

Sourced**

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status