KGS:MC: ETL Developer

Job description

Roles and Responsibilities
• Participate in design and development of data warehouse expansion including OLTP and OLAP systems.
• 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, KPI's and aggregation
• Microsoft BI Stack including Power Query, Power Pivot and Power View.

Experience and Background

B.Tech/MCA