Senior ETL Developer

Essential Functions

Design, develop, and implement ETL processes using industry best practices and standards.
Optimize ETL processes for performance, scalability, and reliability.
Troubleshoot and resolve issues related to data integration, ETL processes, and data quality.
· Develop standards and processes to support and facilitate integration projects and initiatives.
Develop data mappings, transformation rules, and data workflows to meet business needs.
Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
Document ETL processes, data mappings, and system configurations.
· Document, manage, and report on project risks and opportunities.
· Prioritizes tasks and meets project deadlines in a fast-paced work environment.
· Conform with all company policies and procedures.
Required Knowledge, Skills, Abilities (KSAs)

Experience with Oracle Data Lake Architecture will be preferred.
Experience on multi-cloud environments will be preferred.
Experience with ETL tools (Pentaho and or Oracle Data integration preferable)
Solid understanding of data warehousing concepts and methodologies.
Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
Experience working with data quality issues and providing remedies to those issues.
Experience querying databases and using statistical computer languages: Python, SQL etc.
Demonstrate understanding and experience with technical systems, datasets, data warehouses, and data analysis techniques
Strong analytical skills: ability to build quick estimates using back-of-the-envelope analysis, structure (and, if needed, execute) more complex analyses, pull together business cases, navigate multidimensional sets of tradeoffs. Above all, the job calls for comfort with data – ability to manipulate it, question its validity, interpret it, and develop recommendations based on it

Required Education, Certifications/ Licenses, Related Experience

Bachelor’s degree
At least 10 years or more total software development, architecture, and solution design experience
At least 5 years of hands on ETL tools (Pentaho and or Oracle Data integration preferable)
At least 5 years of hands on, ETL and data analysis experience.
At least 3 years’ experience with Cloud Native technologies
At least 2 years’ experience in design, implementation, deployment, and support of public cloud services and infrastructure (Aws, Oracle platform)