User

Data Engineer

BMT Score
75
75%
  • Hybrid

Available for

About RAMYA K

  • Overall 7+ years of professional software development experience in the areas of Microsoft Business Intelligence (MSBI) and Having Knowledge in Data Warehousing (DW) applications primarily using Microsoft SQL Server.
  • 6+ years of experience in Power BI reporting which includes DAX and Data Models.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Experience in building SSIS Packages and ADF Pipelines and scheduling them.
  • Part of Project Automation & Data Architecture teams with Knowledge on multiple technologies and strategies used to Extract and Export the data.  
  • Experience connecting to and extracting data from multiple data sources like Azure Data Lake Store, SSAS, Azure SQL DB, SharePoint and PowerApps.
  • Experienced in using Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
  • Having a good Experience in Designing and Developing the SQL Server Integration Services - SSIS Packages with different Control Flow Tasks and Data Flow Transformations, Securing Packages and Deploying the Packages.
  • Experience with Azure Data Lake, Azure Data Factory, SQL Data Warehouse Azure Blob, Azure Storage Explorer.
  • Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for on-cloud ETL Processing.
  • Experienced in Data Warehouse concepts. Having knowledge on SQL Server Analysis Services – SSAS and Azure Analysis Services - AAS.
  • Equal competence Integration Services, Reporting Services and Analysis Services.
  • Hands on experience in Extract, Transform & Load (ETL) development using SQL Server Integration Services (SSIS).
  • Experience working with SSIS Catalog Database and Data Mapping Environments.
  • Experience in scheduling and deploying reports on Report Manager.
  • Knowledge on Data Warehouse concepts like Star Schema, Snowflake, Dimension and Fact Tables.
  • Highly motivated, quick learner and extremely versatile. Accepts responsibilities and job duties eagerly with minimal supervision required.
  • Implementing and maintaining existing Reports and Dashboards.
  • Good knowledge on Subqueries, Joins, Views, and Sub Queries.
  • Hands of experience in creating Jobs, Alerts and Scheduled SSIS Packages from SSIS Catalog Database.
  • Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance) using Waterfall and Agile methodologies.

Our Suggestions