Required Skills & ExperienceTechnical Skills (Mandatory)Strong hands-on experience with AWS Redshift in production environmentsProficiency in Python for data processing, automation, and support scriptsSolid experience with Apache Airflow for workflow orchestration and supportAdvanced SQL skills for troubleshooting, performance tuning, and data analysisExperience supporting large-scale data pipelines and data warehouse platformsSnowflake is preferredAWS services: S3, CloudWatch, RedshiftMonitoring and ing tools (cloud-native or third-party)Version control systems (Git-based)Familiarity with CI/CD pipelines for data workloadsSupport & Process KnowledgeExperience working in Application Support & MaintenanceStrong understanding of ITIL processes (Incident, Problem, Change)Experience handling on-call support, P1/P2 incidents, and production escalationsAbility to work in shift-based or extended support coverage modelsKey ResponsibilitiesApplication Support & OperationsProvide L2/L3 production support for data platforms including AWS Redshift, Snowflake, and related ETL pipelinesMonitor and troubleshoot data pipeline failures, job delays, data quality issues, and performance bottlenecksPerform root cause analysis (RCA) for recurring incidents and implement preventive measuresSupport incident, problem, and change management processes aligned with ITIL standardsEnsure adherence to defined SLAs/SLOs for data availability, performance, and reporting timelinesData Pipeline & Workflow ManagementSupport and maintain Apache Airflow DAGs for scheduling, orchestration, and dependency managementOptimize existing workflows for reliability, scalability, and cost efficiencyHandle pipeline restarts, backfills, reruns, and recovery activitiesImplement ing and monitoring for data pipelines and warehouse workloadsData Engineering & Platform MaintenanceDevelop and maintain ETL processes using Python and SQLSupport data ingestion from multiple sources (applications, APIs, files, event streams)Manage schema changes, data model updates, and impact analysisPerform Redshift and Snowflake performance tuning, including query optimization and workload managementParticipate in deployment activities across dev, QA, and production environmentsDocumentation & Continuous ImprovementMaintain runbooks, SOPs, and operational documentationIdentify automation opportunities to reduce manual effort and recurring incidentsSupport audits, compliance checks, and data governance requirementsCollaborate with development, QA, DevOps, and business stakeholdersSkillsEqual opportunity Employer:Mphasis is an equal opportunity/affirmative action employer. We provide equal employment opportunities to applicants and existing associates and evaluate qualified candidates without regard to race, gender, national origin, ancestry, age, color, religious creed, marital status, genetic information, sexual orientation, gender identity, gender expression, sex (including pregnancy, breast feeding and related medical conditions), mental or physical disability, medical conditions military and veteran status or any other status or condition protected by applicable federal, state, or local laws, governmental regulations and executive orders.VEVRAA Federal Contractor.We request Priority Protected Veteran & Disabled Referrals for all of our locations within the state.PDN-a181cb54-1733-4fbd-a4d8-a19a46b8af1e
