Job Description :
· Builds data transformations with SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
· Strong knowledge of relational databases, as well as skills in SQL query design and development.
· Collaborates with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
· Gathers business requirements and works with data analysts on physical database design and modeling.
· Performs code reviews, analyzes execution plans, and re-factors inefficient code.
Follows data standards, resolves data issues, and completes unit testing and system documentation for Extract Transfer Load (ETL) processes.
· Conducts system tests and root cause analysis, troubleshoots customer issues and corrects database defects, responding quickly to bug fixes and enhancement requests.
Follows change management process to resolve application defects or to implement development enhancements.
· Provides assistance with ETL standards and design for future supportability and ease of enhancements.
· Assists with the creation of reusable components as they relate to the ETL framework.
· Assists with the management of ETL scalability and system management.
· Creates technical documentation of design logic and ETL processes based on technology best practices, guidelines and repeatable processes.
· Helps prepare and run unit, integration, UAT, regression, stress and performance plan documents and tests while documenting results.
· Analyzes day-to-day functions and processes to ensure they are performing within predetermined guidelines, limits, and specifications