Con / AM - ETL ( With Data Mining / Data Extraction )

Pylon Management consulting
  • Bangalore
  • Confidential
  • 4-9 years
  • Views
  • 13 Nov 2018

  • Software Design & Development

  • Consumer Durables/ Semi Durables
Job Description

Roles and Responsibilities​

Participate in design and development of data warehouse expansion including OLTP and OLAP systems. Candidates must have exp in ETL development alongwith data mining and data extraction. 

Development and creation of data warehouses.

Assist in defining system architecture and capacity planning.

Full ETL / SSIS development

SQL Data Warehouse and downstream data models

Third party / external data integration

Data Warehouse development and integration

Full logging for proper troubleshooting

Build and support OLAP Cubes

Support and assist the BI developers with

Ad-hoc query generation using T-SQL

Assist in troubleshooting issues with reports using Power BI (or other visualization tools)

Performance Tuning and Query Optimization using native SQL Server tools

Qualifications and Skills

4- 7 years of SQL Server Experience building and supporting Data Warehouse structures

Strong SQL Server development experience

Experience building automated Extract Transform and Load (ETL) systems to process incoming data sources

Experience building ETL processes to reconcile and standardize data and eliminate redundant data

Build experience with multidimensional structures (OLAP, etc.) to support the delivery of data to reporting tools

All phases of the modeling process - research design, data extraction and cleaning, model building and validation.

Proficiency with writing stored procedures, triggers, and database jobs.

SQL Server Integration Services experience (SSIS) to load and transform data from various sources into a database staging environment.

Experience building SSIS tasks to perform bulk inserts, execute packages, execute processes, FTPs, Send mails etc.

Strong SQL Coding experience including unions, correlated sub-queries etc. to extract and transform data.

SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), OLAP cubes, Dimensions, Partitions, KPIs and aggregation.

Microsoft BI Stack including Power Query, Power Pivot and Power View.

Experience and Background


Job Posted By

Sourav Singh Digari
Staffing Specialist

About Organisation

Pylon Management consulting