Truven Health Analytics, formerly the Healthcare business of Thomson Reuters, delivers unbiased information, analytic tools, benchmarks and services to the healthcare industry. Hospitals, government agencies, employers, health plans, clinicians, and pharmaceutical companies have relied on our solutions for over 30 years. Truven Health Analytics combines deep clinical, financial and healthcare management expertise with innovative technology platforms and information assets to make healthcare better, collaborating with customers to uncover and realize opportunities for improving quality, efficiency, and outcomes. Truven Health Analytics employs approximately 2,200 people worldwide and has principal offices in Ann Arbor, Chicago and Denver. For more information, please visit www.truvenhealth.com .
The Data Integration Programmer develops ETL programs for healthcare data warehousing projects. The role is responsible for creating and testing structured ETL processes from design specification and mapping documents. The position requires at least 3 years of experience developing ETL programs that load / integrate data from multiple input sources to database targets and extract / publish data from database sources. Candidates must demonstrate an understanding of ETL development best practices and the software development lifecycle. This role typically reports to an ETL or project team lead.
Perform data profiling on incoming data sources to assess quality
Utilize design specifications and source to target mapping documents to develop ETL programs
Code and test complex ETL programs using IBM InfoSphere DataStage or Oracle PL/SQL
Create unit test conditions, record and document results
Execute, schedule and test job streams and build an operational ETL system that is automated, stable and efficient
Conduct System Testing - execute job flows, investigate system defects, resolve defects and document test results
Deliver easy to maintain, re-usable modules that adhere to architectural governance standards and practices
Off hour and weekend support may be required to meet project milestones
3 years experience as ETL programmer on data warehouse or database projects
1 plus years developing programs using ETL tools such as Informatica Power Center, IBM InfoSphere DataStage 8.x, Oracle PL/SQL or equivalent
Experience in SQL and programming applications using Relational Database Management Systems
Experience performing data analysis and researching data quality issues
Experience working on large system implementation projects
2 to 3 years performing application development on an Enterprise Data Warehouse, Data Mart and/or Business Intelligence implementation project
Knowledge of Oracle (release 10g/11g) and experience developing PL/SQL procedures
Experience with healthcare data
Bachelor's degree preferred
3-5 years healthcare information/claims processing background.
We seek talented, qualified employees in all our operations regardless of race, gender, national origin, religion, sexual orientation, disability, age, or any other protected classification under country or local law. Truven Health Analytics is an Equal Employment Opportunity/Affirmative Action Employer.
According to the U.S. Citizenship and Immigration Services (USCIS), the H-1B visa cap has been met for the 2012 fiscal year (October 1, 2011-September 30, 2012).
Thomson Reuters - 16 months ago
Financial information is king and Thomson Reuters Corporation holds the crown. The company is the market leader in financial data (ahead of...