Informatica BDM, Unix, SQL(Support role)

Educational Requirements Service Line Responsibilities

• 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)

Additional Responsibilities

• 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

Technical and Professional Requirements

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

Preferred Skills

• Technology->Data Management - Data Integration->Informatica->Informatica - Data Explorer