MUST BE US CITIZEN OR US PERMANENT RESIDENT. SELECTED CANDIDATES WILL BE SUBJECT TO A FEDERAL GOVERNMENT BACKGROUND INVESTIGATION. Duties: The Informatica Developer is responsible for the development of ETL (Extract, Transform and Load) code. The candidate will collaborate with client and integrator Project teams to design and develop ETL code to load large amounts of data from other client internal data sources to the subject system. Duties include: Job Duty 1 - Design/Develop ETL Interface using Informatica tool. In addition, implement an Informatica based ETL solution fulfilling stringent performance requirements. Job Duty 2 - Develop/Implement the coding of Informatica mappings for different stages of ETL. Move staging table to the target table. Job Duty 3 - Design, coding, unit testing of ETL packages, triggers, and stored procedures, views, SQL transactions Job Duty 4 - Understand and comply with development standards and SDLC to ensure consistency across the project. Job Duty 5 - Collaborate with Client SMEs, IBM team and other vendor teams. REQUIRED SKILLS: Please note these are the top technical skills that the Buyer feels a candidate MUST have. General knowledge of basic office software such as MS Office Suite as well as good communications skills are a given. * Strong PostGres SQL experience (2 years) * Experience with Informatica Power Center; SQL (2 years) * Strong experience with ETL development and process from diverse data sources (2 years) * Advanced experience with Informatica Power Exchange, Control-M * Experience with data modeling concepts * Experience in development, maintenance, and enhancement of Informatica Mappings, Work-flows, and processes (2 years) * Experience with Data Warehouse; Oracle; Linux; AIX Company Description: Tier One Technologies is a national technical consulting firm with its corporate headquarters located in the Pittsburgh, Pennsylvania metro area. Our niche is providing services to the Government Sector, including government prime contractors, with focus on Federal Civilian, Defense, Intelligence and Security segments. We offer comprehensive benefits including Paid Federal Holidays, Paid Time Off, Medical, Dental, Vision, Life, Short and Long-Term Disability Insurance as well as 401k plan.