Description

You will design and implement end-to-end ETL solutions using the Microsoft stack in Philadelphia, Pennsylvania.

Responsibilities

• Design and build ETL solutions to handle XML (via XSLT), CSV, TXT, web services, and database sources.
• Support existing SSIS ETL processes, fine-tuning code to improve error monitoring and stability.
• Develop conceptual, logical, and physical data models for OLAP and OLTP systems.
• Perform data analysis, cleansing, transformation, and migration using ETL tools.
• Write complex T-SQL queries and stored procedures to manage data workflows.

Required Skills

• 6-8 years of experience designing ETL solutions with SSIS.
• Expertise in T-SQL, including writing complex queries and stored procedures.
• Strong proficiency in SQL and data modeling.
• Hands-on experience with XML and XSLT.
• Deep understanding of Data Warehouse and Data Mart concepts.
• Proven ability in data analysis and troubleshooting.
• Experience with large-scale database design techniques.
• 10+ years of total professional experience.
• Bachelor's degree or equivalent graduate qualification.

Preferred Skills

• Experience working within the Healthcare domain.

Key Skills

Education

Any Graduate