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

3 - 5 years

0 Lacs

Posted:2 weeks ago| Platform: Linkedin logo

Apply

Work Mode

Remote

Job Type

Full Time

Job Description

Title: L2 Application Support Engineer – Enterprise Data Warehouse (AWS)Job Location: remoteExperience 3 -5 yearsNeed immediate joinersWork 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, CloudWatchETL Tools: AWS Glue, Apache Airflow, TalendScripting: Python, Shell, SQL (advanced)Monitoring: AWS CloudWatch, Grafana, Prometheus (optional)ITSM: ServiceNow, JiraDatabase: PostgreSQL, Redshift SQL, MySQLSecurity: 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)

Mock Interview

Practice Video Interview with JobPe AI

Start Python Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Python Skills

Practice Python coding challenges to boost your skills

Start Practicing Python Now

RecommendedJobs for You