drjobs Data Integration Specialist

Data Integration Specialist

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Jobs by Experience drjobs

5years

Job Location drjobs

Philadelphia, PA - USA

Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Name of position: Data Integration Specialist

Location: Philadelphia PA

Note: its hybrid position

name of client: city of philadelphia


Statement of Work

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 E LT) 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 of the assigned staff:

Required

Experience with various cloud platforms

Proficient with Azure Data Factory

Effective communication and documentation abilities

Expertise in data security and integrity measures

Excellent problemsolving 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



Employment Type

Full Time

Company Industry

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.