Hope you are doing great!! Please find the requirement below, if you find yourself comfortable with the requirement please reply back with your updated resume.
Role- MSSQL Developer Location- Pasadena, CA Role 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