Job Description:
• Translate business needs to technical specifications and deliverables. • Responsible for new report development, report maintenance and troubleshooting. • Design, build and deploy BI solutions and Analytics along with data warehousing. • Conducting preliminary testing of the warehousing environment before data is extracted. • Maintain and support data analytics platforms (e.g. MicroStrategy, Power BI, Temenos Analytics Application) • Create tools to store data (e.g. OLAP cubes) • Evaluate and improve existing BI systems and existing reports. • Develop, execute and optimize database queries and conduct analyses. • Create visualizations, GI, dashboards and reports with optimized views. • Develop and update technical documentation pertaining to BI division. • Extracting company data and transferring it into the new warehousing environment. • Design, develop and test ETL task utilizing dynamic mapping and task flows in SSIS. • Performance tuning of end-to-end ETL integration processes. • Determine optimal approach for obtaining data from multiple source systems. • Data purging and data cleaning. • Work on projects focused on continuous improvement of the applications support models and associated processes using appropriate technologies. • Any other task or project assigned by the Executive manager.
• Minimum 4 to 5 years work experience with ETL & BI tools. • At least Graduation (16 years) professional degree in IT/CS/SE/CE. • Minimum 6 years of work experience in ETL & BI tools. • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server • Experience with performance tuning. • Integration Services (SSIS). • Background in data warehouse design (e.g. dimensional modeling) and data mining. • In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. • Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI) • Analytical mind with a problem-solving aptitude.
• Have knowledge/experience of T24 banking and analytic systems • Good verbal and written communication skills • Statements in this document are intended to reflect, in general, the role and responsibilities of the position, but are not to be interpreted as totally inclusive. . Strong SQL coding capabilities
Python • Shell scripting • DAX coding •TSQL
Job Specifications:
BS SE/CS/IT
Database, Python, POWER BI, Machine Learning, Data
Computer Proficiency: Computer Proficiency: Experience in ETL & BI tools. Experience in DBMS,OLAP and ETL Experience in writing functions, procedures, triggers. Experience in SQL queries, TSQL, SSRS , SSIS & POWER BI Experience in Data Modeling
Other Details / Skills: Other Details / Skills: A good Team Player Good at troubleshooting issues. Can work independently Can work under pressure Professional behavior and ready to take on new learnings
Job Locations: