SOLUTION ARCHITECT L1

Job Description

Exp -6-12

Mandatory Skills:

• Excellent understanding and design experience of Big Data platform, Data Lake, Lakehouse architecture, Medallion architecture and modern data architecture.

• Excellent in SQL/PL-SQL scripting in columnar database

• Excellent Data Modelling experience

• Strong skills in Redshift, SQL, PL-SQL, Glue, PySpark, Spark, S3, Shell scripting

• Strong skills in Airflow, Kinesis, Step function and related ETL-DW data services

• Develop, enhance & optimize data pipelines using AWS service, custom ETL tools and automating data pipelines.

• Experience in code deployment in various environments

• Designing job scheduling, optimizing airflow job orchestration, designing batch/stream monitoring in systems, usage tracking etc.

• Excellent implementation skills in AWS tech stack, ETL & ELT, DW BI, EMR, S3, SQS, Step function, Lambda, Scala.

͏

Area of Responsibility

Requirement Analysis-Participate in requirement discussions with client stakeholders to define solution and implementation level needs basis the business requirements.

Designing-Create solution architecture designs to meet cross-system interactions and business logic integration requirements, ensuring system cohesion across multiple applications.

Integration assessment and support-Assess and evaluate interactions across multiple applications by evaluating implementation dependencies and integration requirements.

Troubleshooting-Support validation of solution components during implementation and ensures the solution functions as designed.

Risk Analysis and Assessment-Assist in identifying potential risks by evaluating system performance of implemented architectural solutions, to ensure efficient system landscape.

͏

͏

͏