Data Integration Specialist

HTC Global Services wants you. Come build new things with us and advance your career. At HTC Global you'll collaborate with experts. You'll join successful teams contributing to our clients' success. You'll work side by side with our clients and have long-term opportunities to advance your career with the latest emerging technologies.

At HTC Global Services our consultants have access to a comprehensive benefits package. Benefits can include Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short & Long Term Disability Insurance, and a variety of other perks.

Job Description:

Aims to modernize its data infrastructure by mapping all existing systems and migrating the data to a centralized data lake on Amazon S3 and Redshift. This project will involve a Data Analyst to gather, review, clean, and preprocess data, and a Data Integration Specialist to create and maintain the data pipelines for smooth data migration.

Position overview:

• We are seeking a skilled and experienced Data Integration Specialist for a temporary assignment to join our dynamic team.
• This position will be responsible for the migration, integration, and maintenance of data within Amazon S3 and Amazon Redshift environments.
• This position will also be responsible for ensuring data integrity and security throughout the entire process, from initial migration to continuous data operations.
• This position requires 3 or more years of experience working as a Data Integration Specialist.

Work activities:

• Design and implement data pipelines to extract, transform and load data (ETL and/or ELT) data into Amazon S3 using Azure Data Factory and other tools.
• Set up automated workflows to ensure continuous data migration.
• Configure Amazon S3 buckets for data storage.
• Set up data schemas and tables in Amazon Redshift.
• Migrate cleaned and preprocessed data into Amazon S3 and Redshift.
• Ensure data integrity and security during migration.
• Monitor data pipelines for performance and reliability.
• Perform regular maintenance to address any issues.
• Improve data integration processes for increased efficiency and scalability.
• Document data integration processes and procedures.

Skills/Experience Required:

• Experience with various cloud platforms.
• Proficient with Azure Data Factory.
• Strong knowledge of Amazon AWS S3, AWS Redshift and AWS Lambda.
• Proficient in SQL and ETL tools.
• Effective communication and documentation abilities.
• Expertise in data security and integrity measures.
• Excellent problem-solving and analytical skills.
• 3 years of experience creating, documenting, implementing, and maintaining data pipelines.

Highly Desired/Preferred:

• Experience using AWS Glue.
• Proficient with Python, C# and sparkSQL.

Education:

• Bachelor's degree or equivalent practical experience.

At HTC Global Services our associates have access to a comprehensive benefits package that includes Health, Dental, Vision, Paid-Time-Off, Paid Holidays, 401K matching, Life and Accidental Death Insurance, Short- & Long-Term Disability Insurance, and a variety of other offerings.

Diversity & Inclusion:
Our success as a company is built on practicing inclusion and embracing diversity. HTC Global Services is committed to providing a work environment free from discrimination and harassment, where all employees are treated with respect and dignity. Together we work to create and maintain an environment where everyone feels valued, included, and respected. At HTC Global Services, our differences are embraced and celebrated. HTC is an Equal Opportunity Employer. We respect and seek to empower each individual and support the diverse cultures, perspectives, skills, and experiences within our workforce. HTC is proud to be recognized as a National Minority Supplier.