Informatica BDM, Unix, SQL(Support role)

Infosys; Hyderabad; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Infosys is seeking a candidate for Data Analytics support roles in Hyderabad, India. The role involves providing L2/L3 support for Informatica BDM workflows, managing SQL databases, and minimizing production incidents.

Ideal applicants must have a strong background in UNIX, SQL, and the Hadoop ecosystem. Responsibilities also include developing automation scripts and maintaining operational excellence in data management processes.

Qualifications

• Bachelor's degree in Engineering or Science.
• Experience in Informatica BDM and production support.
• Proficiency in SQL and debugging techniques.

Responsibilities

• Provide L2/L3 support for Informatica BDM workflows.
• Develop and maintain shell scripts on Unix/Linux.
• Monitor cluster-level job execution in Hadoop.

Skills

Informatica BDM Support

Unix/Linux Systems

SQL Queries

Hadoop Ecosystem

Incident Management

Operational Excellence

Education

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

Tools

AWS

Azure

PostgreSQL

Teradata

Job description

Educational Requirements

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

Service Line

Data Analytics Unit

Responsibilities

• Informatica BDM Support: Provide L2/L3 production support for Informatica BDM/DEI workflows, monitor and manage BDM jobs, sessions, and workflows, troubleshoot failures in Spark-based mappings and big data pipelines, analyze logs, perform job restarts, reruns, and recovery activities.
• Unix/Linux Support: Work extensively on Unix/Linux systems, develop and maintain shell scripts for automation, perform file handling, process monitoring, 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, 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

• Data Management - Data Integration: Informatica.
• Open System: UNIX.
• SQL SSIS: SQL Server.

Preferred Skills

• Data Management - Data Integration: Informatica, Informatica - Data Explorer.
• Open System: UNIX.
• SQL SSIS: SQL Server.