KansasCityRecruiter Since 2001
the smart solution for Kansas City jobs

ETL Developer

Company: Analysts
Location: Kansas City
Posted on: February 24, 2021

Job Description:


  • Parallel Edition DS
  • Dimensional Modeling (which means they should have Kimball or Inman)
  • Quality Stage
  • Experience in one of the following: complex SQL writing, Data Analysis, DW Architecture, Netezza, Hadoop
  • Savvy communication skills
    Required Skills:-- Minimum 5+ years of hands on experience with IBM InfoSphere DataStage Enterprise Parallel Edition. (Version 9.1 or above). Position Description
  • This position will be responsible for the data integration application design, coding, testing, documentation and maintenance for complex data warehouse and database systems.
  • Provides ETL technical expertise, lead projects through all phases of SDLC, provides development support and serves as a subject matter expert for integrations involving data warehouse and transactional databases to meeting business requirements.
  • Has mastered the concepts of data warehousing data architecture, master data architecture, design, configuration, operation, security, and data integration tools.
    • Minimum 5+ years of hands on experience with IBM InfoSphere DataStage Enterprise Parallel Edition. (Version 11.5 or above).
    • Strong knowledge of DataStage parallel framework, Partitioning, Parameters/Sets and best practices for optimized coding.
    • 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.
    • 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.
    • 8+ years of demonstrated knowledge in Data warehousing concepts, architectures, design and dimensional modelling.
    • Proven understanding of Hadoop Ecosystem
    • Working knowledge of Hadoop components like HDFS, Hive, Pig, Sqoop, Hbase, Spark, Oozie, Python and Impala.
    • 5+ years in UNIX scripting, understanding of FTP standards/process and basic network principles.
    • 5+ years of automation experience using scheduling software.
    • 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.
    • Effectively communicate Oral & Written. Work across teams within and outside of IT including DAs, DBAs, QAs, PM and Business Users as necessary.
    • Under minimal supervision, takes ownership and responsibility on the assigned tasks and strive for completion within the timeline.
    • Must be a quick learner to adapt to Enterprise standards, best practices and critical processes.
    • IIS QualityStage is an advantage. .
    • IBM Information Services Director is a plus.
    • Working knowledge of Netezza is a plus
      • Project Management Expertise: Experience and working knowledge of "best practices" in developing and leading/managing projects to create solutions, plan, budget, and execute projects in support of customer objectives/goals. This includes the ability to work across the organization (Primarily Technology & Systems) to plan for the supporting project/activities needed to successful implement customer programs/projects.
      • Leadership: Willing to "take a position vs. managing a position"; ability to drive change within the organization; ability to build consensus/coalitions amongst diverse (or divergent) interests; acts with integrity; takes the initiative; exercises sound judgment; sets the example.
      • Analytical/Problem Solving: Intellectual capacity and ability to gather, sort and analyze data and then develop logical conclusions; critical thinking skills; familiar with problem solving tools/techniques and able to communicate options, conclusions, and recommendations to both the business and the technology teams.
      • Interpersonal/Communication: articulate and capable of conveying ideas clearly/concisely; sensitive to needs of the audience; ensures the customer, as well as service areas within Technology & Systems are kept informed of plans, status, and current problems/challenges; manages around internal politics; empathetic, good listener.
      • Champions quality of data in the warehouse:
      • maintain integrity of data in the warehouse, correcting any data problems
      • ensure data currency; design procedures to purge/archive old data
      • Works with Data Analyst on physical model designs for star schemas
      • Assess current technical architecture; estimate system capacity for near- and long-term processing requirements
      • Provides technical direction and training to other IT personnel
      • Mentors others through issues and if needed, facilitate resolution
      • Comprehends, and understands program/project strategy, roadmaps and timelines for execution
      • Takes the established projects and drives them to completion, on time and on budget meeting the customer's expectations and objectives
      • Assertively challenges questionable designs and/or assumptions and to critically evaluate project deliverables
      • Must be a constant learner. Staying up to date on industry knowledge and striving to learn about new and emerging technologies and trends in the Exhibition, Information Technology (IT) industries as well as business practices and trends (including regulatory and compliance requirements).
      • Experience and working knowledge of industry "best practices" related to data warehouse and database development.
      • Familiarity with technology product & service offerings by vendors providing products and services in the data warehouse and database space.
      • Stays abreast of emerging technologies, practices, architectures, etc. in order to understand their potential as future enabling technologies for business solutions
        Minimum Requirements
        • 2+ year's management of technical/support personnel.
        • 2+ years project management.
        • 7+ years' experience of successful data warehouse development.
        • Experience working in an enterprise data warehouse environment.
        • Experience managing software solution projects that have a budget of at least $250,000. This position requires candidates that are a US Citizen or Green Card Holder. At this time no Corp to Corp relationships will be considered for this opportunity. AIC is an Equal Opportunity Employer

