Apply on Employer Site

Akkodis Group Nordics · 1 day ago

Ab Initio ETL Developer

Cincinnati, OH

Full-time

Onsite

Senior Level

$45.45/hr - $60.61/hr

7+ years exp

Akkodis is seeking an Ab Initio ETL Developer for a Contract job with a client in Cincinnati, OH. The ideal candidate must have strong experience in Ab Initio ETL design and development, data integration on Hadoop platforms, and excellent SQL and UNIX scripting skills.

Embedded SystemsSoftware

Responsibilities

Design and develop ETL solutions using Ab Initio software suite (Co>Op, EME, BRE, Conduct>It, Express>It, Metadata>Hub, Query>It, Control>Center)

Build Ab Initio graphs (continuous & batch), Conduct>It plans, and integrate with portfolio of Ab Initio tools

Implement data acquisition and transformation requirements in data lake or warehouse environments

Configure and optimize Ab Initio components such as Rollup, Scan, Join, Partition by Key, Gather, Merge, Lookup, etc

Oversee data integration projects on Hadoop platforms (Cloudera, Hive) and interface with heterogeneous data sources (Oracle, Snowflake, AWS S3)

Parse XML, JSON, and YAML documents including hierarchical models

Build Control Center jobs and schedules for process orchestration and BRE rulesets for validation use cases

Qualification

Ab Initio ETLHadoop platformsSQLUNIX scriptingData integrationData WarehouseXML parsingJSON parsingYAML parsingAgile methodologiesWaterfall methodologiesDb2OracleMySQLTeradataMongoDB