About the position
The Software Developer position involves translating and analyzing business requirements into technical designs for mapping and loading data from source systems to the data warehouse. The role requires implementing end-to-end ETL processes, developing mappings, defining workflows and tasks, and monitoring sessions. The candidate will create complex SSIS packages and stored procedures scheduled in SQL Agent Jobs, as well as generate SSRS reports. The position also entails using T-SQL to construct user functions, views, indexes, user profiles, relational database models, data dictionaries, and ensuring data integrity. Additionally, the developer will transform data between servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS). The role includes creating and maintaining SQL Server Agent jobs for automated processes and designing SSIS packages for data profiling, cleansing, and transformation. The candidate will participate in enhancing ETL design processes, source code control, integration testing, defect management, and database standardization and tuning.
Responsibilities
- Translate and analyze business requirements onto technical designs.
- Map and load data from source systems to the data warehouse.
- Implement end-to-end ETL processes.
- Develop mappings, define workflows and tasks, and monitor sessions.
- Create complex SSIS packages and stored procedures scheduled in SQL Agent Jobs.
- Create SSRS reports.
- Use T-SQL to construct user functions, views, indexes, user profiles, relational database models, data dictionaries, and ensure data integrity.
- Transform data from one server to another using BCP and DTS.
- Create complex stored procedures, SSIS packages, triggers, cursors, tables, and views.
- Create packages in SSIS with error handling.
- Work with different methods of logging in SSIS.
- Optimize DTS package queries and stored procedures using SQL Profiler and Query Analyzer.
- Create and maintain SQL Server Agent jobs for automated processes.
- Design SSIS packages for data profiling, cleansing, and transformation.
- Test, deploy, and quality assure ETL content.
- Work on SSIS configuration and troubleshooting.
- Enhance processes for ETL design, source code control, integration testing, defect management, and database standardization.
Requirements
- Master's degree or equivalent in Computer Science, Electrical Engineering, Engineering Management, or a related field (or a Bachelor's degree plus 5 years of progressive post-baccalaureate experience).
- 1 year of experience in analyzing business requirements.
- 1 year of experience implementing end-to-end ETL processes.
- 1 year of experience developing mappings, defining workflows and tasks, and monitoring sessions.
- 1 year of experience working with complex SSIS packages and stored procedures scheduled in SQL Agent Jobs.
- 1 year of experience creating SSRS reports.
Nice-to-haves
- Experience with C#, Visual Studio, and JIRA.
