Serve as a key Technical resource in developing, configuring, coding, testing and debugging new software solutions. Design and develop ETL methodology using Informatica Power Center to create mappings, sessions and workflows for populating the data into dimensions, facts, and tables simultaneously from different source systems like SQL server, Oracle11g/10g, Flat files. Perform data modeling using ERWIN and Power Designer. Perform OLTP/OLAP system study, analysis and ER modeling. Perform data profiling and analysis using Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ). Develop PL/SQL and UNIX Shell/Perl Scripts to schedule sessions in Informatica. Write SQL, PL/SQL, TOAD, stored procedures, triggers and cursors to implement business rules and transformations. Will work in Manchester, CT and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.