Previous Job
Big Data and ETL Developer
Ref No.: 18-04892
Location: Plano, Texas
Position Type:Right to Hire
SOFTWARE ENGINEER - Big Data and Ab Initio ETL
Plano, TX
6+ month contract to hire

We are hiring a Software Engineer whose primary responsibilities will be to review and recommend data modelling approaches, develop Oracle PL/SQL stored processes, Ab Initio ETL, Unix scripting and Bigdata ETL processes (using Hadoop, HIVE, Spark) into automated/functional processes during sprints.

What You'll Do:
  • Use 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.
  • Create complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects, etc.
  • 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
  • Experience in leading technical projects in Development team

Skills/Experience You'll Need:
  • 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 on different platforms
  • Advanced hands on experience at Ab Initio ETL design and development including EME and BRE
  • BigData Hadoop fundamentals, consumption , ETL and Machine Learning knowledge/exposure
  • Advanced experience with Oracle SQL, PL/SQL, Data Analysis and Performance Tuning. Hands on experience of Tools like TOAD, SQL Developer, and SQL Loader.
  • Strong experience on database design, best architecture practices, normalization and dimensional modeling etc.
  • Strong experience working in Agile methodologies and SCRUM execution
  • Preferred experience with Bigdata technologies and tools such as Hadoop Cloudera/HortonWorks, HDFS, MapReduce, Spark, Big Data consumption tools (such as Pig, Hive, Impala), NoSQL databases (such as HBase, Cassandra, MongoDB)
  • 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.
  • 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