Key skills
InformaticaActiveBatchETL data movementWorkflow monitoring toolsWorkflowsession log analysisSQLOracleNetezzaDB2SDLC processesLinux/Unix environmentShell scriptingVI editorProactive process improvementKnowledge sharingPrioritizationEscalationShellETLBIBusiness IntelligenceSDLC
About this role
Endava is a company focused on IT services and consulting, and they are seeking an IT Operations Business Intelligence (BI) Analyst II. The role involves providing production support in a complex application and data warehouse environment, analyzing and resolving failures, and collaborating with IT teams to enhance BI systems.
Responsibilities:
- Provide production support in a complex application and data warehouse environment
- Analyze, troubleshoot and resolve failures
- Provide clarity with in-depth data research
- Implement fixes
- Collaborate with teams across IT to resolve complex issues and provide optimal solutions
- Emphasis on process improvement
- Continuously enhance the stability and long-term performance of BI systems
- Develop and update documentation, technical procedures, and knowledge articles
- Increase proficiency and scope of involvement on all activities through guided and self-initiated learning
- Participation in on-call rotation is required
Requirements:
- Experience with Informatica
- Experience with ActiveBatch or comparable enterprise scheduling applications
- Hands-on experience supporting ETL data movement in a production environment, including analyzing, troubleshooting, and resolving failures
- Ability to use workflow monitoring tools to identify failure points and trace issues back through workflow components
- Experience interpreting workflow and session logs to determine root cause
- Strong ability to write and interpret SQL across databases such as Oracle, Netezza, and DB2
- Ability to collaborate with cross-functional teams to resolve issues and improve processes
- Experience supporting routine and ad-hoc changes, including deployments
- Proactive in process improvement, documentation, and knowledge sharing
- Experience managing a ticket queue, including prioritization and escalation
- Understanding of SDLC processes
- Ability to navigate Linux/Unix environments, including directories, file permissions, and environment variables
- Ability to read shell scripts and use tools such as the VI editor
- Willingness to participate in an on-call rotation (one week every six weeks), including after-hours and weekend support, and resolving critical workflow failures
- Cloud data warehouse experience is a plus
- Development experience in an operations or support role is a plus