Hello,
Hope this email finds you well.
This is Farhan from Arreglo Consulting.
I have a position matching your profile.
Please let me know your interest ASAP.
- Position: SQL/SSIS Developer (Healthcare experience is must)
- Visa: USC/GC
- Duration: 6 months CTH
- Location: Ideally need to come to Nashville but remote for now
- Interview: test on SQL, filling info asked for below, vendor zoom call, phone/Skype with client and offer
Job Description:
Essential Job Functions:
- Develop, maintain and support automated ETL jobs and batch processes to facilitate data exchange with clients, vendors and business partners.
- Develop data integration using APIs to integrate third party solutions as needed.
- Support automated ETL jobs in production, troubleshoot errors/failures, performance issues and apply fixes as needed.
- Participate in data interface specifications discussions with business units, clients, vendors and help device a solution.
- Communicate with client or vendor’s technical teams to implement solutions, troubleshoot issues.
- Document and maintain data mappings and specifications of data extracts/files being exchanged with different entities.
- Perform analysis of data sources and processes to ensure data integrity, completeness and accuracy
- Participate in data warehouse initiatives with key business stakeholders by gathering and documenting key business definitions, measures, and standards
- Identify and facilitate implementation of improvement opportunities
- Facilitate requirements gathering from non-technical business personnel and suggest efficient reporting solutions based on requirements
- Document data flows, ETL processes, logic as flowcharts/ process diagrams.
- Work in an agile environment and provide regular updates on progress of projects.
- Perform other job-related duties as assigned
Qualifications
- Bachelor's degree in Computer Science, Management Information Systems, Finance, Healthcare Administration or other related field
- Advance level in T-SQL development – SPs, functions, views etc.
- Advance level in SSIS development
- Advance level in designing ETL/ELT processes using SQL, SSIS, C# to implement automated inbound/outbound file-based data exchange.
- Intermediate level proficiency in C#.Net or other programming language for developing code for API integration, implementing custom transformations in SSIS.
- 5+ years of hands on experience with developing TSQL code on MS SQL Server
- 5+ years of hands on experience with SSIS (SQL Server Integration Services)
- 2+ years of hands on experience with ascii X12, HL7, XML preferred.
- 2+ years of experience in the healthcare industry preferred.
| | |