Job Duties: Responsible for requirements gathering, data analysis, design, development and deployment of scalable Enterprise Data Warehouse (EDW) applications on Unix and Windows. Prepare design and functional specifications (HLD, LLD) and implement required features as per specifications. Perform Erwin data modeling and design data marts and cubes. Perform database design and development and create complex procedures using PL/SQL. Perform design and development of complex ETL mappings and perform ETL development. Perform performance tuning of SQL, ETL jobs and applications. Coordinate with team members to perform database management, governance and quality. Perform data replication and data migrations. Perform Data Integration and Synchronization using Oracle Data Integrator. Create Unix Shell scripts to help stress analysis tasks. Perform Database Upgrade by applying required software updates and patches. Ensure security, reliability, availability and scalability. Will work on Erwin data modeling, Oracle, EDW, OLTP, ETL, SQL, PL/SQL, ODI, Scripting languages, Oracle Golden Gate on UNIX and windows. Will work in Rocky Hill, CT and/or various client sites throughout the U.S. Must be willing to travel and/or relocate.