ETL Developer

Job Description

​Responsibilities: Design and develop ETL/ELTL solutions using data warehouse design best practices and Database Modeling methodologies. Create data lineage maps. Document all ETL or ELTL and other data warehouse processes and flows. Create or update technical documentation for transition to support teams. Develop automated data audit and validation processes. Develop and manage big data pipelines using tools like Hadoop, Hive. Develop and deploy ETL/ELTL job workflow with reliable error/ exception handling and rollback. Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with database backups and performance tuning. Design, develop, test, adapt ETL/ELTL code and jobs to accommodate changes in source data and new business requirements. Provide technical leadership in design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintenance. Manage automation of file processing as well as all ETL/ELTL processes within a job workflow. Develop, contribute and adhere to the development of standards and sound procedural practices in compliance with healthcare regulations and HIPAA rules. Ensure data quality throughout the entire ETL/ELTL process, including audits and feedback loops to sources of truth. Will work in Pleasanton, CA and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.