Sr ETL Data Integration Developer Expert
Sr ETL Data Integration Developer Expert
Posted on :
03-10-2024
Employer Active
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Job Description
Summary:
The ETL / Data integration Developer role will be responsible for developing and implementing ETL processes from a variety of data sources. This includes building highlevel conceptual models logical models and production of highquality doentation. 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 yst designer developer tester trouble 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:
The ETL / Data integration Developer role will be responsible for developing and implementing ETL processes from a variety of data sources. This includes building highlevel conceptual models logical models and production of highquality doentation. 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 yst designer developer tester trouble 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 andor 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 reengineering redesign and data migration from legacy databases across multiple agencies. Sed 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. Handson experience with database programming Azure DevOps Azure SQL SQL performance tuning data modeling and ETL job scheduling. Successful of data warehousing projects across various platforms such as Snowflake Databricks Redshift and other cloudbased data platforms.
Knowledge and Abilities:
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 adhoc techniques to perform onthefly ysis of data in all forms (structured unstructured and semi structured).
- Proficient in how to design implement and trouble a production Data Platform environment.
- Design build and implement effective ETL/ELT jobs both in scheduled batch and realtime. Implement stored procedures and effectively query a database for multiple databases using elished 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.
- Work within developing and elishing policies standards procedures practices of the State of Nebraska Department of OCIO.
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
