Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
D
Dice.com
Ab Initio ETL Developer
Career Insights for ETL Developer
See where this job fits in the broader career landscape. Knowing your career path helps you see what's possible from here.
Scorecard
Based on Maryland data
Review key factors to help you decide if this role fits your goals. How is this calculated?
What they do
An ETL Developer develops, tests and maintains the process of data extraction, transformation and loading (ETL), a data warehousing process used for pull data out of source systems and load them into a data warehouse solution.
$110,520 / year median in Maryland
-19% projected decline
Job Description
Ab Initio ETL Developer
Skills
Position DescriptionStrong experience in design, building and testing graphs and ETL applications using Ab Initio 4. Familiarity with the Ab Initio tool suite and Unix/Linux environments.
Strong experience in enterprise-complexity ETL solutions using Ab-initio suite including products such as GDE;Co-Operating System, Express; IT, Data Quality Environment (DQE), Continuous Flows, Amazon S3 utilities.
Strong knowledge of Ab Initio lifecycle analysis, designs, implementation, and code migration.
Design ETL Framework for an audit and data reconciliation to manage batch and real time interfaces.
Develop ETL jobs for automation, monitoring and responsible for job performance optimization using ETL development tools or custom developed procedures.
Strong experience with SQL, mapping, and integration of relational databases such as DB2, Microsoft SQL Server, PostgreSQL, and Greenplum.
Experience automating the loading of data from multiple sources into BI/MI systems.
Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.
Provide technical leadership and guidance to project teams and stakeholders.
Collaborate with cross-functional teams to gather requirements and deliver effective search features.
Prepare and maintain comprehensive technical documentation and deliver knowledge transfer sessions to SSA staff.
Ensure compliance with SSA security, privacy, and data management policies.
Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
Provide guidance/support to other junior/mid-level developers.
All other duties as assigned or directed.
Detailed Skills RequirementsFoundation for Success (Basic Qualifications)Bachelor''s Degree in Computer Science, Mathematics, Engineering or a related field.
Must be able to obtain and maintain a Public Trust. Contract requirement.
Factors To Help You Shine (Required Skills)?
Experience with data warehousing designs/concepts such as star and snowflake schemas.
Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
Excellent communication and written skills.
Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
Prior experience working in a federal agency or public sector environment.
Ability to independently research problems and provide solutions.
How To Stand Out From The Crowd (Desired Skills)?Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
Experience with data warehousing designs/concepts such as star and snowflake schemas.
Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
Experience with modern development software, tools, and methodologies.
Experience working on Agile projects and understanding Agile terminology.
Employers have access to artificial intelligence language tools ("AI") that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Ab Initio
- GDE
- Co-Operating System
- Express>IT
- DQE
- Continuous Flows
- ETL
- Data Integration
- Data Warehouse
- SQL
- Linux
- Unix
- Shell Scripting
- DB2
- SQL Server
- PostgreSQL
- Greenplum
- Amazon S3
- Data Migration
- ETL Automation
- ETL Performance Optimization
- Star Schema
- Snowflake Schema
- BI/MI
- Data Reconciliation
- Audit Framework
- CDC
- Batch Processing
- Real-Time Data Integration
- Data Quality
- Data Profiling
- Informatica
- Informatica MDM
- IICS
- Talend
- Snowflake
- Oracle
- Teradata
- Kafka
- Python
REST API
- SOAP
- JSON
- XML
- Git
- Azure DevOps
- Agile
- Technical Leadership
- Performance Tuning
- Federal/Government Experience
- Public Trust
- Ab Initio
- GDE
- Co-Operating System
- Express>IT
- DQE
- Continuous Flows
- ETL
- Data Integration
- Data Warehouse
- SQL
- Linux
- Unix
- Shell Scripting
- DB2
- SQL Server
- PostgreSQL
- Greenplum
- Amazon S3
- Data Migration
- ETL Automation
- ETL Performance Optimization
- Star Schema
- Snowflake Schema
- BI/MI
- Data Reconciliation
- Audit Framework
- CDC
- Batch Processing
- Real-Time Data Integration
- Data Quality
- Data Profiling
- Informatica
- Informatica MDM
- IICS
- Talend
- Snowflake
- Oracle
- Teradata
- Kafka
- Python
REST API
- SOAP
- JSON
- XML
- Git
- Azure DevOps
- Agile
- Technical Leadership
- Performance Tuning
- Federal/Government Experience
- Public Trust
SummaryTitle:
Senior Ab Initio ETL DeveloperLocation:
Woodlawn, MD- Onsite 5
Days/WeekDuration:
ContractInterview:
1 Video Interview + 1Onsite InterviewDescription:
Key Required SkillsStrong experience with designing, developing, and maintaining Extract Transform Load (ETL) pipelines and data integration solutions using the Ab Initio tools suite.Position DescriptionStrong experience in design, building and testing graphs and ETL applications using Ab Initio 4. Familiarity with the Ab Initio tool suite and Unix/Linux environments.
Strong experience in enterprise-complexity ETL solutions using Ab-initio suite including products such as GDE;Co-Operating System, Express; IT, Data Quality Environment (DQE), Continuous Flows, Amazon S3 utilities.
Strong knowledge of Ab Initio lifecycle analysis, designs, implementation, and code migration.
Design ETL Framework for an audit and data reconciliation to manage batch and real time interfaces.
Develop ETL jobs for automation, monitoring and responsible for job performance optimization using ETL development tools or custom developed procedures.
Strong experience with SQL, mapping, and integration of relational databases such as DB2, Microsoft SQL Server, PostgreSQL, and Greenplum.
Experience automating the loading of data from multiple sources into BI/MI systems.
Working knowledge with analyzing and developing optimal code to maintain high performance for processing large volumes of data.
Provide technical leadership and guidance to project teams and stakeholders.
Collaborate with cross-functional teams to gather requirements and deliver effective search features.
Prepare and maintain comprehensive technical documentation and deliver knowledge transfer sessions to SSA staff.
Ensure compliance with SSA security, privacy, and data management policies.
Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for audience.
Provide guidance/support to other junior/mid-level developers.
All other duties as assigned or directed.
Detailed Skills RequirementsFoundation for Success (Basic Qualifications)Bachelor''s Degree in Computer Science, Mathematics, Engineering or a related field.
Must be able to obtain and maintain a Public Trust. Contract requirement.
Factors To Help You Shine (Required Skills)?
- Selected candidate must be able to obtain and maintain a public trust clearance
- Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week
- Master''s and 5+ years of experience, Bachelor''s and 7+ years of experience or 13+ years in lieu of a degree
- Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
Experience with data warehousing designs/concepts such as star and snowflake schemas.
Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
Excellent communication and written skills.
Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
Prior experience working in a federal agency or public sector environment.
Ability to independently research problems and provide solutions.
How To Stand Out From The Crowd (Desired Skills)?Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
Experience with data warehousing designs/concepts such as star and snowflake schemas.
Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
Experience with modern development software, tools, and methodologies.
Experience working on Agile projects and understanding Agile terminology.
Employers have access to artificial intelligence language tools ("AI") that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.