Ab Initio Developer

Ab Initio Developer
Baltimore, MD, C2C or W2 - Must be on-site five days a week
Any visa fine

Description of Work:
* Strong experience with designing, developing, and maintaining Extract Transform Load (ETL) pipelines and data 
integration solutions using the Ab Initio tools suite. 
* 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.
* Strong experience in enterprise-complexity ETL solutions using Ab-initio suite including products such as GDE>CoOperating 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.
Basic Qualifications: Minimum knowledge, skills, abilities needed.
* Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field. 
* Masters or Doctorate degree may substitute for required experience
* 10+ years as a software developer with Ab Initio experience 
* 8+ years of experience on an Agile development team, preferable Scaled Agile Framework (SAFe)
* 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.
* Excellent communication and written skills.
* Detail oriented and committed to consistently completing repetitive production-like tasks on-time