Job Description
We are looking for a Database Developer for our Company. He is able to designs data storage systems, works to fill them with data, and supervises the process of loading big data into data warehousing software. Designs develop, automates, and supports complex queries to extract, transform, and load data.
Key Responsibilities:
- Create, update and maintain packages and scripts to integrate business data or perform ETL using Microsoft Integration Services and/or stored procedures
- Write scripts to create views, procedures, and functions in support of the application and report development and testing
- Work directly with end-users to gather requirements and understand database related requirements for Business Intelligence applications
- Data Work with development team members using agile principles to complete data integration project objectives
- modeling and design
- Documentation of database system
- Proficient with the working of stored procedures, triggers, and packages
- Database performance tuning
- Strong understanding of data structures and algorithms
- Analyze current ETL process, define and design new systems
- Data warehouse development and work with SSAS, SSIS, and SSRS
Required Skills:
- Experience with TSQL including design and implementation of tables, constraints, indexes, stored procedures, views, and complex SQL statements
- Hands-on with ETL methodologies, design, and analysis
- Hands-on with Power Bi tool for reporting.
- Good working with databases like Oracle, MySQL, SQL Server, Postgres.
- Google's big query and Azure Synapse ETL would be a plus point.
Must-Have:
- 1+ years development experience
- BCS/ MCS/ BSc