Our client, a US Fortune 50 organization and a leading provider of Health care and Health Insurance services, seeks an accomplished ETL Data Integration Developer
______________________________________________________________________
NOTE: THIS IS 100% REMOTE ROLE & ONLY W2 CANDIDATES.
*** Candidate must be authorized to work in USA without requiring sponsorship ***
Position: ETL Data Integration Developer (Job Id - # WLPTJP00047079)
Location: Baltimore MD (100% REMOTE)
Duration: 8 Months + Strong Possibility of Extension
______________________________________________________
Seeking an experienced Senior ETL & Data Integration Developer to support the Claimscore modernization initiative. This contractor will maintain and enhance existing legacy claims data integrations while developing new data feeds from the Claimscore platform. The primary objective is to enable legacy and modernized claims systems to operate in parallel, ensuring data continuity and accurate consolidation into existing enterprise data models without disrupting downstream applications, reporting, or analytics.
Key Responsibilities
- Maintain, troubleshoot, and enhance existing ETL processes, batch jobs, and data interfaces supporting legacy claims processing systems.
- Analyze and reverse-engineer legacy data feeds, file structures, transformation logic, and downstream dependencies.
- Design, develop, and implement new data integration pipelines to extract and process claims, provider, beneficiary, and other operational data from Claimscore.
- Utilize SQL, Python, ETL tools, REST APIs, and other integration technologies to develop reliable, scalable data processing solutions.
- Support parallel processing of legacy and Claimscore data, ensuring consistency and continuity across both platforms.
- Develop transformation and mapping logic to normalize and consolidate data from multiple source systems into established enterprise data models.
- Address differences in source schemas, identifiers, business rules, duplicate records, and overlapping datasets.
- Implement data reconciliation, validation, monitoring, exception handling, and automated recovery processes.
- Develop and support API-based integrations, including authentication, pagination, error handling, and processing of JSON/XML data.
- Perform unit testing, integration testing, and source-to-target validation to ensure data accuracy and completeness.
- Troubleshoot production integration issues and collaborate with application teams, architects, business stakeholders, and external vendors.
- Document technical specifications, data mappings, integration workflows, and operational support procedures.
Required Qualifications
- 5+ years of hands-on experience in ETL development, data engineering, or enterprise data integration.
- Advanced SQL skills, including complex queries, stored procedures, data transformations, and performance optimization.
- Strong programming and scripting experience with Python or comparable languages.
- Experience consuming and integrating REST APIs, web services, relational databases, and file-based data sources.
- Experience with enterprise ETL platforms such as Informatica, SSIS, DataStage, Talend, or equivalent technologies.
- Demonstrated ability to maintain legacy integrations while developing new data pipelines and modernization solutions.
- Experience mapping, transforming, reconciling, and consolidating data from multiple sources into standardized enterprise data models.
- Strong understanding of batch processing, data quality, error handling, logging, and automation.
- Excellent analytical, troubleshooting, and problem-solving skills with the ability to work independently.
Preferred Qualifications
- Healthcare claims processing experience, particularly Medicare claims.
- Experience integrating legacy/mainframe systems with modern platforms.
- Knowledge of claims, provider, beneficiary, and remittance data structures.
- Experience with Python-based data pipelines, API integration, and secure file transfers.
- Familiarity with enterprise data warehouses, cloud technologies, job scheduling, and data governance.
- Experience supporting parallel system operations, data migrations, and phased modernization initiatives.
_______________________________________________________
If you're looking for rewarding employment and a company that puts its employees first, we'd like to work with you. We're driven, people driven
Bhupesh Khurana
Senior Technical Recruiter
Email:
Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally; as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clients’ businesses forward.
Amerit Consulting provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.