Informatica Developer

ID: JOB443


Job Info

Job Category

:   

Developers

Job Type

:   

Full Time

Experience Required

:   

7 - 10 Years

City

:   

Fairfax

State

:   

VA

Apply Email

:   

hr@mindsmapped.com



Job Description

The Senior ETL Developer will work within a team providing Data Warehouse and Business Intelligence services to our government customer, and will provide expert knowledge to the development team on Informatica tools. This position will work with varying data sources with different schemas and data elements to ultimately produce an effective and efficient Data Warehouse. Collaboration with the IT support and security teams is required to ensure technical architecture and data schemas comply with guidelines and restrictions specified for our customer’s environment.

Responsibilities:

Perform ETL failure recovery when needed.
Develop Informatica workflows to ingest data from multiple transactional systems according to documented logic and source-to-target mappings
Work directly with customer and System and Data Architects providing feedback and influencing outcomes
Migrate existing PL/SQL scripts to Informatica workflows for data ingest
Performance tune ETL processes to improve load run times
Apply Informatica tool to provide data cleansing, data quality assurance, and PII data masking for testing purposes
Support the program manager and system architect as an expert in ETL and Informatica technologies



Candidate Skill Set

Experience with Informatica PowerCenter 9.5
Experience with Informatica Data Quality and Informatica Dynamic Data Masking
Experience in Data Warehouse and Business Intelligence environment
Experience with Oracle 10/11g RDMS and associated tools and infrastructure
Strong SQL skills
At least 7 years overall experience in IT applications development or consulting related to IT applications development and data ingest processes
At least 7 years of hands on experience developing ETL in Informatica
At least 7 years in technical development and leadership roles on BI projects



Company Info

Organization

:   

Client of MindsMapped Consulting

Website

:   

www.mindsmapped.com

Posted Date : 2016-03-18

Visits : 164