SQL Developer - Diverse Lynx
Pasadena, CA
About the Job
Skills: Microsoft SQL Server 2016
Job Description:
8-10 Years Experience as a MSSQL Developer.
Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from Microsoft Dynamics and other sources, I.e.
Oracle database, text files, Excel Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data Design, implement and maintain database objects (tables, views, indexes, ) and database security Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations and prepare data for presenting in Tableau or Power BI.
Test and prepare ETL processes for deployment to production and non-production environments Support system and acceptance testing including the development or refinement of test plan
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Job Description:
8-10 Years Experience as a MSSQL Developer.
Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from Microsoft Dynamics and other sources, I.e.
Oracle database, text files, Excel Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
Builds data transformations with SSIS including importing data from files, moving data from one database platform to another Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data Design, implement and maintain database objects (tables, views, indexes, ) and database security Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations and prepare data for presenting in Tableau or Power BI.
Test and prepare ETL processes for deployment to production and non-production environments Support system and acceptance testing including the development or refinement of test plan
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.
Source : Diverse Lynx
