ETL/SQL/SQL/SSIS/Informatica

Position : ETL Developer

Location : Remote

Term : 6 Mo.

Job Description :

The Application Developer develops and implements technical solutions. This role leverages technical expertise in database applications, ETL processes, and automation in support of internal and external customer's data exchange and integration needs.

Responsibilities :

Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica, and .NET technologies.

Requests include custom flat files, EDI, user applications, and a significant focus on healthcare encounters and HIPAA X12 transactions : 837, 999, 277, 835.

Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems.

Research, troubleshoot, and resolve data issues impacting extract delivery.

Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.

Collaborate on the definition, development, and maintenance of standards and processes.

Drive continuous improvement and automation in BI solutions and processes.

Serve as mentoring resource for other developers.

Support our goals and objectives by working closely with management team to deliver value to the business.

Other duties as needed or required.

Required :

BS degree in Business, Computer Science, Engineering, Information Systems or related field (or equivalent experience).

4 years as a Developer, Data Analyst, or equivalent implementing technical solutions (extracts, middleware, stored procedures, EDI, ETL packages).

Experience with SQL Server,

Transact SQL and SQL Server Integration Services (SSIS), C#, XML, and Informatica.

Managed file transfer automation experience : FTP, SFTP, PGP.

Expert knowledge of relational database applications and data query protocols (MS Access, SQL Server, Structured Query Language, SQL Reporting Services).

Demonstrated ability to drive to deadlines, balancing multiple priorities, and ensuring quality standards.

Excellent analytical, problem-solving, and innovative thinking skills.

Required Skills : ETL Developer SQL / TSQL / SSIS FTP / SFTP RDB applications and data query

Basic Qualification :

Additional Skills :

Background Check : Yes

Drug Screen : Yes

Notes :

Selling points for candidate :

Project Verification Info :

Candidate must be your W2 Employee : No

Exclusive to Apex : No

Face to face interview required : No

Candidate must be local : No

Candidate must be authorized to work without sponsorship : : No

Interview times set : : No

Type of project : Development / Engineering

Master Job Title : Dev : SQL Server Database

Branch Code : Boston