Job #: 2251
Title: ETL Developer
To design and implement complex ETL processes for the Data management and Quality program.
The Senior ETL Developer is primarily responsible for the design, implementation and maintenance of ETL development to support the needs of data warehousing. The position is responsible for automation, job scheduling and streamlining all data exchange needs of the organization.
Essential duties include designing and streamlining various inter and intra organization ETL processes.
Develop and implement schedule / dependency logic for automated ETL processing. This includes inbound and outbound data share from data warehouse. ·
Accountable for implementing architectural, developmental and operational standards and practices including creation of ETL metadata. ·
Identify and enforce data standards and best practices to ensure consistent and maintainable structures in the database. ·
Design and develop enterprise and departmental analytical engine and data warehousing solutions. · Develop and maintain source‐to‐target mapping specifications for ETL development. ·
Strong relational database and SQL skills required, with MS SQL/Server and Oracle preferred. An understanding of DB2 is a plus. ·
Work with other team members to continually improve our quality of service delivery. ·
Actively participate on project team meetings to achieve team goals and departmental goals. ·
Compliance with business policies and industry standard best practices with regard to data exchange and information security. ·
Managing risk associated with handling sensitive data. ·
Off‐hours and on‐call production support may be required.
Request for Statement of Work ·
Adherence to internal and external production SLAs. ·
Limited travel may be required.
3. Qualifications / Required Skills
Bachelor’s degree with 7+ years of work experience in design and implementation of ETL framework for complex data warehouse initiatives. ·
7+ years of strong knowledge of DataStage with background in development of DataStage solutions
5+ years of experience with DataStage V.11.7 required. ·
Experience with full lifecycle enterprise data warehouse build. ·
Minimum 4 years of experience working with healthcare data and secure inbound and outbound data exchange. ·
Minimum 4 years of strong experience to design scalable data models and data flows. ·
Experience with UNIX shell scripts for automation of jobs is a plus ·
Experience with process documentation and efficiency improvement ·
Willingness to participate in team on‐call rotation, and perform off hours work as needed. ·
Strong technical and project management/process leadership skills ·
Knowledge of healthcare industry systems and applications is a plus. ·
Ability to work within a diverse, technically oriented, team setting is a must. ·
Demonstrated ability to take ownership of incidents, coordinate effective response, and drive improvements through root cause analysis and lessons learned. ·
The ability to quickly absorb new changes in computer technologies is necessary.