Find Jobs
Find Jobs Near You – Available Work in Your Location
Skip to job details
IB
Integrated BI Solutions Inc
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 Integrated BI Solutions Inc Woodlawn, MD Job Details Contract $75 - $85 an hour 14 hours ago Qualifications Commercial use (data warehousing systems) Data Integration (Data management) Engineering development testing Requirements design Team leadership Software deployment Enterprise software Data quality assurance Software implementation UNIX Research Schema design Quality assurance experience within IT SQL System design for system development Technical solutions implementation Attention to detail Implementation (software development lifecycle) Continuous integration Scripting Schema mapping design Developing automated testing protocols System requirements definition Analysis (software development lifecycle) Project leadership Implementing IT solutions Developer tools Design (software development lifecycle) Dimensional modeling Full Job Description
OPPORTUNITY
Integrated BI Solutions Inc. (IBIS) is seeking a highly skilled and experienced Lead Ab Initio ETL Developer to join our data engineering team. In this pivotal role, you will be responsible for leading the design, building, and testing of complex ETL graphs and applications using the Ab Initio tool suite. You will provide technical guidance and mentorship to other developers while collaborating closely with cross-functional teams to deliver scalable, high-performance data integration solutions. This position requires a strong technical expert with excellent leadership and communication skills, capable of taking projects from requirements analysis through deployment and optimization. This is a permanent role expected to be onsite in Woodlawn, MD 5 days a week.PRIMARY RESPONSIBILITIES
- Strong 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.
- Expertise 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 including 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 staff.
- Ensure compliance with SSA security, privacy, and data management policies.
- Brief stakeholders using written or oral skills at appropriate technical level for audience.
- Provide guidance/support to other junior/mid-level developers.
MINIMUM QUALIFICATIONS
- Ability to obtain and maintain an SSA Public Trust clearance is required.
- Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field.
- 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.
- 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.
- Excellent communication and written skills.
DESIRED QUALIFICATIONS
- 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.