Abinitio Developer

Position

ETL Developer (Ab Initio)

Client: TCS (Purple Drive Technologies LLC)

Cincinnati, OH

We are looking for an experienced ETL developer with strong expertise in Ab Initio to design, develop, and maintain data integration solutions on Hadoop and cloud platforms.

• 7+ years of IT experience predominantly in Data Integration/Data Warehouse area
• 6+ years of ETL design and development using Ab Initio
• Strong knowledge in Ab Initio MDH and DQ checks
• 2+ years of Data Integration project experience on Hadoop Platform, preferably Cloudera
• Experience in Ab Initio EME, GDE, parallelism techniques, Graphs using Data, Pipeline & Component parallelism
• Ability to design and build Ab Initio graphs (both continuous & batch) and Conduct>it Plans, and integrate with portfolio of Ab Initio softwares
• Complete understanding and analytical ability of Metadata Hub metamodel
• Build graphs interfacing with heterogeneous data sources - Oracle, Snowflake, Hadoop, Hive, AWS S3
• Parse XML, JSON & YAML documents including hierarchical models
• Build and implement data acquisition and transformation/curation requirements in a data lake or warehouse environment and demonstrate experience in leveraging various Ab Initio components
• Build Control Center Jobs and Schedules for process orchestration
• Build BRE rulesets for reformat, rollup & validation use cases
• Identify performance bottlenecks in graphs and optimize them
• Practice rigorous high code quality, automated testing, and engineering best practices; write reusable code components
• Unit test code thoroughly and troubleshoot issues in production environments
• Maintain and develop Extract, Transform, & Load (ETL) routines using Ab Initio
• Ensure Ab Initio code base is engineered to maintain functionality and development that adheres to performance optimization, interoperability standards and requirements, and compliance with client IT governance policies
• Build automation pipelines for Continuous Integration & Delivery (CI‑CD), leveraging Testing Framework & JUnit modules, integrating with Jenkins, JIRA and/or Service Now
• Successfully implement Ab Initio CDC (Change Data Capture) in a Data Integration/ETL project
• Demonstrate experience with Ab Initio components such as Rollup, Scan, join Partition by Key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, and others
• Excellent SQL, UNIX shell scripting, and performance tuning skills
• Design experience (mapping specifications, HLD, LLD), development (coding, unit testing) using Ab Initio
• Some Java development experience is nice to have
• Knowledge of Agile/Waterfall Development practices is required
• Must be able to work independently and support other junior developers as needed
• Keep abreast of Ab Initio best practices and new features to continuously improve development processes

• Mid‑Senior level

• Full‑time

• Business Development and Sales
• Software Development

Salary: $91,520.00 – $ (Cincinnati, OH) – 1 month ago