Application ETL Developer Expert Job at Apex Systems, Lincoln, NE

S3c3S2JxcVdsNUQ1M3ZSZ3FOa3NLejN1QlE9PQ==
  • Apex Systems
  • Lincoln, NE

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 MuleSoftfor 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 DataPlatform 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 EmployerApex 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 .Apex Systems is a world-class IT services company that serves thousands of clients across the globe. When you join Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRated's Best of Staffing® in Talent Satisfaction in the United States and Great Place to Work® in the United Kingdom and Mexico. Apex Systems

Job Tags

Work experience placement,

Similar Jobs

Superprof

Accounting Private Tutoring Jobs Job at Superprof

 ...teach and learn. We enable our tutors to set their own rates, work from home, tutor online or in-person and connect with thousands of...  ...the ideal job for students, graduates, those who want to be self-employed, or anyone wanting to earn extra money during the evenings or... 

Enora Insurance Agency

Customer Service Representative-MUST BE Bilingual English & Spanish Job at Enora Insurance Agency

 ...Job Description Job Description MUST BE FULLY BUILINGUAL-ENGLISH & SPANISH - please do not apply if you do not fully understand, speak and write Spanish. Enora Insurance Agency in Chicago, IL is seeking a passionate, self-driven Customer Service Rep with a desire... 

Thermo Fisher Scientific

Sr Site Specialist, Buffer and Media Prep Job at Thermo Fisher Scientific

Work ScheduleStandard (Mon-Fri) Environmental ConditionsAdherence to all Good Manufacturing Practices (GMP) Safety Standards, Cold Room/Freezers -22degrees, Some degree of PPE (Personal Protective Equipment) required (safety glasses, gowning, gloves, lab coat, ear plugs...

Tech Tammina

Data Warehouse Architects / Engineers Job at Tech Tammina

Job Title: Data Warehouse Architects / EngineersLocation: NYC, NYExperience:14+ years in the IT industry.8+ years working with US companies in the US.8+ years as a Data Architect/Engineer.5+ years of recent experience (since 2015) in a major banking or brokerage... 

SBS Services Group (SSG)

Franchise Business Consultant/Operations Consultant Job at SBS Services Group (SSG)

 ...Building Solutions is the industry-leading franchise in green commercial cleaning. In an ever...  ...#1 fastest-growing franchise brand (#23 business overall). Stratus fosters an environment...  ...Job Summary As a Franchise Business Consultant for the #1 Commercial Cleaning company...