Description

Design, develop, and test ETL processes to ensure data integrity and conformity across the enterprise.

This role is on-site.

Responsibilities

• Design, develop, and test extraction, transformation, and load workflows.
• Map source data to data warehouse models and document data lineage.
• Develop and maintain ETL scripts, SQL queries, and VB/C++ components.
• Identify data quality issues and provide resolution recommendations.
• Perform performance tuning on queries, stored procedures, and ETL jobs.

Required Skills

• 4+ years of experience in Microsoft SSIS, SSRS, and database development.
• Expertise in creating SQL, stored procedures, triggers, and SQL Server Agent jobs.
• Proficiency in SQL queries and ETL script development.
• Experience with VB/C++ script components.
• Strong knowledge of logical and physical database design for data warehousing.
• Deep understanding of ETL concepts and technologies.
• Experience using VSS for version control.
• Ability to map import/export files to source system data.

Preferred Skills

• Experience working with transactional systems and enterprise data warehouse models.

Key Skills

Education

Any Graduate