Previous Job
Previous
ETL Developer/Worcester/MA 6 mth+ contract
Ref No.: 18-01204
Location: Worcester, Massachusetts
Position Type:Contract
 No H1's Or OPT's
 
Job Duties Design and develop ETL processes to transform and load data between multiple system databases (Oracle, SQL Server, DB2 and flat files) Document ETL Technical Specifications. Interact with business analysts to finalize the requirements. Participate and coordinate in the high-level mapping or functional design specification walk-throughs performed by the system and business analysts. Translate the mapping and functional design requirements in to technical Mapping document which consists of the detailed mapping rules with respect the ETL process. Develop the UNIX shell script to perform the file validation of input source files to perform basic validations. Performing Gap Analysis, Optimization as needed. Perform QA and Code reviews   Requirements Should have strong knowledge and experience (5+ years) on ETL Power Center 9.x and 10.x (MANDATORY) Good knowledge on Data warehouse Architecture and Operational Data Store. Experience in Data Warehousing Concepts, OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modelling, Physical Modelling, Dimension Data Modelling. Strong Oracle, Sql Server and DB2 , SQL coding skills and experience in creating complex joins and stored procedures. Experience of Project life Cycle Design, Development, test and release Optimizing Informatica mappings/Session for better performance with Informatica best practices Good knowledge on resolving various technical issues with ETL mappings and in Unix scripts Experience in providing Support, enhancement and maintenance. Should be able to work independently with minimal supervision.