Ab Initio Developer

Leidos•Baltimore, MD

1d•Onsite

About The Position

Leidos is seeking a highly skilled Ab Initio Developer to be part of the mission solution and help lead SSA’s Digital Modernization Strategy. Join one of our high performing teams responsible for building the next-generation enterprise APIs and modern responsive user interfaces, supporting the Social Security Administration (SSA) and their mission to meet the changing needs of the public, positively impacting at least 65 million American lives per month. We are a team of forward-looking professionals in need of a strong candidate with these key required skills: Strong experience with designing, developing, and maintaining Extract Transform Load (ETL) pipelines and data integration solutions using the Ab Initio tools suite. Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week. If this sounds like a mission you want to be a part of, keep reading! TEAM CULTURE Your passion and values might be a good fit for our teams if you answer “yes” to the following questions: Are you looking for a company that puts employees first, with a focus on career, flexibility, and well-being? Do you enjoy collaborating with colleagues and teammates and believe that the best ideas are fostered in an inclusive environment? Are you searching for a team with a strong sense of ownership, urgency, and drive for daily mission success? Are you comfortable with proactive outward communication and technical leadership? Do you enjoy being a catalyst, solving complex problems, and providing innovative solutions? Do you have the flexibility, creativity, and resilience to pivot the mission for success? Do you have the courage to make tough ethical decisions with pride, transparency, and respect? MENTORSHIP & CAREER GROWTH Our teams are dedicated to supporting new team members in an environment that celebrates knowledge sharing and mentorship. Experienced team members will be assigned to new hires for one-on-one mentoring, collaborative reviews, and coaching on customer engagement to help each new hire successfully onboard and demonstrate their skills. Projects and tasks are assigned in a way that leverages your strengths and will help you further develop your skillset. DAY TO DAY RESPONSIBILITIES Every position we take is more rewarding when you know the why behind it. Know your work makes a difference to support those who need it most. If your passion is enabling life changing service to those around, you this is the place for you. Find you passion in a team environment where all members are valued regardless of contractor or employee status. Find your “Why” with us and take your place in our Leidos Family!! 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

Strong experience with designing, developing, and maintaining Extract Transform Load (ETL) pipelines and data integration solutions using the Ab Initio tools suite.
Selected candidate must be willing to work on-site in Woodlawn, MD 5 days a week.
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.
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.
Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field. Additional years of experience may be substituted in lieu of degree. Masters or Doctorate degree may substitute for required experience
10+ years as a software developer with Ab Initio experience.
Must be able to obtain and maintain a Public Trust. Contract requirement.

Nice To Haves

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

Responsibilities

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