StaidLogic - AWS Solution Architect

Role : AWS Solution Architect.

Location : Pan India.

Experience : 7-9 Years.

Role Description :

This is a contract role for an AWS Solution Architect with 8 years of experience.

The position is located on-site in Pan India.

The AWS Solution Architect will manage solution architecture, provide consulting services, oversee software development, integration, and business processes.

Day-to-day tasks will include designing, developing, and implementing scalable and reliable AWS cloud solutions in accordance with best practices, as well as collaborating with cross-functional teams to meet project objectives and customer needs.

Technical Skills :

Relational Databases :

- Proficiency in working with relational databases, particularly PostgreSQL, Microsoft SQL Server, Oracle.

- Experience in database schema design, optimization, and management.

AWS Services :

- Strong knowledge of AWS services, including S3, AWS DMS (Database Migration Service), and AWS Redshift Server less.

- Experience in setting up and managing data pipelines using AWS DMS.

- Proficiency in creating and managing data storage solutions using AWS S3.

Data Integration :

- Expertise in data integration techniques and tools.

- Experience in designing and implementing ETL (Extract, Transform, Load) processes.

- Ability to perform data mapping, transformation, and data cleansing activities.

Data Warehousing :

- Experience in setting up and managing data warehouses, particularly AWS Redshift Serverless.

- Proficiency in creating and managing views in AWS Redshift.

Scripting and Automation :

- Proficiency in scripting languages such as Python or SQL for automating data integration tasks.

- Experience with automation tools and frameworks.

Analytical and Problem-Solving Skills

Data Analysis :

- Ability to analyze and interpret complex data sets.

- Experience in identifying and resolving data integration issues, such as inconsistencies or discrepancies.

Troubleshooting :

- Strong problem-solving skills to troubleshoot and resolve data integration and migration issues.

Soft Skills :

Collaboration :

- Ability to work collaboratively with database administrators, and other stakeholders to ensure integration solutions meet business requirements.

Communication :

- 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.

Adaptability :

- Willingness to stay updated with the latest data integration tools and technologies and recommend upgrades when necessary.

Security and Compliance :

Data Security :

- Knowledge of data security and privacy regulations.

- Experience in ensuring adherence to data security and privacy standards during data integration processes.

Additional Requirements :

Experience :

- Proven experience in similar data integration projects.

- Familiarity with the specific requirements and challenges of integrating production relational databases with AWS services.

Certifications :

- AWS certifications such as AWS Certified Solutions Architect or AWS Certified Database Specialty are a plus.

Qualifications

- Experience in Solution Architecture and Consulting.

- Proficiency in Software Development and Integration.

- Knowledge of Business Process optimization and automation.

- AWS Certification or equivalent experience is preferred.