Application ETL Developer Expert - Apex Systems

Job#: 2049104

Job Description:

Apex Systems is searching for an ETL/Data Integration Developer to join one of our largest government services clients. This position sits 100% on-site in Lincoln, Nebraska, so only candidates that will be on-site 100% of the time can be considered.

The ETL / Data integration Developer role will be responsible for developing and implementing ETL processes from a variety of data sources. This includes building high-level conceptual models, logical models and production of high-quality documentation. The ETL Developers will also participate in requirements gathering, collecting data definitions, source to target mapping, and defining and implementing data transformation, quality checking, cleansing, and standardization processes. The role will also be responsible for testing the resulting processes for accuracy and performance.
Although this is an individual contributor role, this is a highly collaborative Agile team environment requiring personal flexibility in performing a variety of roles such as analyst, designer, developer, tester, troubleshoot, performance tunes and mentor when needed; all to take the necessary steps to ensure our customers needs are met to the maximum extent possible in an accurate and timely manner.
MINIMUM QUALIFICATIONS: Bachelors 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: Extensive experience in data migration projects utilizing ETL/ELT tools, with strong expertise in database modeling techniques. Proven track record in application database re-engineering, redesign, and data migration from legacy databases across multiple agencies. Skilled in developing complex SQL Server PL/SQL, Stored Procedures, and ETL frameworks, with a strong grasp of data warehousing and cloud computing concepts. Proficient with a range of tools, including MuleSoft, Qlik, Talend, DataStage, AWS Glue, AWS Data Pipeline, and Azure Data Factory. Hands-on experience with database programming, Azure DevOps, Azure SQL, SQL performance tuning, data modeling, and ETL job scheduling. Successful execution of data warehousing projects across various platforms such as Snowflake, Databricks, Redshift, and other cloud-based data platforms.
Knowledge and Abilities:
KNOWLEDGE:
• Writes advanced SQL including some query tuning.
• Experience in the identification of data quality.
• Experience in creating ETL jobs using DataStage, Qlik, Talend or MuleSoft
for data migration.
• Utilize ad-hoc techniques to perform on-the-fly analysis of data in all forms
(structured, unstructured and semi structured).
• Proficient in how to design, implement, and troubleshoot a production Data
Platform environment.
• Design, build and implement effective ETL/ELT jobs both in scheduled batch and real-time. • Implement stored procedures and effectively query a database for multiple databases using established security procedures.
• 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.
• Experience with the development and use of APIs for data sharing and consuming.
• Knowledgeable with data infrastructure both on premise and in the cloud. Preferable in Azure or AWS
• Experience working in a DevOps, Continuous Integration and Continuous Delivery environments.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.