Apply Now    

Software Engineer-(Ab Initio ETL and Bigdata Developer)

Req #: 170076569
Location: Plano, TX, US
Job Category: Technology
Job Description:
  • The Software Engineer is responsible for working on an Agile development team to determine the changes needed to the data model , databases along with the necessary ETL coding and implementation for regulatory reporting. Responsible for design and development of various ETL processing using Oracle PL/SQL, Ab Initio and Unix Shell scripting. Responsible for writing complex SQLs for data analysis and data profiling. Knowledge of database architecture/practices is essential. Experience with Business Intelligence (BI) tools such as Tableau and Bigdata querying & ETL tools is preferred. This is an individual contributor that may have team lead responsibilities for 1-4 people.

     Specific responsibilities/skills:
    • Advanced experience & demonstrated proficiency in all aspects of Ab Initio tool set to create graphs, using performance improvement components, parallel processing, graph tuning, single and multi-file processing, metadata processing using EME etc.
    • Significant experience & proficiency in all aspects of Oracle PL/SQL programming and data analysis, including Cursors, Ref-cursors, Oracle procedures/packages, Collections, Partitioned Tables, Triggers, Table Indexing. Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc.
    • Strong experience on database design, best architecture practices, normalization and dimensional modeling etc.
    • Experience working on Agile methodologies as developer.
    • Preferred experience with Bigdata technologies and tools such as Apache Hadoop/Cloudera/MapR/HortonWorks, HDFS, MapReduce, Spark, Big Data querying tools (such as Pig, Hive, Impala), NoSQL databases (such as HBase, Cassandra, MongoDB)
    • Preferred experience with Business Intelligence tools such as Tableau
    • Fundamentals and 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
    • 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
    • Apply innovation, creativity, and improvement to the development process
    • Problem-solving, keep abreast of new technologies
    • Serve as a process expert for a defined functional area, which includes: 
      • Managing key data sources & inputs
      • Planning and ensuring implementation of end state automation activities
      • Providing guidance for the design, development, and implementation of automated processes 
Required Qualifications:
  • Bachelors’ 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
  • Candidates must have advanced experience with Oracle SQL, PL/SQL, Data Analysis and Performance Tuning. Hands on experience of Tools like TOAD, SQL Developer, and SQL Loader.
  • Advanced hands on experience at Ab Initio ETL design and development including EME and BRE
  • Experience with BigData fundamentals, querying and ETL technologies
  • Working experience as Agile developer and good understanding of SDLC methodologies/guidelines
  • Experience at developing complex UNIX shell scripts
  • Experience with Subversion or similar source code versioning tools and coding standards
  • Experience with scheduling tool such as Control-M or similar tools
Preferred Qualifications:
  • 2-3 years of Mortgage/Banking/finance analytical support experience preferred, but not mandatory.
  • Experience with Talend ETL tool  
  • Experience with Tableau or Cognos BI tools
Apply Now    
Link for schema

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.