http://cdn2.hubspot.net/hubfs/3905837/Calance_September2017/Calance_logo_180px.png


 


Calance Job Opening

Job TitleETL Developer (B2B Data Exchange required) - ID:34118
Duration6 Months to Hire
Start DateASAP
Job Skills 4+ years of ETL development experience using Informatica Power Center and Informatica B2B Data Exchange.
4+ years working knowledge in a Data Warehouse/BI environment.
2+ years SQL Server database experience.
2+ years working knowledge of Healthcare claims and clinical data. Understanding of Medical group business areas (clinical, operations, care mana
Locationst petersburg, FL
Date Posted01/14/2020

Generated button


Position Summary:
The ETL Developer is responsible for supporting the information management architecture of the Enterprise Data Warehouse. This role is responsible for extracting, transforming and loading data into data staging, and the data warehouse. This role will work closely with the data architect, data modeler, data analysts and other project team members to understand requirements regarding ETL design flows and data integration. They will collaborate on definition, development, and maintenance of standards and processes. The ETL Developer will develop ETL solutions following the well-defined data warehouse design and development best practices. Position reports to Manager - Data Management.

Duties & Responsibilities:

Meet with business and technical teams to discuss functional design concepts and alternatives necessary to meet requirements.
Optimize, develop and maintain data integration solutions using Informatica B2B Data Exchange and Informatica PowerCenter to connect legacy data stores, the data warehouse, and third-party platforms.
Develop and deploy ETL job workflows with reliable error/exception handling and rollback.
Take responsibility for data quality. Understand the implications of technology and process changes on data quality; provide guidance to business and IT related to data quality. Recommend processes and technologies that support high data quality.
Review Source to Target Mappings to create ETL processes and crosswalks.
Help define acceptance test objectives, test cases and assist in system and integration testing.
Assist in evaluating software change requests, which may involve conducting root cause analysis to confirm business need for changes and alternatives.
Work closely with end-users during User Acceptance Testing (UAT), and document issues and defects.
Partner with IT and Business teams to capture, track, and resolve data and reporting issues.

Minimum Qualifications:
4+ years of ETL development experience using Informatica Power Center and Informatica B2B Data Exchange.
4+ years working knowledge in a Data Warehouse/BI environment.
2+ years SQL Server database experience.
2+ years working knowledge of Healthcare claims and clinical data. Understanding of Medical group business areas (clinical, operations, care management).
Strong SQL skills and full understanding of querying relational and dimensional databases.
Experience reading detailed requirements, source to target mappings, design documents, and workflows in support of data warehousing and BI.
2+ years experience with Windows PowerShell scripting.
Experience with ActiveBatch a plus.
Ability to extract and transform data from multiple data sources.
Experience with Agile Software Development Lifecycle (SDLC) methodologies.
Driven by a fast-paced, energetic, results-oriented environment.
Ability to work with data warehouse and BI developers in formulating recommendations, strategies, and tactics based on analyses.
Must be a self-starter and able to work independently or lead teammates as needed.
Ability to build trust and create a strong working relationship with the data warehouse team and business customers.
Must have excellent listening and documentation skills.
Demonstrated self-direction with excellent organizational, analytical, writing, problem solving and interpersonal skills.

Education:
Bachelor’s degree in Computer Science or similar required.





Send To Email / Remind Me






WEB-DOM01-NEW


CONTACT US


ABOUT CALANCE


recruiting@calance.com
Mission Viejo, CA ~ (800) 732-4680
Atlanta, GA ~ (866) 951-1151


Calance is a global IT Services firm specializing in end-to-end solutions for Development, Managed Service,
Security, SAP, Project Control Integration and IT Staffing.Operating in the United States and India,
Calance helps clients bring their ideas and strategies to life through talent, technology and tenacity.


2019 All rights reserved.