Description

You will design, develop, and deploy ETL programs to manage data flow from various sources into destination tables within the data architecture framework.

Responsibilities

• Design and develop complex ETL packages using full and incremental load strategies.
• Build ETL design frameworks and implement security through SSIS package encryption.
• Gather business and functional requirements to align technical solutions with evolving needs.
• Troubleshoot package debugging, performance, configuration, and migration issues.
• Optimize SQL queries and provide tuning recommendations for time and CPU-intensive jobs.

Required Skills

• 7-8 years of experience in SSIS development.
• 3-5 years of experience with Oracle, MS SQL Server, and SSRS.
• Proficiency in SQL, SSIS expressions, C#, VB.net, PowerShell, and VBA.
• Experience with SQL Server, Azure SQL, and Azure Synapse.
• Strong understanding of Star schema, Snowflake schema modeling, and SCD types.
• Ability to manage end-to-end data flow and MS SSIS architecture best practices.
• Experience tuning SSIS load performance and automating via PowerShell scripts.
• Bachelor’s Degree in Computer Science, Computer Engineering, or a closely related field.

Key Skills

Education

Any Graduate