Adaptive Solutions Group is a premier provider of information technology personnel. We provide a variety of technical professionals available for contract, contract to hire, or direct placement positions to companies in and around the St. Louis, Kansas City, and Denver Areas.
We are currently looking for an ETL Developer to join our team.
Execution of the custom ETL for Custom EDW, MDM, data integrations, and Oracle Financials & Human Resources data delivery.
Data Integration relating to architecture, standards, design, and processes to insure enterprise delivery and standardization of all ETL related development.
Direct supervision of assigned project resources (lead business/technical analysts, developers, testers, etc.), as well as coordinating the activities of supporting team members.
Work with partners and the business to continually research and develop both technical and business knowledge, leveraging research with the business to understand and become leaders in any space innovation can lead to an increased and optimized delivery model.
Bachelor’ s degree in Computer Science, Business Administration, Engineering (Information Technology focus)
7+ years of hands on experience with IBM InfoSphere DataStage Enterprise Parallel Edition. (Version 11.5 or above).
Strong knowledge of DataStage parallel frame work, 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.
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.
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 DataModel & 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
Adaptive Solutions Group is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, and veteran or disability status.
Adaptive Solutions Group offers a competitive compensation and benefits package that includes medical, dental, STD/LTD, life insurance coverage, 401k, paid vacation and holidays.