Job Summary
We are seeking an experienced Application Support Specialist with a strong background in data warehousing, business intelligence, and application support within large organizations, preferably in the banking sector. The role involves providing technical support, troubleshooting, and configuration management for applications while ensuring optimal performance. Additionally, the candidate will be responsible for developing and optimizing reports, dashboards, and data queries to support business intelligence needs.
Must Have Skillsets (Mandatory)
- Experience: 5+ years in a technical support role, application production support, or data warehousing within large organizations.
- Application Support: Proficiency in troubleshooting, configuration, performance tuning, and proactive monitoring within the ITIL framework.
- Reporting Tools: Hands-on experience with reporting tools such as MS Power BI, SSRS, Tableau, and QlikView; advanced knowledge of BI Publisher.
- Database Knowledge: Proficiency in relational and non-relational databases, including Sybase IQ, Oracle, MSSQL, SAP HANA, PostgreSQL, and Hive.
- SQL Skills: Advanced SQL (PL/SQL preferred) for complex query writing, views, procedures, and performance tuning.
- BI and Analytics: Experience in OBIEE Analytics and BIP Server for building reports, dashboards, and data models, with expertise in dimensional modeling and level-based measures.
- Scripting and Command Line: Strong experience with Windows and Unix command lines.
- ETL Tools: Familiarity with ETL tools like Informatica Power Center for report investigation and data flow monitoring.
Good to Have Skillsets (Optional)
- Banking Industry Experience: Background in banking applications and systems (e.g., FLEXCUBE, Oracle EBS, IBM BPM, and legacy systems).
- XML and Data Templates: Experience with XML, XPath, XSD, and creating RTF/PDF/XLS templates for BI Publisher reports.
- Additional Technical Knowledge: Knowledge of Open Source applications, application licensing, Informatica batch job monitoring and troubleshooting, and performance tuning of OBIEE at the repository level.
- Data Analysis Skills: Strong data analysis and problem-solving abilities, with experience working with aggregates, cubes, and hierarchies.
- Certifications: Relevant industry certifications such as ITIL are preferred.
Qualifications and Experience
- Education: Bachelor’s degree in Computer Science, IT, or a related field; equivalent work experience will be considered.
- Certifications: ITIL certification or other relevant industry-standard certifications are preferred.
- Technical Skills: Proven expertise in application production support, data warehousing, and business intelligence within large organizations.
- Communication and Collaboration: Strong communication skills to effectively work with cross-functional teams and stakeholders.
If you possess a combination of technical skills in application support, data warehousing, and business intelligence, along with a dedication to optimizing performance and troubleshooting complex issues, we encourage you to apply.