ETL Developer
3 weeks ago
Bachelor's degree in computer science or a related field or related experience. Minimum of five years of experience related to the essential functions of the position. Any equivalent education and\or work experience may be substituted in order to meet the minimum qualifications of the position.
PREFERRED QUALIFICATIONS :
Experience with complex SQL Server PL/SQL, Stored Procedures, ETL framework and concepts, Datawarehousing concepts, Cloud concepts, Microsoft SSIS, SSRS, IBM Datastage, database programming, Azure Data factory, Azure Devops, Azure SQL, SQL performance tuning, data modeling, ETL job scheduling, execution of datawarehousing projects.
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.
- Established policies, procedures, practices of the Nebraska Department of Education.
- Optimize database systems for performance efficiency.
- Have regular interaction with business team to understand the functional requirements and translate them into technical specification document and subsequently perform the coding of database and ETL artifacts.
- Create ETL packages/jobs as per the technical requirements.
- Troubleshoot SSIS packages and fix the code issues as needed.
- Analyze the required ETL packages for performance tuning and come up with solutions to improve the runtime.
- Prepare design specifications and functional documentations for assigned database projects.
- Analyze legacy and current systems and create technical documentation and source to target mapping document.
- Perform space management and capacity planning for database systems.
- Develop database tables and dictionaries.
- Troubleshoot database related issues in a timely fashion.
- Ensure data quality and integrity in databases.
- Identify any issues related to database performance and provide corrective measures.
- Create complex functions, scripts, stored procedures, and triggers to support application development.
- Eagerness to learn new tool/technologies quickly and start working immediately.
Required Skills : Experience with complex SQL Server PL/SQL, Stored Procedures, ETL framework and concepts, Datawarehousing concepts, Cloud concepts, Microsoft SSIS, SSRS, IBM Datastage, database programming, Azure Data factory, Azure Devops, Azure SQL, SQL performance tuning, data modeling, ETL job scheduling, execution of datawarehousing projects.
Basic Qualification :
Additional Skills :
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :No
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 :Development/Engineering
Master Job Title :Dev: Other
Branch Code :Omaha
-
Data Management Leader
3 weeks ago
Lincoln, United States Saxon Global Full timeApex Systems has an opening for a Data Management Leader. Candidates can sit remote but must be willing to travel to office once per quarter. Key Job Responsibilities • Leading the Data Nexus Team and its efforts of improving the customer experience in accessing, processing and visualizing DHHS data, as well as developing data usage efficiencies. • Lead...
-
Data Management Leader
2 weeks ago
Lincoln, United States Saxon Global Full timeApex Systems has an opening for a Data Management Leader. Candidates can sit remote but must be willing to travel to office once per quarter. Key Job Responsibilities • Leading the Data Nexus Team and its efforts of improving the customer experience in accessing, processing and visualizing DHHS data, as well as developing data usage efficiencies. • Lead...
-
Data Scientist II
3 weeks ago
Lincoln, United States Allergan Full timeCompany Description AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and...
-
Senior Healthcare Data Analyst
3 days ago
Lincoln, United States Bryan Health Full timeGENERAL SUMMARY: Provides advanced design and insight to help key leaders and teams at Bryan Health solve problems and make data-driven decisions. Provides tailored quantitative and data-centered support, serving as a data analytics expert and point person for their specified teams and leaders. Works on medium and complex, cross-functional business...
-
Associate Director, Commercial Data Operations
2 weeks ago
Lincoln, United States Allergan Full timeCompany Description AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas – immunology, oncology, neuroscience, and eye care – and products and...
