The primary job function is to develop, test, tune, and maintain database software applications in support of the achievement of business requirements. The position is expected to develop both data warehouse and ETL artifacts based on a defined architecture. This would include database tables, views, stored procedures, etc., and SSIS packages. This role is also expected to meet with their business counterparts to discuss requirements and understand their needs to provide recommendations on a solution to support the requirements.
- Contributes to the development and executes to deliver a future state architecture that transforms our current technology landscape to service oriented decoupling presentation layers and business logic from systems of record.
- Provide technical expertise and recommendations in analyzing customer needs, document requirements, and design technical solutions.
- Contributes to solution design discussions
- Supports application teams in utilizing the integration layer effectively to facilitate speed to delivery of business capabilities
- Create SSIS packages to import/export data, and load and process data.
- Prepare data for job runs. Support jobs in process. Troubleshoot, analyze and repair job issues.
- Develop and enhance stored procedures. Write ad-hoc SQL queries to support report requests.
- Create test plans, test cases, test scripts and perform data testing and validation.
- Experience creating technical design documentation.
- Excellent work ethics, self-motivated, quick learner, and team oriented.
- A minimum of 3 years of data warehouse / ETL development experience.
- Experience in a BI/Data Warehouse environment with involvement in design and architecture.
- Experience developing ETL solutions utilizing SSIS including Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
- Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
- Experience working in a highly collaborative environment, proactively innovating solutions that support the goals and desired outcomes that provide business value