Act as 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 Tableau, 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, extracting and loading data using technologies like Hadoop, Informatica Big Data, Informatica Data Quality (IDQ) and Informatica Data Explorer(IDE). 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.