Job Details

Email to Friend Save Back

Big Data and ETL Developer

PLANO-75026, TX, US
08/01/2018

-

Required Skills

Oracle SQL

Company

Infinity Consulting Solutions, Inc

Experience

5 to 7 Year(s)

Job Description

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