Position :Senior ETL Informatica DeveloperLocation :100% RemoteDuration :Full TimeClient :FederalMust have skills :An active MBI clearance with the IRS is required and considered mandatory.At least 9years relevant work experience in IT industry.At least 5years of experience with Extract, Transform and Loads in Informatica softwareStrong expertise in ETL Informatica Power Center to develop and enhance ETLs from various sources.Proven experience assessing clients workloads and technology landscape for Cloud suitability, develop business case and Cloud adoption roadmapMust be very strong in Creating new Informatica mappings, transitioning other ETLs to new Informatica mappings, or modifying existing mappings.Should have experience with trouble-shooting Informatica session failures and the ability to performance tune mappings.Expertise in Data modelling, BI tool and IDQ experience is a plus but not required.Data warehousing, Data modeling, Data integration, Data Migration, ETL process and Business IntelligenceData Modeling design, analyze and implement - conceptual, logical, and physical data model, Data conversion, Data integration and Data Mining specialization in the area of Data Warehouse and Business IntelligenceResponsible for installing, configuring, developing, support and maintenance of the BI APPSDevelops ETL's using Informatica to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systemsDesigned schema using KPIs, Fact, Dimensions, Physical, Logical, Alias and Extension tablesBuilt Business Model and established relationships & Foreign Keys (Physical & Logical) between tablesCreates LDAP authentication to enable Single-Sign on for Users in Development environment leveraging Analytics RepositoryUse Informatica Mapping Designer to create / update mapping using different transformations required to move data into data warehouseStrong knowledge in Power Exchange Data Warehouse, Development Extraction, ETL, Data Integration Analytics. Experience: 5 years required