Senior ETL Developer

Knowledge and Abilities : KNOWLEDGE: The entire software development lifecycle. Writes advanced SQL including some query tuning. Experience in the identification of data quality. Experience in creating ETL jobs using IBM datastage. Experience in creating data pipelines using Azure data factory. Experience designing and building complete ETL/Microsoft SSIS/IBM Datastage processes moving and transforming data for ODS, Staging, and Data Warehousing. Utilize ad-hoc techniques to perform on-the-fly analysis of data. Proficient in how to deploy to and debug a production SSIS/IBM Datastage environment. Design, build and deploy effective IBM Datastage/SSIS packages. Implement stored procedures and effectively query a database. Identify and test for bugs and bottlenecks in the ETL solution. Ensure the best possible performance and quality in the ETL packages. Provide support and fix issues in the ETL packages. Author and execute unit test scripts. Required Skills : Basic Qualification : Additional Skills : 100% remote Background Check :Yes Drug Screen :Yes Notes : Selling points for candidate :100% remote Project Verification Info : Candidate must be your W2 Employee :Yes Exclusive to Apex :No Face to face interview required :No Candidate must be local :No Candidate must be authorized to work without sponsorship ::No Interview times set : :No Type of project :Other Project Type Master Job Title :VMS Access Entry Branch Code :Omaha