Informatica Developer

ID: JOB443

Job Info

Job Category



Job Type


Full Time

Experience Required


7 - 10 Years







Apply Email


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.


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



Client of MindsMapped Consulting



Posted Date : 2016-03-18

Visits : 307