Develop, configure, code, test and debug new software solutions using Informatica and Database technologies. Design and develop ETL methodology using SQL Server Integration Services(SSIS) to create transformations and Packages for populating the data into dimensions, facts, and tables simultaneously from different source systems. Perform data profiling, extracting and loading data. Develop Parameterized, Ad-hoc and Caching reports. Create User Defined Hierarchies. Create Custom Measure groups (Calculated Members). Build dashboards with bar graphs, line charts, pie charts, Tree maps. Write TSQL SQL, PL/SQL, TOAD, stored procedures, triggers and cursors to implement business rules and transformations. Create Cluster and Non- Cluster Indexes. Develop Unix Shell Script and Batch Scripts to schedule and trigger the batch jobs. Code Versioning. Skills Required: Informatica, ETL, SSIS, SSAS, SSRS, Oracle, Hadoop, Greenplum, SQL Server, Tableau, Flat files, MSAccess, TSQL, VSS and SVN. Master’s degree in Science, Technology, or Engineering (any field) with 6 months of experience in job offered or related occupation is required. Work location: Manchester, CT and various unanticipated locations throughout the U.S.
Mail Resume to HR Dept., Cyma Systems, Inc., 360 Tolland Turnpike, Suite 2D, Manchester, CT 06042.