Bi Dwh Etl Developer (ssis) Job in Spaatech Solutions

Location: USA (All and Chicago), India (Metro Cities, Kolkata, and Bhubaneswar)

Job Description:

• At least 6- 8 Years of experience in Database technologies, with very good understanding of Data Warehousing concepts, Business Analysis, Data Warehouse Architecture and Designing.
• At least 4 years of hands-on development/maintenance experience with Azure Data Factory
• High proficiency writing SQL; Must be able to read and write, and optimize SQL
• Experienced in developing reports using PowerBI, Birst, and tableau.
• Having good Knowledge on SSAS.
• Expert in UNIX and/or PowerShell Scripting to support complex business requirements.
• Extensive knowledge in varied domains such as CRM/ERP, Payment Systems, Health care etc.
• Experienced Data Reporting Analyst with strong background in design and development of analytical data models and information products as well as data analysis/reporting/ processing.
• Experience in creating dashboard reports and data sets using features such as DAX, drilldowns, radio buttons etc.
• Good understanding of RDBMS concepts and experience in writing Queries, Joins, Subqueries, XML queries, Indexes, Views, Stored procedures, Functions, Creating Jobs and Triggers using SQL Server/MySQL/Oracle.
• Experience in developing strategies for Extraction, Transformation and Loading Mechanisms using MS Azure Data Factory and SSIS by integrating of various Data Sources like MS Excel, Flat Files, and OLEDB Sources into the Staging Area.
• Experience in Performance Tuning and Process Optimization.
• Good knowledge of Microsoft Dynamics CRM and SFDC.
• Having good knowledge in No-SQL databases such as MongoDB.