Job Description :
SQL Developer with ETL Exp
Location : Atlanta , GA
Duration : 12 Plus Months
Visa : any Visa
Job Description:
The focus is BI solution design, development, testing and implementation of ETL using a combination of Microsoft SQL Server Integration Services (SSIS), T SQL queries, PL/SQL along with SQL Server and Oracle database objects. .
This person will work with Microsoft SSIS packages and T SQL and Oracle PL/SQL to process Research
This position will need to perform scoping and estimating on Data Warehouse activities.
Present technical information and design proposals in easily understood terms in both verbal and written form.
This position is also responsible for detailed technical analysis to assure the availability and accuracy of data processed by the ETL or contained in the OHSU Research Data Warehouse.
Role:
Microsoft SSIS and TSQL, Oracle PL/SQL support, maintenance and development
Build and migrate SSIS projects, TSQL and database objects and perform necessary testing and validation such as unit testing during development and/or QA testing as required.
Share SQL Server SSIS, TSQL and related development expertise and provide support to data warehouse developers, data analysts, and users in the ETL migration and support of the Research Data Warehouse environment;
Develop and modify Oracle PL/SQL and related database objects in the ETL migration and support of the Research Data Warehouse environment;
Participate in peer code review sessions and offer suggestions that improve performance, maintainability, and best practice compliance;
Review and troubleshoot SSIS packages, TSQL and PL/SQL queries to address errors that occur during nightly and ad hoc processing;
Apply updates and ensure that data are loaded into the data warehouse according to defined requirements;
Maintain, support, and apply change data capture (CDC) processes for incremental loading of data
Apply standard data warehouse transformation concepts for the integration, validation, and organization of data necessary for loading into a dimensional data warehouse environment.
Perform query and process tuning and optimization
Follow change and version control procedures
Apply appropriate security structures and/or policies to data and/or database objects
Make recommendations on best practices for code maintenance, deployments, and migrations specific to SSIS
Required:
Bachelor’s degree in computer science, a related field, or a clinical field and six years work related experience
3 years experience applying advanced MS SQL server knowledge in the use of SSIS, T SQL and database object definition
3 years experience designing, developing, implementing and optimizing Oracle PL/SQL solutions
Experience supporting and maintaining a Data Warehouse and associated ETL in a MS SQL Server database
Knowledge of data warehousing architecture
Ability to read, write and maintain T-SQL and SSIS code, define and maintain, MS SQL Server database objects
Demonstrate Core Competencies as established for your position (Leading Self, Leading Others, Leading Leaders, Leading Function)
Desired:
Proficiency working with Apache Hadoop based open¬source tools such as Hive, Oozie, Spark, Kafka, Ranger, Falcon
Experience with Big Data environments such as Hadoop
Experience in a research or academic health care environment
Experience with HIPAA and PHI compliance
MS SQL Server Developer Certification
MS SQL Server Administrator Certification