L2 Application Support Engineer – Enterprise Data Warehouse (AWS) Hot

Title: L2 Application Support Engineer – Enterprise Data Warehouse (AWS)

Job Location: remote

Experience 3 -5 yearsNeed immediate joiners

Work Schedule:24x7 rotational shifts, weekend support, with on-call availability for high-priority batch or data issues.

Key Responsibilities

ETL & Data Pipeline Monitoring

• Monitor daily ETL jobs and workflows using tools like Apache Airflow, AWS Glue, or Talend.
• Handle data ingestion failures, perform initial triage and escalate to L3 or data engineering if needed.
• Maintain job runbooks, batch schedules, and alert configurations.
  
  

Incident & Problem Management

• Provide L2-level troubleshooting and resolution for data warehouse issues and outages.
• Log incidents and service requests in ITSM tools (e.g., ServiceNow, Jira).
• Perform root cause analysis (RCA) and create post-incident reports.
  
  

Data Quality & Validation

• Run and validate data quality checks (e.g., nulls, mismatches, record counts).
• Ensure integrity of data ingestion from source systems (e.g., Finacle, UPI, CRM).
• Collaborate with business analysts and QA teams to confirm expected outputs.
  
  

Cloud Operations & Automation

• Monitor AWS services (Redshift, S3, Glue, Lambda, CloudWatch, Athena) and respond to alerts.
• Automate recurring support tasks using Python, Shell scripting, or Lambda triggers.
• Work closely with cloud DevOps or engineering teams for patching, scaling, or performance tuning.
  
  

Reporting & Documentation

• Maintain support documentation, knowledge base articles, and daily handover reports.
• Assist in preparing monthly uptime/SLA reports.
• Participate in audit reviews and ensure compliance logs are retained.
  
  

Technical Skills

AWS Services: Redshift, S3, Glue, Athena, Lambda, CloudWatch

ETL Tools: AWS Glue, Apache Airflow, Talend

Scripting: Python, Shell, SQL (advanced)

Monitoring: AWS CloudWatch, Grafana, Prometheus (optional)

ITSM: ServiceNow, Jira

Database: PostgreSQL, Redshift SQL, MySQL

Security: IAM policies, data masking, audit logs

Soft Skills & Functional Knowledge

• Good understanding of data warehousing and BI principles.
• Excellent communication skills to liaise with business, operations, and L3 teams.
• Analytical thinking and a proactive problem-solving approach.
• Ability to handle high-pressure production issues in real-time.
  
  

Preferred Certifications

• AWS Certified Data Analytics – Specialty (preferred)
• AWS Certified Solutions Architect – Associate
• ITIL Foundation (for incident/change processes)