ETL Developer



Apply Now

<< Return to Search Results

SQL Developer

Contract to hire


Brooksource is looking for a strong SQL Developer with expertise in the data space, specifically with Informatica ETL processes to join our Fortune 50 health insurance client. Someone looking to be a go-getter and data investigator will do well in this role.


·        Writes MS SQL and P-SQL (Oracle) code, to be able to build ETL processes using SQL Server Integration Services (SSIS) and Informatica 10.2.

·        Create reports using Microsoft Reporting Services (SSRS) and Power BI, experience in Tableau is preferred with limited guidance while ensuring following best practices.

·        Understanding of EDI files like 837 claim submits and 835 claim remits and be able to code them using B2Bi Solutions is a value add.

·        Partners with internal and/or external stakeholders to better understand business requirements.

·        Analyzes and classifies semi-complex change requests and identifies and documents possible system code enhancements.

·        Participates in developing application scope and objectives and preparing functional and/or technical specifications.

·        Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.

·        Follows the SDLC process to deploy code into multiple environments, to include deploying code into a Production environment.

·        Develops and performs system testing and fixes defects identified during testing and re-executes unit tests to validate results.

·        Understand testing best practices.

·        Participate in integrating activities with other IT departments for successful implementation and support of project efforts.

·        Develops a general understanding of how the work fits in to the larger project and identifies problems or issues in requirements.

·        Provides on call support and monitors the system for semi-complex issues as needed.

·        Facilitates small group design sessions or code reviews.

·        Follows and adheres to Agile methodologies.

Requirements –

  • 3 years of developing and writing queries with SQL
  • 2 years of Informatica experience
  • 1 year of working in a health insurance environment – preferably with claims
  • Go-getter mentality
  • Proactive in question asking
  • Strong experience working in a collaborative team environment
  • Understanding of Agile Methodologies

Brooksource provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, national origin, age, sex, citizenship, disability, genetic information, gender, sexual orientation, gender identity, marital status, amnesty or status as a covered veteran in accordance with applicable federal, state, and local laws.


Apply Now

Tagged as: Yes