What are the responsibilities and job description for the Junior Data Integration Specialist position at Sonitalent Corp?
Job Title – Junior Data Integration Specialist
Job Location - PA - Onsite from day one
Duration - 6 Months
Visa -Any Visa except H1B,cpt
Mode Of Interview - Phone/Skype
Note - Need LinkedIn
Job Description –
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
Required
Skills/experience of the assigned staff:
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
Job Location - PA - Onsite from day one
Duration - 6 Months
Visa -Any Visa except H1B,cpt
Mode Of Interview - Phone/Skype
Note - Need LinkedIn
Job Description –
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
Required
Skills/experience of the assigned staff:
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
