Description

You will build and manage end-to-end data integration workflows using SSIS.

Responsibilities

• Create data load mappings and import/export methods for incremental and full loads from source systems to various targets.
• Configure SSIS package encryption to ensure data security.
• Automate data extractions, loads, and consolidations using batches or PowerShell scripts.
• Manage end-to-end data flows between diverse data sources and SSIS packages.

Required Skills

• 5+ years of experience in ETL design and framework development.
• Advanced knowledge of SQL installation, administration, and SSIS package configuration.
• Expert PL/SQL development skills, including query optimization, stored procedures, and views.
• Strong understanding of Star schema, Snowflake schema modeling, and SCD types.
• Proficiency in SQL, SSIS expressions, C#, VB.net, PowerShell, and VBA.
• Strong UNIX (KSH) scripting knowledge.
• Experience with data manipulation using stored procedures.
• Bachelor’s Degree in Computer Science, Computer Engineering, or a closely related field.

Preferred Skills

• Exposure to Azure and general ETL concepts.

Key Skills

Education

Any Graduate