W-2 Jobs Portal

  • W-2 Open Positions Need to be Filled Immediately. Consultant must be on our company payroll, Corp-to-Corp (C2C) is not allowed.
Candidates encouraged to apply directly using this portal. We do not accept resumes from other company/ third-party recruiters

Job Overview

  • Job ID:

    J36993

  • Specialized Area:

    ETL

  • Job Title:

    ETL Developer

  • Location:

    Leawood,KS

  • Duration:

    8 Months

  • Domain Exposure:

    Healthcare, Banking & Finance, Telecom, IT/Software

  • Work Authorization:

    US Citizen, Green Card, OPT-EAD, CPT, H-1B,
    H4-EAD, L2-EAD, GC-EAD

  • Client:

    To Be Discussed Later

  • Employment Type:

    W-2 (Consultant must be on our company payroll. C2C is not allowed)




Job Description

REQUIREMENTS:


* 5+ years of demonstrated knowledge in Data warehousing concepts, architectures, design and dimensional modelling
* Minimum 4+ years of hands on experience with IBM InfoSphere DataStage Enterprise Parallel Edition (Version 11.5 or above)
* 5+ years of experience on SQL against relational databases preferably with MS SQL Server 2008 and above; Must be able to understand complex SQL queries and transform into optimized ETL Coding
* 5+ years in UNIX scripting, understanding of FTP standards/process and basic network principles
* 5+ years of automation experience using scheduling software
* 3+ years of experience in handling large XML files using XML stages/Pack to read and create XML files on a real time and batch processing mode
* 2+ years of experience in OBIA (Oracle Business Intelligence Applications) or HR/Finance modules of ERP systems or Informatica ETL development
* Strong knowledge of Datastage parallel frame work, Partitioning, Parameters/Sets and best practices for optimized coding
* Pioneer in data structures, mastered in data profiling, have solid understanding of data modelling
* Proven understanding of Hadoop Ecosystem
* Working knowledge of Hadoop components like HDFS, Hive, Pig, Sqoop, HBase, Spark, Oozie, Python and Impala
* Ability to interpret Data Model & mapping document, understand technical requirements, prepares Technical Design Document, Design/develop ETL Code, create unit test cases/data, perform unit testing and solves defects in a timely manner
* Supports for a successful project implementation and resolves production issues during project warranty and any future maintenance support
* IIS QualityStage is an advantage


Apply Now
Equal Opportunity Employer

ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract