Project Role : Integration Engineer
Project Role Description : Provide consultative Business and System Integration services to help clients implement effective solutions. Understand and translate customer needs into business and technology solutions. Drive discussions and consult on transformation, the customer journey, functional/application designs and ensure technology and business solutions represent business requirements.
Must have skills : Snowflake Data Warehouse
Good to have skills : Amazon Web Services (AWS)
Minimum 7.5 Year(s) Of Experience Is Required
Educational Qualification : 15 years full time education
Skills Must Haves:
- Snowflake (Dataware house query optimization, pipeline monitoring)
- Airflow, DBT
- Python
- AWS Services
- T-SQL, Snow-SQL Nice To Have(s): Job Responsibilities:
- Monitor data pipelines, workflows and applications across snowflake, Airflow, DBT.
- Triage incidents, perform impact assessment and drive rapid mitigation
- Diagnose app issues via logs, metrics and traces, Debug SQL queries, stored procedures, pipelines to resolve errors in data processing.
- Perform health checks, validations and reconciliations of data sets for accuracy and completeness.
- Executes the remediations following the SOPs, runbooks, knowledge base articles etc.
- Proficiency in Python for scripting and debugging workflows.
- Experience in AWS services such as S3, EC2, Lambda, CloudWatch etc.
- Good knowledge of Airflow (DAG monitoring, failure troubleshooting).
- Familiarly with capital markets industry domain
- Participate in DR activities and testing.
