Informatica BDM, Unix, SQL(Support role)

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 Auto Sys / 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)

• Primary skills:Technology->Data Management
• Data Integration->Informatica,Technology->Open System->UNIX,Technology->SQL SSIS->SQL Server

Preferred Skills:

Exposure to cloud platforms (AWS, Azure, GCP)

Experience with AWS EMR / Databricks:

Basic knowledge of Python or Spark scripting:

Familiarity with Informatica Power Center or IICS:

Understanding of data quality and governance concepts

Education: MCA,MSc,MTech,Bachelor of Engineering,BCA,BSc,BTech

• Preferred skills: Technology->Data Management
• Data Integration->Informatica->Informatica
• Data Explorer,Technology->Open System->UNIX,Technology->SQL SSIS->SQL Server