![]() ![]() Created and maintained technical documentation using defined technical documentation templates.Created, documented, and implemented unit test plans, scripts, and test cases.Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL. ![]() Created, Scheduled, Generated and optimized ETL jobs.Designed and developed ETL solutions for transformation of data from source transactional systems or other data feeds, into a dimensional database, or other destinations.Installed and Configured SQL Server Active/Active and Active/Passive clusters.Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Advisor.Involved in enhancing and deploying the SSIS Packages from development server to production server.Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.Successfully extracted transformed and load data into data warehouse.Created SSIS packages to migrate data from different data sources to data warehouse.SQL/ETL Developer Apex Systems – Dover, NH , ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |