What are the responsibilities and job description for the Senior ETL Developer (locals only) position at Scintillating Consulting Services LLC?
Role: ETL Developer
Location: Lincoln, NE-Onsite
Duration: 12 Months
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.
Knowledge and Abilities:
· 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
· 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.