Job Description

Who are we looking for:
Data Consultant - Data Migration
Years of experience needed : 5 to 8 Years
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
About ***
*** applies next-generation technology to help enterprises transform businesses globally. Customer centricity is foundational to *** and is reflected in the ***' Front2BackTM Transformation approach. Front2BackTM uses the exponential power of cloud and cognitive to provide hyper-personalized (C=X2C2TM=1) digital experience to clients and their end customers. ***' Service Transformation approach helps 'shrink the core' through the application of digital technologies across legacy environments within an enterprise, enabling businesses to stay ahead in a changing world. ***' core reference architectures and tools, speed and innovation with domain expertise and specialization are key to building strong relationships with marquee clients.
Skills:
PRIMARY COMPETENCY : CRM PRIMARY SKILL : Dynamics 365 Data Migration PRIMARY SKILL PERCENTAGE : 80 SECONDARY COMPETENCY : Analytics SECONDARY SKILL : Power BI SECONDARY SKILL PERCENTAGE : 10 TERTIARY COMPETENCY : Reporting/BI TERTIARY SKILL : Report Development (Microsoft SSRS) TERTIARY SKILL PERCENTAGE : 10