Gather and review requirements, analyze and translate functional specifications into technical specifications. Use Informatica as the ETL tool for extracting data from flat files (Excel or text files), Relational databases and transform the data according to the target database and perform loading. Design, develop, implement, test and support ETL processes for Data warehouse using Informatica Powercenter, Oracle 10g, SQL, PL/SQL, Teradata, and Unix. Integrate various data sources with relational databases like Oracle and SQL Server. Develop ETL procedures for moving data from source to target systems. Performance tuning of Informatica mappings/sessions. Design, develop and test Unix scripts.
Requires Master’s degree or its equivalent/foreign equivalent in Computer Information Systems, Computer Science, Engineering (any field), or closely related field and 1-year experience in the job offered or related technical/analytical role.
Requires (A). 1-year experience in ETL development using Informatica, SQL, Unix, and working with Relational databases Oracle, Teradata and Flat files as data sources; (B). Experience can be concurrent; (C). May require relocation to client sites within Indianapolis, IN MSA.