Company:
Diverse Lynx
Location: La Grange
Closing Date: 04/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Developer
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, ExcelDesign 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 anotherDebug and tune SSIS or other ETL processes to ensure accurate and efficient movement of dataDesign, implement and maintain database objects (tables, views, indexes, ) and database securityAnalyze 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 environmentsSupport 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.
Developer
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, ExcelDesign 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 anotherDebug and tune SSIS or other ETL processes to ensure accurate and efficient movement of dataDesign, implement and maintain database objects (tables, views, indexes, ) and database securityAnalyze 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 environmentsSupport 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.
Share this job
Useful Links