Ab Initio Developer

*Required Experience: 10+ years of experience* *The person applying should have a Real ID.* *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. *Position Description* · 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. *Detailed Skills Requirements* *Foundation 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 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. *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. Pay: Up to $65.00 per hour Work Location: In person