Keywords: Analysts, Kansas City , ETL Developer, IT / Software / Systems , Kansas City, Kansas

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Field Service Technician - Kansas City, MO
Description: Job Description Riekes Equipment, an industry leader in material handling and warehouse solutions, continues to provide essential services to key industries in food, agricultural, and the supply chain. (more...)
Company: Riekes Equipment Co.
Location: Kansas City
Posted on: 03/6/2021

Entry Level Java Developer
Description: Revature is the fastest growing employer of emerging technology talent. We will hire over 300 new Entry Level Java Developers in the next 4 weeks. ONE DAY SOMEONE IS GOING TO ASK YOU WHERE YOU GOT YOUR (more...)
Company: Revature
Location: Lawrence
Posted on: 03/6/2021

Sales Executive Mobility*
Description: As a Sales Executive 1 - Mobility, you'll work with AT T's cutting-edge business products and services focusing on our mobility solutions. You'll focus on generating new sales revenue within a module (more...)
Company: AT&T
Location: Kansas City
Posted on: 03/5/2021

Junior Software Developer
Description: Revature is the fastest growing employer of emerging technology talent. We will hire over 300 new Junior Software Developers in the next 4 weeks.One day someone is going to ask you where you got your (more...)
Company: Revature
Location: Olathe
Posted on: 03/6/2021

C# Developer
Description: Syms Strategic Group SSG is seeking a talented C Developer. br br Location: All U.S. based locations may be considered. br br Department: Veterans Affairs br br Type: Full Time br br (more...)
Company: Syms Strategic Group, LLC (SSG)
Location: Leonardville
Posted on: 03/6/2021

Automotive Technician - Mobile
Description: Description: WHO WE AREWrench, Inc. is the fastest growing mobile mechanic service around and has an immediate opening for a Mobile Auto Mechanic. Join a dynamic, groundbreaking team who is changing the (more...)
Company: Wrench Inc
Location: Lawrence
Posted on: 03/6/2021

Sr. Software Architect
Description: What you'll do... At H R Block we are modernizing our software architecture which is generating a need for more talent. We are looking for problem-solving difference-makers to help us with new approaches, (more...)
Company: H&R Block
Location: Kansas City
Posted on: 03/6/2021

UI/UX Software Engineer
Description: Look for more than answers. Patients and Physicians rely on our diagnostic testing, information and services to help them make better healthcare decisions. These are often serious decisions with far reaching (more...)
Company: Quest Diagnostics
Location: Shawnee Mission
Posted on: 03/5/2021

Information Technology Specialist (25B)
Description: If you've ever considered a job in IT, become an Information Technology Specialist in the Army National Guard and expand your skills and experience with complex technologies. In this role, you will be (more...)
Company: Army National Guard
Location: Kansas City
Posted on: 03/5/2021

Senior Front End Developer
Description: Senior Front End Developer - Remote br br Smarter Thinking. Real Results. Technology consulting has been our story for over 14 years. Companies from all industries partner with us for our innovative (more...)
Company: Saggezza
Location: Kansas City
Posted on: 03/5/2021

Log In or Create An Account

Get the latest Kansas jobs by following @recnetKS on Twitter!

Kansas City RSS job feeds