Responsibilities:
- Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process
- Design and develop SSRS / SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems
- Build data transformations with SSIS including importing data from files, moving data from one database platform to another.
- Building reports using SSRS
- Debug and tune SSIS, SSRS or other ETL processes to ensure accurate and efficient movement of data
- Design, implement and maintain database objects (tables, views, indexes etc) and database security
- Experience working with SSIS, SSRS packages
- Proficient with ETL tools such as Microsoft SSIS, SSRS
- Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations
- Test and prepare ETL processes for deployment to production and non-production environments
- Support system and acceptance testing including the development or refinement of test plans
- Any other adhoc duties as assigned
Requirements:
- Minimum Degree in Computer Science, Information Systems, or related field, or equivalent
- At least 5-7 years of relevant working experience in ETL development and SQL Server-based data solutions
- Proficient in SQL Server (T-SQL, stored procedures, views, functions, triggers), SSIS (ETL), SSRS (reporting), and database design and optimization experience in data transformation, migration, and testing across environments
- Strong analytical, problem-solving, and communication skills ability to collaborate with cross-functional teams and manage data-driven projects
- Microsoft Certified: Data Analyst Associate or Microsoft Certified: Azure Data Engineer Associate preferred
Follow us for more updates, interview tips!
Our telegram channel for job opportunities -
Shortlisted Candidates will be notified
Adelphe Reg No. R1981957
Julian Grey Corporate Advisory Pte. Ltd.
EA License No: 19C9568
