St. Petersburg, FL 33702
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 Technical Lead Florida Data Management.
Duties & Responsibilities:
Consistently exhibit behavior and communication skills that demonstrate commitment to superior customer service, including quality, care and concern with each and every internal and external customer.
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 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.
Use, protect, and disclose DaVita HCP patients protected health information (PHI) only in accordance with Health Insurance Portability and Accountability Act (HIPAA) standards.
4+ years of ETL development experience using Informatica Power Center.
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.
Bachelor s degree in Computer Science or similar required.
Blackstone is a global IT services and solutions firm that implements digital transformation solutions across commercial industry verticals and the US Federal Government. Blackstone was founded in 1998, and has offices in San Francisco, Denver, Houston, Colorado Springs, and Washington, DC. We specialize in IT staffing and place both technical and creative talent across a variety of industries and sectors.
EOE of Minorities/Females/Veterans/Disabilities