Previous Job
Ab Initio/ Oracle PL/SQL Developer
Ref No.: 16-00148
Location: lewisville, Texas
Position Type:Right to Hire
Experience Level: 5 Years
Start Date / End Date: 11/01/2016 to 11/30/2017
Roles and Responsibilities:
  • Significant experience & demonstrated proficiency in all aspects of database programming and analysis, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing.
  • Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc.
  • Experience on database design, best architecture practices, normalization and dimensional modeling etc.
  • Solid facilitation skills to gather the necessary (functional & technical) information to document and/or develop a strategic/tactical plan.
  • Able to properly document (functional & technical) source to target mappings, process flows, data flows, technical specification and unit test document
  • Design, develop and deploy business rules and requirement into PL/SQL and ETL code for data analysis, transformation, and cleansing.
  • Experienced in writing efficient and complex Ab Initio components such as graphs, parameters, transformations such as expression, filter, lookup, join, router, normalizer, partitions, update strategy etc.
  • Expert in Query optimization, Debugging, and Tuning for improving performance
  • Extensive experience in Unix Shell Scripting.
  • Work independently in the design, development, testing, implementation and maintenance of systems of moderate size/complexity with a fast turn-around Perform extensive business process analysis including data analysis and GAP analysis
  • Bachelor's degree in Computer Science, Engineering, Information Technology or related area
  • 5+ years' experience in Distributed Multi-tier Application Development, Database Design, Data processing, Data Warehouse and Support mainly with Oracle technology on different platforms 2-3 years of Mortgage/Banking/finance analytical support experience preferred, but not mandatory.