We are looking for a Data Integration/ETL Engineer to join our team. The position is responsible for understanding requirements, solution design and ETL development. This team member will analyze and review business requirement documents, Source to Target Mappings and complex data models. The candidate will then be responsible for the end to end development and testing of the ETL processes, including documenting technical data flows between operational systems. Candidates should have proven experience designing and developing transformation rules to support transaction databases.
WHAT YOU WILL BE DOING:
Participate in requirements and design sessions as well as being responsible for the development of ETL logic to meet business requirements for intake of data from clients and integration into Teladoc Health systems.
Analyze and translate functional specifications and change requests into technical specifications along with the development, testing and implementation of ETL program logic.
Analyze data sources, write prototype SQL to prove data transforms.
Design, develop and tune solutions to integrate data provided by clients into Teladoc Health systems with appropriate error handling and monitoring.
Ongoing production support and failure troubleshooting.
Design and develop solutions that identify data issues and report errors for further analysis.
Help build positive relationships between business users and IT staff.
Utilize industry best practices and generally accepted procedures.
Proactively develop and maintain technical knowledge in specialized area(s), remaining up-to-date on current trends and best practices; leveraging expertise to produce world class solutions that are meaningful and useful to the business.
Take an active role in maintaining and improving development practices, standards, procedures, and controls (e.g., documentation, development and testing).
Evaluate and identify new technologies.
Improve operations by performing systems / data analysis and recommending changes in workflow and procedures.
EDUCATION AND EXPERIENCE YOU SHOULD HAVE:
Bachelor's Degree in Computer Science or related field required (years of relevant experience may be substituted)
At least 5+ years of work experience on a data integration/ETL development team required
At least 5+ years of work experience as a ETL Engineer/Developer required
Experience delivering Data Integration solutions for large scale enterprise systems
PREFERRED SKILLS AND COMPETENCIES:
Advanced Talend or Similar ETL Tool (Informatica, Datastage) experience.
SSIS experience preferred with knowledge of T-SQL.
Salesforce experience preferred with knowledge of SOQL.
Well versed in SQL development with advanced ANSI SQL skills. MySQL preferred.
Working knowledge of data modeling methodologies and concepts
Working knowledge of data modeling concepts for both normalized OLTP systems and denormalized datawarehouses (star schema).
Analytical, yet able to communicate well with others, both written and spoken
Adept in understanding technical requirements and convert them into data flows.
Ability to write and speak clearly, easily communicating complex ideas
Works collaboratively with teammates
Comfortable contributing and debating in a casual and friendly team environment
Knowledge of cloud technologies is a plus.
Teladoc Health is the global virtual care leader, offering the only comprehensive virtual care solution spanning telehealth, expert medical, and licensed platform services. Teladoc Health serves the world's leading insurers, employers, and health systems and helps millions of people around the world resolve their healthcare needs with confidence.