Job Description :
Greeting Business Partners,

We have an excellent opportunity for ETL Developer (Power center The manager would like to interview ASAP. Below is the JD and please send candidates ASAP.

Please do not share profiles who feel uncomfortable sharing legal name, DOB, Copies of ID proof, Work authorization and Passport details (Must for H1B, EAD etc*

J.O#: 46425WAF

Position Title: ETL Developer (Power center)

Position Type: Contract

Contract Length: 8 months

Location: Danville, PA

Hourly Rate: Open (DOE)

Interview Process: 2 Skype Videos (both require coding exercises)

Job Description:

Required Skills:

· Informatica PowerCenter (4+ years)

· SQL Server Data Warehouse Experience

· Expert in writing, providing performance tuning and writing optimized SQL queries

· Linux Shell Scripting

Apex Systems is seeking an experienced Informatica ETL Developer for our direct client in Danville, PA. The ETL
Application Developer is responsible for the development and implementation of technical ETL solutions that connect various claims data systems to our SQL Server Data Warehouse. This role will leverage technical expertise in database applications, ETL processes, and automation in support of internal and external customer’s data exchange and integration needs.


· Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS, Informatica toolset (Power center , B2B with MFT)

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

· 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.

· Serve as mentoring resource for other developers.

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


· 4+ years as an ETL Developer or equivalent implementing technical solutions (extracts, middleware, stored
procedures, EDI, ETL packages

· Experience with SQL Server, Transact SQL (T-SQL) and SQL Server Integration Services (SSIS) and

· 3+ years’ experience with Informatica B2B Data Transformation, B2B Data Exchange, and PowerCenter.