Senior EDL App Support, BDM, Informatica Support

Job Overview:

• We are seeking a skilled EDL Application Support Engineer to deliver production support for Enterprise Data Lake applications, including Informatica workflows and Hadoop-based data pipelines.
• The successful candidate will possess hands-on experience with Informatica BDM, Hadoop, HDFS, Hive, SQL, and UNIX/Linux, coupled with robust troubleshooting and incident management skills.
• The position requires monitoring production jobs, resolving application and data-related issues, conducting root cause analysis, supporting releases, and ensuring that vital data processing workflows function within agreed service levels.

Core Responsibilities:

• Provide L2 and L3 production support for Enterprise Data Lake applications, Informatica workflows, and Big Data pipelines.
• Oversee batch jobs, ETL workflows, and data loads, resolving failures in alignment with established SLA timelines.
• Diagnose issues related to Informatica mappings, sessions, parameter sets, workflows, and associated applications.
• Support and monitor components within the Hadoop ecosystem, including HDFS, Hive, and related data processing jobs.
• Examine application logs, system alerts, and job dependencies to pinpoint the root cause of production failures.
• Conduct SQL-based data validation, reconciliation, and troubleshooting to address data quality concerns.
• Troubleshoot Hive queries and resolve any performance or data processing challenges.
• Utilize UNIX/Linux commands and shell scripts for job monitoring, recovery, log analysis, and automation support.
• Perform root cause analysis for recurring incidents and work with development and infrastructure teams to implement permanent fixes.
• Manage incidents, service requests, problems, and changes in accordance with ITIL processes.
• Assist in production releases, deployment validation, rollback procedures, and post-production monitoring.
• Collaborate with application development, database, infrastructure, and business teams to resolve issues.
• Maintain incident reports, root cause analysis documents, standard operating procedures, knowledge articles, and operational support documentation.
• Offer timely updates to stakeholders and participate in shift-based or on-call support as necessary.
• These duties correspond with internal Informatica application support positions, emphasizing workflow monitoring, 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 expertise.

Additional Qualifications:

• Extensive hands-on experience with Informatica Big Data Management, Informatica BDE, or similar data integration tools from Informatica.
• Strong familiarity with the Hadoop ecosystem, particularly HDFS and Hive.
• Comprehensive understanding of ETL workflows, batch processing, and data warehousing concepts.
• Proficiency in SQL for data analysis, reconciliation, and production troubleshooting.
• Solid 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 equivalent solutions.
• 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.
• Documentation from Informatica verifies its Big Data environment's integration with Hadoop services such as HDFS and Hive, facilitating distributed data processing and mapping execution.

Preferred Abilities:

Technology->Informatica ETL Developer->SmartCo ETL Developer