Joseph A.

Experience

1. Ssis Etl Developer, Sql Server Developer

   Elevance Health

   Jan 2023 — Present

   Responsibilities Created complex Stored Procedures, and views to transform the Data and worked extensively in T-SQL for various needs of the transformations Designed and developed Complex SSIS packages using SQL SERVER 2012/14/17 Integration Services Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files, and Sybase databases. Generating complex Transact SQL (T-SQL) queries, Sub queries, Co-related, Dynamic SQL queries, etc. Deploy developed projects to catalog to multiple servers, create an environmental variable, Using SQL Server Agent to create jobs and schedule the SSIS packages from the catalog or SP, VW, or any query Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequence Container, Execute SQL Task, Email Task, Execute Package Task, and Data Flow Tasks. Derived Column, Union All, Conditional Split, Row Count, Audit, and Script Component. Identifying long-running queries, scripts, and tuning. Develop to get Long running query more than the threshold time and send notification and email alerts also using pager duty Use pager Duty to send alerts and notify the scheduled support team to work on errors or job failures Validated and modified the data using different Data Flow Transformations like Send Mail, Web -Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Experience in third-party SSIS Tools like ZappySys, used to email, zip/unzip, Download, Secure Ftp JSON File Sources, etc… Expertise in implementing complex ETL packages to extract data from various sources (SQL Server, Oracle, Excel file, DB2, SharePoint lists, and Flat File) and load into various destinations. Proficient in creating dynamic packages for Incremental Loads & Data Cleaning in DW using SSIS.Experience in error & event handling: Precedence Constraints, Break Points, Check Points, and Logging.

Education

• ADMAS UNIVERSITY

  Bachelor's degree

• Microsoft Certifide

  Certification