Vacancy expired!
- Building SSIS packages involving ETL process, extracting data from various flat files, Excel files, legacy systems, screen scrapes and loading into SQL server.
- Plan, coordinate, develop and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.
- Writing complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables and Views.
- Object creation such as Tables and Views, Table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
- Documenting steps needed to migrate database objects between various. environments including Development, UAT, Staging, and Production.
Vacancy expired!