MSSQL 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, 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.

Location: Pasadena, CA, US

Posted Date: 11/22/2024