Description:. Monitoring and MaintenanceMonitor ETL workflows, jobs, and data pipelines (using tools like Informatica, Talend, SSIS, etc.)Ensure all scheduled ETL jobs complete successfully within SLA timelines.Perform daily health checks of ETL jobs and source/target systems.2. Issue Identification and ResolutionTroubleshoot job failures, performance issues, or data mismatches.Analyze logs and error messages to determine root cause.Work with developers or DBAs to resolve issues as needed.3. Incident and Ticket ManagementHandle incidents or service requests raised via ITSM tools (like ServiceNow, Jira, BMC Remedy).Document resolution steps in the ticketing system.Escalate critical issues as per defined protocols.4. Data Validation and Quality ChecksValidate data accuracy between source and target.Identify and fix data discrepancies or anomalies.Execute ad-hoc queries and reports for data investigation.5. Job Scheduling and CoordinationManage job dependencies and rerun failed jobs.Coordinate with upstream/downstream teams for data availability or job schedules.6. Deployment and Change SupportSupport deployment of ETL code/fixes in non-prod/prod environments.Perform post-deployment validations.
Job Title
ETL Consultant