ETL Developers (Informatica)

Description

Description Confer user needs with business system analysts and other architects to develop new software or enhance existing applications which mainly involve addition of features or correcting old errors. He will be involved in projects which are mainly for our Data Warehouse (DW) and Operational Data Store (ODS).
Design the optimal coding methodologies which includes deciding any ETL tool like Informatica Power Center or languages like PL/SQL in Oracle and UNIX shell scripts to support the implementation strategy while considering feasibility and cost constraints. While handling files, he will design and code the Secure File Transfer Protocol (SFTP).
Design and develop Oracle database components with applying proper indexes and partitions in the table for better performance in data retrieval. He will also design the EntityRelationship between the tables being created.
Develop complex to highly complex data ETL code using one or more tools like Informatica Power Center and multiple languages like PL/SQL, SQL and UNIX scripting to manipulate and store data per system capabilities and requirements. He will also apply various performance tuning methods to load the data in least time possible.
Using CISCO Sysadmiral, he will schedule all the codes to work in unison and in a scheduled manner
Perform unit testing and code reviews to ensure the user requirements and design methods are adhered
Move the code in multiple controlled environments and perform Integration testing for the whole application
Monitor and support the developed applications and software and provide necessary solutions per turnaround time in the Service Level Agreements.