Participates as a key member of the data integration practice to install, configure, and program applications and associated data-marts per business requirements.
Builds, documents, and maintains complex ETL jobs and data-flow processes using a combination of SSIS and other applications.
Optimization and automation of existing ETL and data-flow processes inclusive of file imports/exports, data-mart population, and data-refresh processes.
Assists in the identification and resolution of data quality and performance related issues.
Provides guidance in the utilization of development techniques and tools to management and staff members promoting a high standard of execution.
Maintains business intelligence systems data dictionaries, schema documentation, and jobs inventory for the data integration practice.
Serves as technical mentor and reviewer as assigned - sharing knowledge and expertise with colleagues and playing an active role in developing technical expertise in team members.
Other duties within the data integration practice as needed.
Job Level Specific Duties
Supports large and critical software applications within the organization.
Viewed as a technical expert or advisor for one or more applications.
Participates on (and may lead) projects where analysis of systems or data requires an in-depth evaluation of complex business process, system process, and industry standards.
Regularly mentors and reviews work of less experienced team members.
Executes schedules, costs and documentation to ensure assigned projects come to successful conclusion.
Initiates corrective action to stay on project schedules.
Possesses and applies broad knowledge of applications programming principles.
Competent to analyze diverse and complex problems.
Competent to work in all phases of applications programming.
Knowledge includes advanced work on standard applications programs including coding, testing and debugging.
5 years’ experience as a Data Integrator-ETL-Microsoft SSIS
1 year experience as a DBA Database Administrator-Databases-Data Modeling and Design-Modeling tool