Description

Responsibilities

  • Create data load mappings, import/export methods, Incremental /Full load data from Source systems to various targets.
  • Setup up the SSIS package encryption for security purpose.
  • Automate data extractions, loads and consolidations (when applicable) using batches or PowerShell scripts.
  • Understand End-To-End data flow between various data sources and SSIS packages.

Required Skills

  • Advanced level of working knowledge in SQL installation, Administering and Configuration of SSIS packages.
  • Strong understanding on Star schema and Snowflake schema modelling, SCD types in the data warehousing projects under SSIS.
  • Exposure to Azure & ETL Concepts would be nice to have.
  • Expert PL/SQL development skills including query optimization, stored procedures and views.
  • Strong knowledge of data manipulation using stored procedures.
  • Strong UNIX (KSH) Scripting knowledge.

Required Experience

  • Programming language experience with SQL, SSIS expressions, C# or VB.net, PowerShell and VBA.
  • Strong ETL design/Framework experience is required.

Education Requirements

  • Bachelor’s Degree in Computer Science, Computer Engineering or a closely related field.


 

Key Skills
Education

Any Graduate

Back To Jobs