Senior AbInitio ETL Developer

Ab Initio, AbInitio, CloudFront, Confluence, Data Modeling, Data quality, EC2, ETL, Jenkins, Oracle, PL / SQL, PostGreSQL, Python, S3, SQL, System Integration, System Integration Testing, Unit Test, Unix, User Acceptance Testing, Version Control, XML, change data capture, debugging, planning, product, shell scriptsDevelop, transforming, Ab Initio Code, Unix shell scripts, Autosys scripts, DataMart, CSV, SIT, UAT, GIT, Joins, Normalization, query optimization, JIRA, Agile Methodology, Route53, Lambda, Cloudwatch, Fargate, API Gateway, AWS ETL, RDS - PostGreSQL / S3
Full Time
Depends on Experience

Job Description

Job Title : Senior AbInitio ETL Developer

Duration: Long term

Type: Fulltime/Contract ( Remote until COVID )


Develop and Unit Test Ab Initio Code

Perform Maintenance and Support Activities for application

Develop /Update Unix shell scripts

Develop and maintain Autosys scripts

Architecting and supporting DataMart load processes

Designing processes that can extract/receive data from various heterogeneous source systems

Perform data cleansing and transforming the data according to business rules

Developing reusable frameworks for data extraction, loading and cleansing

Designing and building change data capture processes and updating the DataMart accordingly

Building capabilities to exchange the data with external partners in various formats (XML, CSV, Flat File, ..)

Support System Integration Testing (SIT) and User Acceptance Testing (UAT) as needed

CICD and Version Control Experience with Jenkins and GIT

Basic Python development skills


Database Concepts (SQL, Joins, Normalization)

Databases - Oracle, SQL Server

Database performance & Tuning/ query optimization

SQL (complex queries, store procedures, partitions, PL/SQL, cursors)

Data quality enforcement/ practices/ concepts


Prior experience with Agile Methodology and Dev Ops

JIRA (or other similar)

Confluence (or other similar)

Work with product owners and other development team members to determine new features and user stories needed in new/revised applications or large/complex development projects.

Participate in code reviews with peers and managers to ensure that each increment adheres to original vision as described in the user story and all standard resource libraries and architecture patterns as appropriate.

Serve as a technical lead for an Agile team and actively participate in all Agile ceremonies. Participate in all team ceremonies including planning, grooming, product demonstration and team retrospectives.

Mentor less experienced technical staff; may use high end development tools to assist or facilitate development process.

Data Modeling practices/ concepts


Experience working in an Agile Environment

Team Work


Problem Solving


Decision Making


Use of AWS technologies for building, deploying, and operating applications

Understanding of core AWS services  and basic AWS architecture best practices (S3,EBS,EC2,SQS/SNS,CloudFront,Route53,Lambda,Cloudwatch,ECS Fargate,API Gateway)

Proficiency in developing, deploying, and debugging cloud-based applications using AWS ETL native tools

Ability to use a CI/CD pipeline to deploy applications on AWS

Understanding of the use of containers in the development process

RDS - PostGreSQL / S3


AWS Certified Developer - Associate

AWS Solution Architect Associate

Dice Id : 90751012
Position Id : 7458622
Originally Posted : 4 months ago
Have a Job? Post it

Similar Positions

Ab Initio/AbInitio Developer
  • TechIntelli Solutions Inc
  • Atlanta, GA, USA
Full Stack Developer
  • Jobot
  • Atlanta, GA, USA
Ab Initio AWS Developer
  • Virtual Networx
  • Atlanta, GA, USA
Sr. Full Stack Developer
  • Genesis10
  • Atlanta, GA, USA
Senior Database Engineer
  • CoStar Realty Information, Inc
  • Atlanta, GA, USA
AWS Python Developer
  • Virtual Networx
  • Atlanta, GA, USA
Sr. Full Stack Developer Hybrid
  • IGT Technologies, Inc.
  • Atlanta, GA, USA
Sr. Site Reliability Engineer w/ .Net Application Support Experience
  • AGM Tech Solutions, LLC
  • Alpharetta, GA, USA
Senior DevOps/ AWS/ 100% REMOTE
  • Motion Recruitment
  • Gainesville, GA, USA
Staff Software Data Engineer
  • Talentiqo
  • Greenville, SC, USA