Consultant- Etl (ssis) Job in Spaatech Solutions

Location: Chicago (USA) & Kolkata (India)

Job Description:

• 6- 8 Years of experience in Database technologies, with very good understanding of Data Warehousing concepts, Business Analysis, Data Warehouse Architecture and Designing.

• 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 online production databases and information products as well as data analysis/reporting/ processing.
• Experience in Data Modeling techniques employing Data warehousing concepts like star/snowflake schema and Extended Star
• Experience in creating dashboard reports using features such as drill-downs, radio buttons etc.
• Expert in UNIX (Shell Scripting) code development to support complex business requirements.
• Knowledge in scheduling UNIX jobs through CRON scheduler.
• 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 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.
• Experienced in developing reports using SSRS and tableau.
• Having good Knowledge on SSAS.
• Good knowledge of Microsoft Dynamics CRM and SFDC.
• Having good knowledge in No-SQL and experienced in MongoDB.

Responsibilities:

• Work estimation, task distribution and resource management.
• Design and develop Data migration framework to load data to SFDC from CRM using Cozyroc, Kingsway, SSIS and Data Loader. Design and developing ETL for Data Migration.
• Designed packages in SSIS Designer using Control Flow Tasks and Data Flow Transformations to implement Business Rules.
• Responsible for designing auditing the ETL to get the details of records failed to load with proper explanation.

Environment:

• SQL Server 2014 and 2012, SSIS, Kingsway soft, Cozyroc and SFDC

Technical Skills:

• Database : MS SQL Server 2000, 2005, 2008, 2012 and 2016, MySQL, oracle
• ETL Tools: SSIS and Pentaho
• Reporting Tools: SSRS, QlikView, PowerBI and tableau
• ERP(Functional): MS-CRM, Salesforce, Oracle Right Now
• DW Tools: SSAS
• Data Manage Tools: SSMS, Toad, MySQL Workbench
• OS/Environment: Windows 2003/XP/7, UNIX
• UNIX: shell scripting