Contact Us Login Home
IntellecTechs

Founded by Veterans in Hampton Roads

Company Name:
C2 Essentials Inc
Approximate Salary:
Not Specified
Location:
Herndon, Virginia
Country:
United States
Industry:
Information Technology
Position type:
Full Time
Experience level:
5 - 8 years
Education level:
Bachelor's Degree
Contact:
Renuka Nair
Email:
renukan@c2essentials.com
ID
12950
Phone:
703-444-0096

Informatica Developer

Our client is a recognized Information Technology solutions provider. Founded in 1998 and based in Reston, Virginia, it is a CMMI Level 3 Certified company with an established reputation for excellence and on-time delivery with a consistently high customer satisfaction rating from its Federal Government and private consulting contracts.

They are currently seeking a full-time Informatica Developer in Herndon, VA.

JOB DESCRIPTION

Our client is currently conducting a search for a professional and experienced Informatica Developer to join their team.

Responsibilities include:

• Develop data profiling and quality assessment processes. • Develop data filtering, transformation and loading requirements. • Determine appropriate translations between source data and target databases. • Capture metadata as it pertains to sources and targets. • Load and transform data from data sources into target databases. • Design and implement appropriate error handling procedures. • Develop project, documentation and storage standards in conjunction with data architects. • Monitor performance, troubleshoot and tune ETL processes as appropriate. • Develop ETL workflows using Informatica for periodic data loads from source to target databases. • Validate and verify the data in the target databases.

REQUIRED SKILLS AND EXPERIENCE

• Minimum of  7+ years' experience in the architecture, design and development of ETL programs using Informatica Power Center tools. • Expert knowledge of Informatica version 8.5 and above. • Experience working with large scale enterprise data warehouse  comprising of 10+ TB of data. • Knowledge of reporting tools like Business Objects or OBIEE a plus. • Minimum 2 full lifecycle project experience with small development groups, e.g., leading ground up development of Informatica standards in one or more previous projects. • Demonstrated ability to navigate through organizational and technical uncertainty. • Mastery of Unix concepts and commands, including process management, directory structures, file permissions and editors. • Solid background in Oracle database 9i, 10g or 11g preferably in Exadata environment with a focus on manipulating large volume data set. • Stored procedure development experience. • Solid experience building SQL queries, including creating sub-queries, minus/union, and inline queries and performance tuning of SQL in Oracle/Exadata environment. • Fluency with business concepts related to relational and dimensional data models. • Excellent oral and written communication skills. • BA/BS in computer science or equivalent experience. • Experience with large scale database application like Exadata would be a plus. • Must be able to obtain a CBP Full BI (Customs Border Protection Full Background Investigation).

REQUIRED SECURITY CLEARANCE

• US Citizenship status and Active DOD Secret Clearance (preferred), must successfully complete the government’s security process (required).

Please Apply Online – https://careers-niksoft.icims.com/jobs/1411/informatica-developer/job

EOE M/F/Disability/Vet

Our Client will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information.

Options