Junior Sql Developer


The Junior SQL Developer is required to create and maintain BI Solutions that turn data into knowledge. In this role, you should have a background in SQL, ETL processes and Data warehouse framework business analysis. A business acumen and problem- solving aptitude is advantageous. Ultimately, this role will enhance our business intelligence system to help us make better decisions. * Involved in creating various Tables, Views and Functions based on the requirement specified by MDU team and wrote complex Join statements for combining data from various Databases and tables. * Involved creating complex stored procedure based on business requirements. * Proficient in tuning SQL queries using execution plan, index and DMV. * Created SSIS packages with different data sources SQL Server, Flat files, Excel files, CSV files and loaded the data into target tables by performing different kinds of transformations using SSIS. * Use Packages by testing and cleaning the Standardized Data by using tools in Data Flow. * Involved in scheduling SSIS packages in multiple servers using SQL Server Agent. * Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file. * Responsible for database tuning using normalization and application tuning. * Documentation for all kinds of reports and SSIS packages. * Worked on locking, blocking and dead lock issues. * Involved in performance tuning of slow running queries using execution plan and index tuning wizard. * Scheduling jobs and alerts using SQL Server Agent and configured database mail for any job failure. *Education* Matric Relevant Diploma *Expirience:* Preferebly 3-5 years expirience Experience as a SQL\BI Developer Background in SQL\data warehouse design In-depth Understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. Knowledge of Analytical tools such as PowerPivot. Knowledge of SQL queries, SQL Server Reporting Services(SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Server (SSAS) Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude *Behavioural Competencies* Manages complexity Ensures accountability Optimizes work processes Plans and aligns Action oriented Business Insight Nimble learning Tech savvy *Education* Matric Relevant Diploma *Expirience:* Preferebly 3-5 years expirience Experience as a SQL\BI Developer Background in SQL\data warehouse design In-depth Understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework. Knowledge of Analytical tools such as PowerPivot. Knowledge of SQL queries, SQL Server Reporting Services(SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Server (SSAS) Proven abilities to take initiative and be innovative Analytical mind with a problem-solving aptitude *Behavioural Competencies* Manages complexity Ensures accountability Optimizes work processes Plans and aligns Action oriented Business Insight Nimble learning Tech savvy
Posted
05/05/2022
Location
Johannesburg, GT, ZA