Job Title: PL/SQL Developer
Client: State of Michigan

Location: Lansing, MI 48933 (Hybrid (onsite 2 days per week)
Contract: 12 months (with possibility to extend)

Note: Local candidates are STRONGLY preferred. This would be a F2F interview .

Job Description:

• Translate business requirements and models into feasible and acceptable data warehouse designs.
• Provide support to all data warehouse initiatives.
• Define all metadata standards for the data warehouse.
• Develop data warehousing hardware and software platforms and integrate systems to ensure that
  integration is effective and meets client specifications.
• Prepare a design for all metadata relating to various Extract/Transform/Load (ETL) processes.
• Create ETL designs to provide easy accession to data marts.
• Conduct troubleshooting on all ETL processes and effectively resolve any issues.
• Analyze every data warehouse architecture goal and identify what skill requirements they require.
• Evaluate all proposals and requests and help implement the chosen items that will improve the data
  warehouse structure.
• Assist in the definition, documentation, and development of mapping rules for movement of data from
  desperate data sources and into the various components and subject areas.
• Create data models including robust data definitions, entity-relationship-attribute models, as well as
  relational and/or dimensional models.
• A good understanding of the design and development of complex business reports.
• Design and oversee the implementation of data transformation and change processing procedures to
  ensure that data from multiple sources is aggregated, normalize, and update and then publish to
  multiple target environments.
• Provide hands-on data modeling (relational and dimensional) for Data Warehouse/Data Marts
• Test and monitor alterations in designs.
• Create database models which serve as blueprints for project engagements of all complexities.
• Must be familiar with DevOps best practices and automation of processes like building, configuration,
  deployment, documentation, testing, and monitoring.

Requirements:

• Experience in Data Modeling and desigining Datawarehouse databases,Required 10+ years.
• Experience in developing ETL models. Required 5+ years
• Experience in Data Replication using tools like Oracle Golden Gate, 5+ years.
• Experience in Oracle Database administration, PL/SQL, packages, security, and stored procedures,
  Required 12+ years.
• Knowledge in design, development, implementation, and documentation of data systems
• Working knowledge of relational database design, logical data modeling, data warehousing, and
  relational database management systems preferably Oracle 19c,
• Experience in performance tuning, Required 10+ years.
• Vast experience in LINUX systems, Required 10+ years.
• Extensive working experience in RAC environments, Required 10+ years.
• Experience using Oracle Data Guard / Fast Start Failover, Required 5+ years.
• Database programming experience in data migration and conversion practices, Required 8+ years
• Writing Oracle packages, procedures, and functions, Required 10+ years
• Designing, creating, normalizing and maintenance of oracle database objects, Required 10+ years.
• Designing logical and physical database model, Required 10+ years
• Data analysis and management, Required 10+ years

Email Your Resumes : priya.p@techjordan.com

Job Title: PL/SQL Developer

Client: State of Michigan

Location: Lansing, MI 48933 (Hybrid (onsite 2 days per week)

Contract: 12 months (with possibility to extend)

Note: Local candidates are STRONGLY preferred. This would be a F2F interview .

Job Description:

• 8+ years designing and review of logical and physical data model in SQL and/or PL/SQL
• 6+ years of hands-on relational, dimensional, and/or analytic experience
• 6+ years of experience in writing SQL packages/functions/Triggers and Mass data updates and deletes.
• 3 + year of experience in query optimization and performance tuning.
• 3+ years of experience in data conversion between multiple systems and experience in data transformation strategies.

Email Your Resumes : priya.p@techjordan.com

Roles & Responsibilities:

• The candidate will be responsible for handling bench sales recruitment. i.e. sourcing job requirements from prime vendors, vendors, and clients for submitting the bench consultants, negotiating the best rates for the consultants, following up on interview schedules & placing the consultants.
• Regular interaction and follow-up with bench consultants and identifying their needs and getting them into the best possible projects.
• Candidate has to develop and maintain good relationships with vendors, clients, and consultants.
• Ability to work as a good team player, interviewing, hiring candidates, maintaining, and building the candidate database.
• Marketing USC, GC, H1B, H4 EAD, EAD, and OPT Consultants.
• Posting the resume on all job portals like Dice, Monster, CareerBuilder, and social networking portals, etc.
• Submitting the consultants to all the suitable job postings on all portals.
• Broadcasting the Profile of the consultant and the Hotlist of the company on a periodical basis.
• Reaching out for the maximum number of open requirements in the market.
• Coordinating with the consultant in order to know their comfortableness with the requirement before submitting to the Vendor
• Negotiate rates with the Vendors/ Clients.
• Inform the consultant regarding the vendor calls and end-client interview schedules.
• Intimate the entire team regarding client submissions to avoid duplications.
• Track the submissions and make regular follow-ups.
• Prepare the consultants for the end client interviews.

Role: 

Business Development Manager (BDM)Industry Type: 

IT Services & ConsultingDepartment: 

Sales & Business DevelopmentEmployment Type: 

Full Time, PermanentRole Category: 

BD / Pre Sales

The job involves managing and marketing IT consultants to Tier 1 / SI / End clients. The selected candidate will be involved in marketing our bench candidates to clients apart from managing relationships with candidates.

Skills required:

Having 2-5 Years of Proven Experience in US IT Staffing and Consulting Industry.

Have excellent written, verbal & interpersonal communication skills.

Well Experienced in handling the Full Cycle of US IT Recruitment. i.e., from sourcing Job requirements from Prime Vendors, Vendors, Clients, etc., to submitting the Bench Consultants, negotiating the best rates, following up on Interview Schedules & Placing the Consultants at best deals.

Experience in working with OPT/CPT, H1B, EAD, Green Card & US citizens.

Knowledge of Employment Type w2, Corp to Corp, 1099.

Regular interaction and Follow-up with bench Consultants and identifying their needs and getting them into projects accordingly.

Ability to do H1 Transfers.

Experienced with End-to-End cycle of sales from submitting Profiles, Rate Negotiations, and Follow Up.

Knowledge of Job Portals like Dice, Monster, and CareerBuilder, and social media Platforms. Able to Handle and Turn H1 B Transfers and Referrals on to our W2 Consultants.

Must be independent and a self-starter and have high risk-taking capabilities.

Must deal patiently with the consultants and keep updated them on daily basis regarding the marketing.

Must be prompt in responding on time to consultants, Vendors, and Clients.

Coordinate with the internal recruiting team for any new client or Vendor requirements.

Update and maintain every month reports of Interviews.

Role: US IT Recruiter

Industry Type: IT Services & Consulting

Department: Human Resources

Employment Type: Full time, Permanent Role

Category: Recruitment & Talent Acquisition

Education: Any Graduate

Key Skills: Linkedin, US IT Recruitment, C2C, H1B, dice, W2, US IT Staffing.

Job Description

Top 3 Required Skills/Experience • PowerShell and Automation skill set
• Jenkins tool deployment tool- Configuring and Administration.
• CI/CD pipeline configuration
• Should have strong knowledge in Azure DevOps and PaaS resource
• Should understand the Terraform concepts.

 The rest of the required skills/experience  • Should be able to guide the team for any technical issues.
• Sometimes a resource should act as a technical product owner.
• Understanding the Concept of how web application hosting and configuration
• Should know about Active directory and configure the ADLDS.
• Bamboo configuration and Management
• TFS Source control server Management.
• Should be familiar with following scripting Groovy script, PowerShell, bash and batch scripts

Optional but preferred skills/experience• Active directory federation services

• Should know about the basic of SQL and Oracle queries

Client : State of Michigan
Location: Local candidates preferred. MUST be able to work in Hybrid Schedule( 2 days/week Onsite). NO remote only option.
Due Date : 05/24

 Job Description         DTMB Agency Services is in need of a Business Analyst to provide excellent customer service supporting both project and work request needs for the Environment, Great Lakes and Energy (EGLE) Agency.  This person will have the opportunity to join two in-flight projects focused on implementing new IT solutions to provide increased efficiencies and public support for environmental health and drinking water programs.  These IT solutions leverage current technologies and include working with multiple EGLE subject matter experts, partners in the Local Health Departments, vendors, and the general public.
        Key responsibilities include being the liaison between DTMB and the project stakeholders, as well as providing expert facilitation and elicitation to help develop strategy and requirements for future enhancements and related work projects.  In addition, as part of the overall support for EGLE, this person will be a critical member of the DTMB Agency Services Business Analyst team, participating in various related work requests for EGLE and contributing to the operational activities of the BA team.

       Customer service and being a champion to ease Agency compliance with DTMB policies and practices are key performance expectations for this person.  They must be able to quickly gain a working understanding of applicable constraints and enablers and help EGLE navigate those for the success of their projects and work requests.  A common day would include attendance in various standing meetings for each of the projects, as well as those that include the BA team – being able to confidently speak to current activities in each, listening to understand needs, and helping to provide input that assists in meeting the objectives of the respective meetings.  In addition, related work will include ongoing analysis of original requirements/user stories in comparison to needs identified in discovery sessions and/or UAT cycles and helping to define potential changes, to include impact analysis.
      DTMB Agency Services and EGLE welcomes candidates that are self-directed, well organized, confident in their ability to build relationships, quick to come up to speed on new assignments, and able to be flexible and adaptable to changing needs and/or direction.

At the discretion of the resource manager, this position may include remote work, but candidate should plan to be available to report to a Lansing, MI job location in accordance with State of Michigan return to office guidelines.

Business Analyst Position General Description

• Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Experienced with business process reengineering and identifying new applications of technology to business problems to make business more effective. Familiar with industry standards (including Legacy, Core, and Emerging technologies), business process mapping, and reengineering. Prepares solution options, risk identification, and financial analyses such as cost/benefit, ROI, buy/build, etc. Writes detailed description of user needs, program functions, and steps required to develop or modify computer programs.
• Prepare and document Functional and Technical Specifications for reporting and data warehouse work. Assist with business warehouse/intelligence support and enhancements. Develops RFPs. Assist in deployment and management of end-user reporting tools and platforms. Work with IT and business project teams to understand reporting and data warehousing requirements and propose solutions. Document and provide knowledge transfer to the rest of the Enterprise Reporting Team for all solutions.
• Reviews, analyzes, and evaluates business systems and user needs. Formulates systems to parallel overall business strategies. Has knowledge of commonly-used concepts, practices, and procedures within a particular field. Familiar with relational database concepts, and client-server concepts. Relies on limited experience and judgment to plan and accomplish goals. Performs a variety of tasks. Works under general supervision; typically reports to a project manager. A certain degree of creativity and latitude is required 

Specific Position Experience Required

• Minimum of 7 years conducting business process review and requirements elicitation and documentation
• Minimum of 5 years developing and/or managing user stories on Agile development project(s)
• Minimum of 2 years working directly with senior management in facilitating discussions to determine strategy, develop road maps and/or gain consensus to resolve opposing positions
• Minimum of 2 years supporting the development of or compliance to statement of work and/or other work agreements/contracts
• Minimum of 2 years working on projects developing/implementing IT solutions for public use
• Minimum of 1 year working on IT infrastructure projects
• Minimum of 1 year working with programs governed by state and/or federal regulations

Client : State of Michigan 

Location: Lansing, Michigan. Local candidates or willing to relocate at the candidate’s expense. Must be located in MI at time of start as they will be REQUIRED to be onsite 2 days a week from day 1.  
Due date : 10/5

Position Justification      The position is responsible for providing ongoing maintenance and support of complex Java applications and developing enhancements to
 Electronic Test Ordering and Results(ETOR) for MDHHS State Labs and Oral Kindergarten application modernization for the Child and Adolescent  Health business area. Changes are being made to enhance the stability and functionality of the ETOR system. The resource is integral to  developing and maintaining MDHHS’ ETOR and Oral Health automated processes, streamlining critical business processes, data integrity, SEM/SUITE compliance, and securing the applications. The resource also performs as a technical lead and provides technical guidance to the other developers in the department. 
       As a technical lead, the resource participates in a variety of analytical assignments that provide for the enhancement, integration,
 maintenance, and implementation of projects. The resource also provides technical oversight to developers in the team that support other
 critical applications . Not having a resource on staff will lead to MDHSS manually documenting and developing screen plans that can lead to

 errors causing data integrity issues and can eventually lead to incorrect information being processed and reporting of the patient information.

Position Summary

• Write well-designed, testable code using spring MVC, Hibernate framework for entity object mapping, JQuery/HTML5, JavaScript,HTML, XML,Angular
• Develop business application components using Object Oriented java/JEE technologies, design principles .
• Design and develop RESTful Web Services using Spring Web MVC framework.
• Design, Develop and maintain applications using Apache Struts framework.
• Ability to implement design patterns like Intercepting Filter, Front Controller, Session Façade, DAO, Singleton, and Service Locator
• Execute full software development life cycle (SDLC) including experience in gathering requirements and writing.
• Functional/technical specifications for complex projects.
• Excellent knowledge in designing both logical and physical database model
• Develop database objects including stored procedures, functions,
• Troubleshoots issues using SQL, PL/SQL scripts and tuning SQL queries and scripts
• Hands on experience Integrating software components into a fully functional software system
• Extensive knowledge on source control tools such as GIT
• Experience on Build Frameworks like Maven, maintain source code using source control, and baseline software versions and build war files for deployments
• Experience developing with application servers Apache Tomcat, JBOSS, Web Sphere,Openshift Container
• Develop software design documents and work with stakeholders for review and approval.
• Experience developing, prototypes, mockup for users review and approval.
• Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirements
• Experience working on large agile projects.
• Experience with Java 8, SOAP Web-Services and Java Messaging Service (JMS) API.
• Experience with Spring Boot Projects, Spring Data, Spring Batch, Spring Security frameworks.
• Good to have knowledge of Apache Kafka, Apache Spark and ActiveMQ broker.
• Experience in Database Design in Oracle and SQL server.
• Experience in modern architecture things like micro services, security, cloud, and containerization
• Experience or Knowledge on creating CI/CD pipelines using Azure Devops.

Skill Description

• 12+ years developing complex computer systems using Java.
• 12+ years developing complex computer systems using java IDEs such as Eclipse,STS
• 8+ years programming using Java JEE Struts Framework
• 12+ years programming in SQL and/or PL/SQL.
• 8+ years programming using Java JEE Spring/SpringBoot Framework 3.0.
• 8+ years of development using Hibernate/JPA framework.
• 5+ years in project development using Angular/React JS, JavaScript framework.
• Over 5+ years programming in the JBOSS Enterprise SOA environment including JBOSS Workflow .
• Over 5+ years using CMM/CMMI Level 3 methods and practices.
• Over 5+ years implemented agile development processes including test driven development.
• Over 3+ years Experience or Knowledge on creating CI/CD pipelines using Azure Devops- Nice to have.

Client : State of Michigan 
Location: Lansing, Michigan. Candidates MUST be local. Will need to be onsite starting day 1 for a hybrid work schedule. NO REMOTE ONLY OPTION. 
Due date : 10/4

General Summary    Serve as the development specialist responsible for the design, development, testing and documentation of the technical software solutions. Solve system
 design problems and programming issues. Ensure that the solutions are integrated and enhanced to meet the needs of the agency’s business plan. Provide
 technical leadership to the application development team, agency, and external groups. Research and evaluate relevant technologies as it pertains to the business strategy.

Individual tasks related to the duty

• Assist in the development of software applications, server components and services using various development tools and State of Michigan approved/supported technologies.
• Plan and coordinate the integration of systems with existing systems within the business area, external business partners, state agencies, and multiple hosting platforms.
• Design and implement application security that complies with State of Michigan policies.
• Lead and direct impact analysis of potential changes due to proposed legislation, enhancement requests, or changes in governmental and business processes.
• Review and approve presentation materials for technical review meetings, approval sessions, and application demonstrations.
• Ensure that technical design strategies or applications adhere to State and agency policies, standards, and guidelines.
• Designs application frameworks and creates coding standards.
• Review and approve State of Michigan system engineering methodology or other required technical deliverables.
• Direct and coordinate development resources, agency staff and service delivery teams.
• Direct development resources and quality assurance staff in testing activities on assigned projects.
• Review and approve test plans and results for technical solutions.
• Coordinate IT production operation support for critical system(s) based on business schedule and needs.
• Coordinate with matrix organizations to ensure partnership agreement requirements are met.
• Provide oversight of team’s work to complete activities according to established timelines.
• Provide technical approval for design and production release(s).
• Lead planning sessions for development.
• Oversee the merge of development code to ensure it is integrated properly.
• Provide technical leadership and mentoring on programming and design techniques (Continuous Integration, Test-Driven Development, etc.)

Required• Experience in analysis, design, programming, testing, implementing, and supporting web-based applications in Microsoft/Windows platform. (ASP.NET, framework 3.5 or higher).
• Experience with VisualBasic and/or C# within Microsoft Visual Studio (2017 or newer)
• Experience with software tools to test applications for ADA compliance
• Experience with Microsoft Reporting Services
• Experience in developing systems with Microsoft SQL Server (SQL 2008 or higher)
• Experience writing Structured Query Language (SQL) and stored procedures.
• Experience in performing analysis and requirements gathering with customers.
• Knowledge of both web-based and client server based systems architecture.
• Knowledge/training in object oriented analysis, design and programming experience.
• Knowledge of application and database development and access methods.
• Ability to prepare detailed written instructions and documentation.
• Ability to effectively make oral and written reports and presentations and prepare clear and concise documentation.
• Ability to establish and maintain effective relationships with clients and matrix support teams.
• Ability to resolve complex problems in a timely manner and seeks optimum solutions.
• Ability to communicate technical terminology at a level appropriate to the audience.
• Experience producing deliverables using the Systems Engineering methodology (SUITE).
• Knowledge of CEPAS and/or PCI.
• Effective at designing solutions for highly complex assignments in a high stress work environment.
• Ability to troubleshoot application issues under pressure.

• Familiar with use of source control.

Client - State of Michigan

Title - .NET Developer 

Posting ID 115402

Address - 7150 Harris Dr., Dimondale, MI

Top Skills & Years of Experience:

•             10+ years' experience developing large scale software systems, using Object Oriented programming language such as: .NET framework, asp.net, .NET Core, Visual Studio, Internet Information Services, CSS, MVC, C++, C#.net and JavaScript is highly preferred.

•             10+ years of development experience on databases design using Oracle/SQL Server.

•             10+ years of experience developing technical designs in consultation with application/solution architects to set direction of design and development for large application development projects.

•             The candidate must have experience in NIST Protocols, Oracle Notification service, Microsoft Power Apps, Power Automate and Power BI.

Requirements:

•       10 years of experience developing large scale software systems, using Object Oriented programming language such as .net framework, asp.net, .NET Core, Visual Studio, Internet Information Services, CSS, MVC, C++, C#.net and JavaScript is highly preferred.

•       5 years in .NET core experience.

•       10 years of experience developing technical designs in consultation with application/solution architects to set direction of design and development for large application development projects. Review technical design and specification for completeness and conformance to quality standards, especially as a mentor to less experienced programmer analysts.

•       10 years of responsive design application development experience with a focus on human centric designs.

•       Mastery understanding of modern application architectures - three-tier, distributed, centralized, microservices, etc., with experience in REST API. Implement requirements of the API layer like security, custom analytics, throttling, caching, logging, request, and response modifications, etc. using the API management platform.

•     Build, maintain, improve, and evolve our Continuous Integration and Continuous Delivery processes for new and existing services to reduce manual/repetitive tasks using an Agile delivery methodology. Working closely with our development team to create an automated continuous integration (CI) and continuous delivery (CD) system. Must have 5 years of experience with system design and implementation of build processes and release management with Atlassian Bamboo, Jira, Bitbucket, and/or Azure DevOps, and/or Jenkins, integrating multiple platform integrations, such as IBM WebSphere, OpenShift, Linux, Oracle, SQL Server, and Windows.

•       Experience with Microsoft Power Apps, Power Automate and Power BI.  Must be able to lead the team in this effort of assisting the team to develop and maintain requests from our agency.

•      Work with the solutions architect to set up guidelines/processes on code review. Manage defect tracking for large scale systems implementation. 

•       10 years of experience directing the analysis, definition, and documenting of system and business requirements with clients, for large scale systems. Business process design and re-engineering.

•       Re-write of legacy software and provide production/operational support using Microsoft Visual Studio

•       May review and advise on design solutions developed by others.

•       Comply with programming standards, processes, and evaluate and identify opportunities for programming standardization.

•       Use of .net coding standards and integration processes/objects/framework that can be leveraged for an IT Solution.

•      Over 10 years of development experience on databases design using Oracle/SQL Server.

•      Strong Software Engineering skills including design, programming (C#, C++, script) and debugging.        

•      Expert in C# object-oriented programming with deep experience applying this knowledge to complex software architectures and the ability to use .NET Core.

•       Strong familiarity with Agile software/tools (e.g., JIRA) and DevOps processes and tools (e.g. Jenkins/Bamboo/Azure DevOps).

Desired skills:

C#.NET, ASP.NET, Web API, Entity Framework, Bootstrap, .NET Core framework, JavaScript, JQuery, ASP.NET, SQL, CSS, MVC, Design patterns, Entity Framework, ADA Section 508 accessibility software testing, SQL Server, json, C++, node.js, CI/CD tools, Microsoft Power Apps, Power Automate and Power BI.

We need a staff Aug with below specified requirements:

•       The candidate must have experience in designing transactions using NIST protocols.

•       The candidate must have experience in designing and implementing the Oracle Notification service.

•       The candidate must have expertise in designing, developing and implementing Microsoft Power Apps, Power Automate and Power BI.

•       Design and develop enterprise software applications in .NET using MVC in C#.

•       Design and develop in ASP.NET web API and web-component based web UI.

•       Experience working with Agile methodologies for the project development.

•       Actively participate in scrum team, creation and validation of code and unit tests in an Agile environment.

•       Proficient in Web Services and WCF, SOAP, XML, XSL, XSLT, CSS, DOM, HTML, AJAX, Java Script, response web design, angular, bootstrap.

•       Extensive knowledge of .NET code libraries.

•       Hands-on experience in web services-RESTful.

•       Designing and developing the Web API and WCF.

•       Experience in Developing User Interface (UI) Rich Web Applications, and Web Service Applications using Front End/User Interface (UI) Technologies like Object Oriented JavaScript, Type Script, Angular 5, Angular JS, Node JS, Bootstrap, Media Queries, CSS Frameworks, C++.

•       Experience in testing the web application using JAWS screen reader.

•       Experience in implementing the ADA compliance for web applications.     

•       The candidate should expertise in integrating the selenium with the dot net framework.

•       Develop design documents, application infrastructure diagrams, and flow diagrams to be leveraged during implementation.

•       Experience with fully automating CI/CD pipelines end-to-end, from code commits to production releases.