KGS:MC: ETL Developer
KPMG
India
1d ago

KGS : MC : ETL Developer

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

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form