MI ETL Analyst (Closed)

Description of Work:

• Provide development support to the government client to enable design, development, and implementation of web-based enterprise software solutions following the Agile lifecycle.
• Participate on enterprise projects that require migration strategies using web-based technologies and relational databases across multiple platforms.
• Participate in the full life cycle of an agile project, design and develop user interfaces/applications, and conduct testing.
• Understands the business problem statement, user scenarios, and technical constraints.
• Plan for and conduct implementation activities.
• Participate in planning, retrospectives, demos and daily stand-ups.
• Continuously develops knowledge and skills on pertinent systems.
• Perform thorough unit and functional testing of the code to ensure high quality bug free code.
• Provide weekly and monthly status to the management.
• Demonstrate strong oral and written communication skills, with the ability to communicate technical topics to management and non-technical audiences, as well as interface with the customer on a daily basis.
• Become knowledgeable on the Disability process, ensure understanding of the systems and application processes to be able to execute that role in an effective manner.

Basic Qualifications:

Minimum knowledge, skills, abilities needed.

• Bachelor’s Degree and 7 years of relevant work experience; Master’s Degree and 5 years of relevant experience; or a minimum of 11 years of relevant work experience in lieu of a degree.
• Minimum of 5 years of experience working in various SDLC frameworks (e.g. Agile, Waterfall) as a Systems Analyst to elicit and document requirements and technical specifications including User Stories, Technical Stories, Detailed Functional Requirements, Detailed Design Specifications, etc.
• Minimum of 3 years of experience working with relational databases such as DB2, including hands on experience with developing SQL scripts to generate queries and compare tables within the database.
• Minimum of 2 years of experience working on BI development projects using tools such as WebFOCUS 8.
• Minimum of 2 years of experience supporting User Interface and database manual validation activities including documenting test plans and test scenarios, identifying/creating test data, executing test cases/test scenarios, and identifying/documenting defects.
• Minimum of 2 years of experience in creating Data Transformation Rules.
• Strong oral and written communication skills, with the ability to communicate technical topics to management and non-technical audiences, as well as interface with the customer on a daily basis.
• Minimum of 1 year experience as a self-starter who can work with a large and diverse team of business, management and IT individuals. Must have multitasking ability with excellent organization, analytical, planning and scheduling skills.
• Must be able to obtain and maintain a US Public Trust clearance

Preferred Qualifications:

Candidates with these skills will be given preferential consideration.

• Prior Social Security Administration (SSA) experience
• Experience with relational database systems including PostgreSQL, Oracle, MySQL, and DB2; and writing complex SQL queries
• Experience with popular Node.js web frameworks and/or utility libraries such as: Express, Hapi, Underscore/Lodash, Async, Bluebird, and Grunt.
• Strong proficiency working with database systems such as MySQL, MongoDB, Oracle, and/or PostgreSQL.
• Knowledge of HTTP protocol
• Experience building RESTful APIs
• Experience with React.js frameworks (e.g. MOBX or FLUX)
• Experience with ECMAScript 6
• Experience with designing and developing distributed systems
• Experience with microservices and respective architecture design principles and scalability best practices
• Experience in creating API design/technical documentation (Raml, swagger)
• Experience in using debugging and observability tools for live systems dtrace, strace dtruss
• Experience in messaging protocols such as AMQP (Rabbitmq, Kafka, Nats).

#LI-DNI