Vertex Group
Schaumburg, IL
Post Resume to
View Contact Details &
Apply for Job
Job Description :
Title: ETL Developer

Location: Libertyville, IL

Duration: Long term; ongoing



Interview: Phone screen followed by face to face



What is most important, per the manager:

Informatica Power Center BDM Tool which is a big data tool they use in their data lake which will be ready soon. so they use Hadoop to create hive tables and structures and then use BDM tool to load data up and could use Python to do this too but prefers BDM experience. ETL Workflow mappings in Datawarehouse, dimension tables type 2. Should have experience with Oracle database. so must have ETL experience in a Datawarehouse.



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 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 Entity-Relationship 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.
             

Similar Jobs you may be interested in ..