Holiday Inn Club

At Holiday Inn Club Vacations, we believe in strengthening families. And we look for people who exhibit the courage, caring and creativity to help us become the most loved brand in family travel.

Were committed to growing our people, memberships, resorts, and guest love. Thats why we need individuals who are passionate in life and bring those qualities to work every day.

Do you instill confidence, trust, and respect in those around you? Do you encourage success and build relationships? If so, were looking for DESCRIPTION :

HICV is seeking to hire a skilled SSIS Developer with ADF knowledge serve as a data developer on enterprise data projects related to ETL development, production support, data triage, SQL development, or other related data DUTIES AND TASKS :

1. Architect, design and develop data warehouse integrations using SSIS (Integration Services), Azure Data Factory (ADF), and other integration technologies. Create and maintain database objects by developing well-documented stored procedures and processes that deliver high quality and high-performing data solutions.

2. Collaborate with business partners to understand needs for enterprise reporting and analytics solutions. Document business requirements and convert into technical requirements for the development team. Partner with business stakeholders throughout the development and testing processes to ensure that the solutions meet their needs, code review all solutions before implementation.

3. Design processes and solutions that ensure minimal downtime and high performance of all solutions in the data warehouse platforms.

4. Conduct proofs of concepts, story spikes and other analysis designed to improve the overall health of the SSIS packages and improve usability by our business partners. Evaluate alternate technologies that improve value of the reporting and analysis ecosystem.

This job description in no way states or implies that these are the only duties to be performed by the employee in this position. It is not intended to give all details or a step-by-step account of the way each procedure or task is performed. The candidate is expected to perform other duties necessary for the effective operation of the RESPONSIBILITIES

- and/or EXPERIENCE

- Bachelors degree in computer science, Computer Engineering or related field required. Equivalent
professional experience will be accepted in lieu of degree.

- Experience with Microsoft data technologies: Azure Data Lake, SQL Server, Azure Data Factory, Power
BI, SSIS

- 5+ years of hands-on experience with Microsoft SQL databases, SSIS, and ADF.

- Proven experience in End-to-End ETL Automation Processes using SSIS and ADF.

- Proficiency in SQL coding, performance optimization, and query tuning.

- In-depth understanding of ETL strategy, best practices, and SSIS package development.

- Experience with Microsoft SSIS for package creation, deployment, and automation.

- Familiarity with cloud services, particularly Microsoft Azure.

- Proficient in writing and troubleshooting T-SQL statements, stored procedures, views, LICENSES, REGISTRATIONS :

- SKILLSET QUALIFICATIONS :

- Capacity to work with large amounts of data, extract relevant information and draw logical conclusions.

- Advanced skills in the design, build, and review of SQL code, T-SQL scripts, stored procedures, SSIS
and ADF pipelines for various reporting and data development projects.

- Exhibits excellent communication skills to bridge the gap between technology and business leaders.

- Proven ability to translate complex data concepts into simple and easier terms in order to foster

collaborative and effective working relationships.

- Uses advanced database knowledge to proactively resolve ETL (SSIS/ADF) defects in order to maintain
fully functioning application software.

- Develops and reviews complex Azure Data Factory pipelines for various reporting and data Utilizes senior knowledge of data warehousing and data modeling methodologies, tools and best
practices and makes recommendations to advance data management landscape to be cutting edge.

- Advanced skills in the development, implementation, and maintenance of data warehouse to extract,
transform, and load data with security as a critical design requirement.

- Strong verbal and written communications skills to effectively share findings with stakeholders and IT
associates.

- Candidate must have an open mind when it comes to approaching and be able to assess each situation separately