Job Description :
VDart We are a Global Information Technology Services & Workforce Solutions firm headquartered out of Atlanta, GA with presence in US, Canada, MX, UK, Belgium, Japan & India. Founded in 2007, Our team of over 2550+ professionals continually create impact for our customers worldwide in solving complex technology challenges with cutting edge technologies. We specialize in providing the Fortune 1000 companies, niche hard to find skills in technologies including Social, Mobile, Big Data Analytics, Data Sciences, Cyber Security, IoT, Cloud, Machine Learning, and Artificial Intelligence. With delivery centers in the UK, Mexico, Canada, and India, we provide global workforce solutions to our customers covering EMEA, APAC & Americas. VDart is an award-winning organization recognized by Inc 5000 Hall of Fame; Atlanta Business Chronicle*s Fastest Growing Companies; NMSDC*s National Supplier of the Year; Ernst & Young*s Regional Entrepreneur of the Year and more. Role: Datawarehouse Analyst with Oracle PL/SQL Location: Houston, TX Duration: Contract Design, develop, test, maintain, and support batch applications using Oracle PL/SQL for Retail Commissions and Amortization. Essential Duties/Responsibilities: Develop Oracle PL/SQL packages, stored procedures, functions, objects, tables, views, synonyms based on requirements. Unit test, System test, Integration test, and Parallel test of the Oracle PL/SQL code. Optimize code by following performance tuning techniques considering limitations of current environment. Use Oracle Analytical functions, merge statements, with clause, oracle partitioning, job logging, exception handling, performance tuning and so on in the Oracle PL/SQL code. Use analytics skills to troubleshoot and resolve problems quickly Work with Team Lead and other members of the Commissions IT team to understand requirements, identify source data, understand the source tables and relationships, adhere to consistent coding standards, do code reviews, and provide daily status updates. Work with the Commissions Project team to understand the reporting requirements for each workstream and build, test, and UAT according to their expectations. Work effectively in a team environment. Develop strong working relationship with members of Commissions IT team, Commissions Project team, Project Management team, and Business. Get familiarized with the ServiceNow ticketing system for opening, handling, and closing tickets and change requests. Experienced in any source code versioning tool Follow SOX procedures for code deployment. Create Contro M job documents and work with Control M to get them created and scheduled. Monitor batch processes daily/weekly/monthly and resolve job failures as quickly as possible. Work with ControlM group on re-run/re-start instructions. Willingness to perform this off hours during weekdays and weekends. Provide production support of the application and satisfy requests for data updates, ad-hoc reports or minor enhancements. Communicate status and escalate issues or delays that would impact deadline as early in the process as possible. Education: Bachelor's degree in computer science, software engineering or relevant business discipline from an accredited four-year college or university or equivalent work experience. Experience: Experience including but not limited to 15+ years of experience in Software development 10+ years of experience in Oracle 10g or 11g 10+ years of experience in Oracle PL/SQL development 3+ years of experience in a Data Warehouse environment Strong Analytical skills Troubleshooting skills Team Player Additional skills: Flexibility, Dedication, Consistency, Integrity, and Enthusiasm a must. Excellent verbal and written communication skills are required in order to interact with other team members, Team Lead, End user, Business, Project Manager, and other teams Skills: (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) OR (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) OR (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) OR (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) OR (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) OR (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) OR (Datawarehousing AND Oracle AND "PL/SQL" AND Control M) If your skills match our requirements, share your resume to . Be sure to reference the job number and title in the subject line. Referral Program: Ask our recruiting team about how you can be a part of our referral program. If you refer a candidate with this background and if the candidate accepts the role our team pays a generous referral. We are keen on networking and establishing a long-term, mutually beneficial partnership with you. We are Equal Employment Opportunity Employer. VDart Inc Alpharetta, GA Follow us on Twitter for the hottest positions: @VDart_Jobs Follow us on Twitter: @vdartinc