ETL Developer w/ Oracle/SQL & PL/SQL

About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in implementation activities and collaborate in new ways to meet client needs. We provide excellent benefits such as Medical, Dental, Vision a fun company to work Job description: Bachelor's degree 6 - 10 years of IT development experience 6 or more years of SQL development Basic and Advanced (tuning, Analytic functions, ability to convert simple PL/SQL logic into SQL) 6 or more years of Oracle PL/SQL development Basic (stored procedure, packages, functions, ref cursors, dynamic SQLs etc., dynamic PL/SQL) Advanced (Table partition management automation, Table functions, Calling external programs, experience with Oracle built in utility programs) 4 or more years of Data modeling 4 or more years of ETL development (Using an ETL tool is not mandatory) 2 or more years of Unix/Windows shell scripting 6 or more years of Oracle DB client tools like Toad, SQL Plus etc. Preferred Skills Health Care domain experience Experience with Oracle configuration to add HS services, to be able to consume Web Services, to send emails. Other programming languages T-SQL Java, J2EE, Spring Python, Django Java Script, HTML and CSS JSON, XML experience Data Visualization tools such as Tableau Big Data HDFS, Map/Reduce etc. Experience using Machine Learning algorithms