ERP Principal Consultant

Job Description

Who are we looking for:

Data Consultant – Data Migration

Years of experience needed : 5 years of experience on Data Analyst & ETL developer in Microsoft Business Intelligence tools.

Technical Skills:

 Must have at least 5 years of experience as Data Analyst & ETL developer in Microsoft Business Intelligence tools like SQL Management Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS Azure Data Factory, Azure Synapse Analytics, Azure Data Lake, Power BI and AWS Redshift.

 Expertise in creating visualizations and reports using Power BI.

 Expertise on creating multiple kinds of power BI Reports and Dashboards

 Experience in writing T-SQL Stored Procedures, Functions, Constraints, and Indexes using various DDL and DML commands.

 Experience in writing in complex SQL Queries using Joins, Sub Queries, Correlated Sub Queries and others.

 Involved in transformation of OLTP data to the Data Warehouse using SSIS.

 Having a good Experience in Designing and Developing the SQL Server Integration Services Packages with different Control Flow Tasks and Data Flow Transformations.

 Implementing logging, checkpoint configuration, package configurations, Performance tuning at various levels.

 Worked Extensively on ETL Process using SSIS Package.

 Good hands-on experience in Azure Data Factory.

 Scheduled Jobs in Flows and ADF Pipelines.

 Created Tabular, Matrix, Sub report, Chart, Drill-down and Drill through reports in SSRS.

 Designing reports and publishing the reports to the Power BI web.

 Team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

 Self-confident team player with fast learning curve along with strong analytical, problem solving, knowledge transfer, communication & interpersonal skills.

 Experienced in all project phases using Waterfall and Agile Methodologies.

Other Technical Skills:

1. ETL Tools : SQL Server Integration Services, Azure Data Factory.

2. Reporting Tools : SQL Server Reporting Services, Power BI, Tableau.

3. Database : SQL Server 2008R2, 2012, MySQL, AWS Redshift, Azure sql server.

4. Programming Language : C, C++, Core Java, T-SQL, pl/SQL.

Certifications:

 Microsoft Dynamics 365 certification