- 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
Technical Requirements:
- Primary skills Technology Data Management Data Integration Informatica Technology Open System UNIX Technology SQL SSIS SQL Server
Additional Responsibilities:
- 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
Preferred Skills:
Technology->Data Management - Data Integration->Informatica->Informatica - Data Explorer,Technology->Open System->UNIX,Technology->SQL SSIS->SQL Server