Summary: We are seeking an experienced Data Integration Specialist for a temporary assignment to manage data migration and integration within Amazon S3 and Redshift environments. The role involves ensuring data integrity and security throughout the migration process, along with setting up automated workflows. Candidates should have at least 3 years of experience in data integration, with expertise in AWS, Azure Data Factory, and ETL tools.
Position Info
- Title: Data Integration Specialist
- Client: Office of Innovation & Technology
- Duration: 6 Months
- Location: 2 International Plaza, Suite 2000, Philadelphia, PA 19113
- Work Mode: Hybrid
Responsibilities
- Design and implement data pipelines using Azure Data Factory for ETL/ELT processes into Amazon S3.
- Set up and configure Amazon S3 buckets and Redshift schemas and tables for data storage.
- Automate workflows for continuous data migration and monitor pipeline performance.
- Ensure data integrity and security during migration processes.
- Perform regular maintenance to improve data integration processes.
- Document data integration procedures and ensure process scalability.
Skills/Qualifications
- Experience with cloud platforms, particularly AWS S3, Redshift, and Lambda.
- Proficient in Azure Data Factory, SQL, and ETL tools.
- Expertise in data security and integrity measures.
- Strong problem-solving and analytical skills with excellent communication abilities
Preferred: Experience with AWS Glue, Python, C#, and sparkSQL.
About Ohm Systems, Inc
Ohm Systems, Inc. specializes in IT and Healthcare staffing services, dedicated to linking highly skilled professionals with our public and private clients across the United States. Our track record showcases our commitment to delivering outstanding staffing and consultancy solutions to our clients. We prioritize diversity and inclusivity and take pride in being an employer that promotes equal opportunities and affirmative action. Our goal is to foster an inclusive work environment that embraces individuals from all backgrounds, irrespective of their gender, race, or orientation.