Informatica BDM, Unix, SQL(Support role)

Job description

- Primary skills:Technology->Data Management - Data Integration->Informatica,Technology->Open System->UNIX,Technology->SQL SSIS->SQL Server Informatica BDM Support Provide L2/L3 production support for Informatica BDM (Big Data Management) / DEI workflows Monitor and manage BDM jobs, sessions, and workflows Troubleshoot failures in Spark-based mappings and big data pipelines Analyze logs and resolve issues related to data processing and job execution Perform job restarts, reruns, and recovery activities Unix / Linux Support Work extensively on Unix/Linux systems for monitoring and troubleshooting Develop and maintain shell scripts for automation and batch processing Perform file handling, process monitoring, and system checks Debug job failures using Unix commands and logs SQL & Database Support Write and optimize complex SQL queries for data validation and debugging Work with databases such as Oracle, SQL Server, Teradata, or PostgreSQL Perform data analysis, reconciliation, and issue investigation Support data correction and backfill activities Big Data & Hadoop Ecosystem Support integration with Hadoop ecosystem (HDFS, Hive, Spark, YARN) Monitor cluster-level job execution and performance Troubleshoot connectivity and resource issues in big data platforms Incident & Problem Management Handle incident tickets, alerts, and production issues within SLA Perform Root Cause Analysis (RCA) and implement preventive actions Coordinate with cross-functional teams for issue resolution Ensure adherence to ITIL processes Operational Excellence Maintain job schedules using AutoSys / Control-M / Cron Ensure data quality, consistency, and availability Create and maintain runbooks, SOPs, and documentation Participate in on-call/shift support model (24/7 support) Preferred Skills Exposure to cloud platforms (AWS, Azure, GCP) Experience with AWS EMR / Databricks Basic knowledge of Python or Spark scripting Familiarity with Informatica PowerCenter or IICS Understanding of data quality and governance concepts