Description

You will design and maintain ETL pipelines and data marts using SQL Server and SSIS, ensuring reliable data transformation across diverse sources. You will troubleshoot existing BI processes, resolve issues, and collaborate with business analysts to implement system changes based on gathered requirements. Additionally, you will create support documentation, cross-train team members, and coordinate with onshore and offshore development groups to deliver projects on schedule.

Responsibilities

• Design and develop SSIS packages to load and transform data from various sources, including SQL Server databases, web services, and flat files.
• Build, support, and maintain data marts and existing database systems.
• Troubleshoot and resolve issues within existing BI processes to ensure timely resolution.
• Collaborate with business users and analysts to gather requirements for new and existing system implementations.
• Create technical documentation and cross-train development team members on implemented processes.

Required Skills

• 5+ years of experience in SQL Server Development.
• Strong proficiency in SSIS (SQL Server Integration Services) for ETL development.
• Hands-on experience designing and implementing ETL pipelines.
• Proven ability in troubleshooting complex data issues and BI processes.
• Experience working with diverse data sources, including web services and flat files.
• Ability to collaborate effectively with cross-functional and offshore/onshore teams.
• Any Graduate degree.

Preferred Skills

• Experience coordinating with offshore development teams to deliver projects on time.

Key Skills

Education

Any Graduate