• 
  IT IS 100 % On site position in Woodlawn
• 
  Selected candidate must be able to obtain and maintain a public trust clearance
• 
  Must be able to obtain and maintain a public trust. Contract requirement.
• 
  Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week

KEY
REQUIRED SKILLS:

• 
  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>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

Requirements

BASIC
QUALIFICATIONS:

• 
  Master's and 5+ years of experience, Bachelor's and 7+ years of experience or 13+ years in lieu of a degree
• 
  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.
• 
  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.

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.