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
SynergisticIT
...a range of IT domains, including Java, Full-stack Development, Data Science, Machine Learning, Python, and AI roles. Whether you're... ...Mandatory): degree (BS/MS/AS) in Computer Science, IT, Computer Engineering, Information Systems, Mathematics, Statistics, or a related...
Agile 24 Healthcare
...Agile 24 Healthcare is seeking a travel RDN - Registered Dietitian Nutritionist for a travel job in Bronx, New York. Job Description & Requirements ~ Specialty: RDN - Registered Dietitian Nutritionist ~ Discipline: Allied Health Professional ~ Duration: 13 weeks...
SmarTek21
...solutions, making digital transformations seamless for our clients. What we are looking for.. We are looking forTPO (Technical Product Owner). Position Summary Platform Engineering is the starting point for our application modernization and Developer Experience...
LEAP
...everything our teammates do by offering supportive and inclusive benefits that allow them to thrive. This includes things like: ~ Remote work options ~ Autonomy and flexibility ~ PTO and Summer Fridays ~401k plan with company match and 1:1 access to investment...
CV Library
...being a distributed-first company.We are looking for a Senior engineer who is passionate about scaling Cloud services to join our... ...aware of current industry trends (particularly those related to reliability). You have experience mentoring and growing team members and love...