EDL App Support, BDM, Informatica Support

Job Overview:

• We are seeking a skilled EDL Application Support Engineer to deliver production assistance for Enterprise Data Lake applications, specifically focusing on Informatica workflows and Hadoop-based data pipelines.
• The successful candidate will possess practical experience with Informatica BDM, Hadoop, HDFS, Hive, SQL, and UNIX/Linux systems, along with robust troubleshooting and incident management skills.
• This role will require monitoring production jobs, resolving application and data-related issues, conducting root cause analysis, supporting software releases, and ensuring that essential data processing workflows function within established service level agreements.

Main Responsibilities:

• Provide Level 2 and Level 3 production support for Enterprise Data Lake applications, Informatica workflows, and Big Data pipelines.
• Oversee batch jobs, ETL workflows, and data loading processes, addressing any failures within specified SLA timelines.
• Troubleshoot issues related to Informatica mappings, sessions, parameter sets, workflows, and associated applications.
• Monitor and support components of the Hadoop ecosystem, including HDFS, Hive, and related data processing tasks.
• Examine application logs, system alerts, and job dependencies to pinpoint the root causes of production failures.
• Conduct SQL-based data validation, reconciliation, and troubleshooting to address data quality concerns.
• Resolve Hive query performance issues and address any data processing challenges.
• Utilize UNIX/Linux commands and shell scripts for job monitoring, recovery, log analysis, and support automation.
• Perform root cause analyses for recurring incidents and work with development and infrastructure teams to implement permanent solutions.
• Manage incidents, service requests, problems, and changes in line with ITIL processes.
• Assist with production releases, validation of deployments, rollback checks, and post-production monitoring.
• Collaborate with application development, database, infrastructure, and business teams for effective issue resolution.
• Maintain incident reports, root cause analysis documents, standard operating procedures, knowledge articles, and operational support documentation.
• Provide timely status updates to stakeholders and participate in shift-based or on-call support as needed.
• These duties are aligned with internal Informatica application support job descriptions, emphasizing monitoring workflows, incident resolution, root cause analysis, ETL debugging, release support, and cross-team coordination.

Technical Qualifications:

• Informatica BDM, Big Data, Hive, Hadoop, and UNIX Production Support experience.

Additional Qualifications:

• Extensive hands-on experience with Informatica Big Data Management, Informatica BDE, or similar Informatica data integration tools.
• Solid understanding of the Hadoop ecosystem, particularly HDFS and Hive.
• Strong grasp of ETL workflows, batch processing, and data warehouse principles.
• Proficient in SQL for data analysis, reconciliation, and production troubleshooting.
• Thorough knowledge of UNIX/Linux commands and shell scripting.
• Experience in monitoring and troubleshooting Informatica mappings, sessions, and workflows.
• Familiarity with job scheduling and monitoring tools such as AutoSys, Control M, ESP, or equivalents.
• Understanding of incident, problem, and change management processes.
• Experience with ServiceNow or similar ticket management systems.
• Exceptional analytical, troubleshooting, and problem-solving abilities.
• Strong communication skills, both written and verbal.
• Informatica documentation indicates that its Big Data environment integrates with Hadoop services like HDFS and Hive, facilitating distributed data processing and mapping execution.

Preferred Skills:

Technology->Informatica ETL Developer->SmartCo ETL Developer