We are looking for Microsoft Business Intelligence IT Professional having an experience more than 8 years and expertise in areas such as SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022. The resource will play a key role as a Technical Architect in Access Management platform handling the complete back end of IIQ repository. The candidate should have a solid working knowledge of various IT systems/technologies and enjoy working collaboratively across teams. This position requires constant interaction with technology operations and security compliance teams to understand management processes, which must be re-engineered to work with SAILPOINT processes
Responsibilities
Direct Responsibilities - Should be responsible of creating ETL packages for loading data from HR database.
- Should be responsible in maintaining / supporting / developing SSIS, SSRS & SSAS and SQL packages for the IIQ repository.
- Provide technical leadership and Propose improvements related to the development activity (job performance)
- Problem resolution: Incidents analysis, steering of corrective action
- Strong hands-on experience on Web and Application servers
- Needs to have experience in Performance engineering and improving SailPoint application performance
- Accountable for generation, reporting and improvements of various Production KPIs, SLs and dashboards for APS teams.
- Accountable for improvements in service and presentations for all governances and steering committees
- Accountable for maintenance and improvement of IT continuity plans (ICP)
Contributing Responsibilities Technical & Behavioral Competencies - Have minimum of 8 years of strong experience in Microsoft Technology (Microsoft Business Intelligence) MSBI like SSIS, SSRS & SSAS and SQL Server 2005/2012/2014/2017/2019/2022
- In-depth Technical Knowledge on Microsoft Business Intelligence (MSBI) Tools like SQL Server 2005/2008/2012 Integration Services and Reporting Services
- Should have Knowledge on creating Package Configuration, Logging, and Error Handling for the SSIS Packages.
- Having knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
- Experience in Deployment of ETL Packages in different environments and worked for preparing the deployment documentation for the DBA team.
- Experience in creating relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and (Multidimensional) MDX queries.
- Experience in extracting the data using SSIS from OLTP to OLAP.
- Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
- Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and restore Database backup.
- Experience in creating like Drill-Down, Drill-Through, Sub Reports, Parameterized reports and subscriptions in SSRS. Configuring the Report security in the Report configuration manager
- Should have at least 3 years of excellent hands on experience on SailPoint, in design and developing functionalities like Lifecycle Management, Multiplexed and Direct Reconciliation, Workflow Management & Compliance Management
- Knowledge on Power BI, SAP BO Reporting & Tableau will be an added advantagePreferred to have
Specific Qualifications (if required) Graduate in any discipline or bachelors in information technology
Skills Referential
Behavioural Skills : (Please select up to 4 skills)
Ability to collaborate / Teamwork
Creativity & Innovation / Problem solving
Ability to deliver / Results driven
Communication skills - oral & written
Transversal Skills: (Please select up to 5 skills)
Ability to manage a project
Ability to set up relevant performance indicators
Ability to anticipate business / strategic evolution
Ability to develop and adapt a process
Analytical Ability
Education Level:
Bachelor Degree or equivalent
Experience Level
At least 5 years