Job Summary
Strong knowledge of AWS services including S3 AWS DMS (Database Migration Service) and AWS Redshift Serverless.
Experience in setting up and managing data pipelines using AWS DMS.
Proficiency in creating and managing data storage solutions using AWS S3.
Proficiency in working with relational databases particularly PostgreSQL Microsoft SQL Server Oracle
Experience in setting up and managing data warehouses particularly AWS Redshift Serverless.
Responsibilities
Analytical and Problem-Solving Skills
Ability to analyze and interpret complex data sets.
Experience in identifying and resolving data integration issues such as inconsistencies or discrepancies.
Strong problem-solving skills to troubleshoot and resolve data integration and migration issues.
Soft Skills
Ability to work collaboratively with database administrators and other stakeholders to ensure integration solutions meet business requirements.
Strong communication skills to document data integration processes including data source definitions data flow diagrams and system interactions.
Ability to participate in design reviews and provide input on data integration plans.
Willingness to stay updated with the latest data integration tools and technologies and recommend upgrades when necessary.
Security and Compliance
Knowledge of data security and privacy regulations.
Experience in ensuring adherence to data security and privacy standards during data integration processes.
Certifications Required
AWS certifications such as AWS Certified Solutions Architect or AWS Certified Database - Specialty are a plus