The Software Engineer will perform advanced analysis and computer programming work involving all technical aspects of supporting, improving, and enhancing applications for a large project.  This position requires strong PL/SQL skills.  We are seeking a proactive team member who will be responsible for enhancing the assigned application and solving production issues.  Work assignments follow a defined software development life cycle (SDLC) process using an Agile  approach for completing code changes for defined releases. The Programmer works across multiple agency stakeholders to ensure the accuracy and efficacy of created reports.

 Minimum Requirements:

• 7+ Years of SQL experience
• 7+ Years of experience and knowledge in use of Oracle stored procedures, PL/SQL
• 7+ Years of Dynamic SQL and Exception handling
• Strong Experience working in an Agile Enviroment and 2 week sprints

The client is developing a data warehouse solution and requires a Sr. ETL developer with proven data warehouse experience to:

• Design, develop, and test ETL processes for the data warehouse.
• Develop and document ETL processes to extract data from existing systems into the data warehouse.
• Document the “as-is” schemas currently in use at TWC.
• Perform other analysis and documentation tasks as required to enhance data warehouse functionality.
• ERWin or other equivalent data modeling tools
• More than one type of RDBMS (DB2, SQLServer, Oracle)

Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes.

Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle using different data sources.

The Worker will perform routine programming tasks in an agile environment, including implementing solutions based on user stories and customer designs, and providing technical expertise to the team with design discussions and peer reviews. Worker will provide feedback and contribute expertise to improve applications and development processes.

Worker will perform these tasks:

• Installing, configuring, maintaining, administering, and enhancing JIRA Core, JIRA Software, Confluence, JIRA Service Desk, and BitBucket
• Helping guide the configuration and documentation of client JIRA, Confluence and BitBucket instances
• Develop and maintain Maven and ANT build scripts in a Jenkins continuous integration environment.
• Write high-quality, reusable code following industry best practices
• Work with customers to enable custom workflows, fields, screens, dashboards, and reports
• Provide client training on JIRA and Confluence usage, administration, and operational use and maintenance of the systems
• Follow best practices for serverless architecture
• Participate in peer code reviews
• Write unit tests using JavaScript testing frameworks
• Review and validate proposed architectural solutions
• Participate in project meetings

The worker must have strong experience working in a team environment.

• Strong facilitation skills, drive for results, attention to quality and detail, and a collaborative attitude
• Strong written, verbal, and interpersonal communication skills
• Must be able to work independently
• Must be able to work in a diverse team environment
• Must possess problem-solving skills and ability to multi-task
• Must be able to retain knowledge of environment and systems once given instruction
• Knowledge of Agile development methodologies
• Must be able to work around projects and deadlines with readiness to put in extra efforts when necessary
• Perform related work as assigned

• Background with custom application development using object oriented programming technologies like .NET or Java
• Background in application development using technologies like HTML, CSS, and JavaScript
• Experience with fundamental database concepts (including data modeling and integration)
• Experience with the use or creation of REST/SOAP-based web services and service bus technologies
• Conduct hands-on development, configuration, or system setup
• Experience with implementing solutions in the leading cloud providers (including AWS, MS Azure)
• Documents technical requirements, designs and develops systems
• Executes test strategies and deploys solutions
• Analyze data and processes, compile research, and offer possible solutions
• Provides timely and succinct status updates
• Conducts facilitated working sessions with small groups of users
• Produces high quality deliverables on time
• Shares knowledge and teaches other Scorpions
• Travels to client locations

Requirements:

• 3-5+ years of experience
• US Citizen or GC Holder
• Bachelor's Degree

Responsibilities:

• Design, create, and modify websites
• Create back-end code and interfaces for new web platforms
• Analyze user needs to implement website content, graphics, performance, and capacity
• Integrate websites with other computer applications
• Keep up to date on web developments and trends

Qualifications:

• Back-end development knowledge (2+years of web framework experience)
  
• Front-end development knowledge (HTML, CSS, JavaScript/TypeScript)
• Version control (Git or Mercurial)
• Docker familiarity
• Agile development familiarity
• Strong problem solving and critical thinking skills
• Strong attention to detail

• Serves as a workstream lead for Public Sector projects with primary project responsibilities such as leading the team in documenting business requirements, creating process maps, creating solution documentation, developing and executing test strategies, developing and delivering training for business users, etc.
• Establishes professional presence in all environments
• Seeks feedback and desires growth by driving one’s own personal development including setting and achieving development goals
• Understands solutions based on the requirements of the project and can speak credibly and accurately to the technologies and overall architecture that can meet those requirements
• Serves as an escalation point and provides leadership and guidance to other Functional Analysts
• Applies and drive project methodologies
• Accurately scopes and plans his or her part of the work
• Produces high quality deliverables on time
• Analyzes data, compiles research and offers possible solutions
• Escalates issues, risks and scope discrepancies to Project Manager
• Provides timely and succinct status updates to Project Manager
• Builds strong trusting relationships with the client stakeholders and/or client project team
• Assesses his or her skills and capabilities and participates in his or her evaluation process
• Is a role model for other Functional Analysts
• Adapts and remains positive in challenging environments
• Embraces new processes and client environments
• Manages through the changing landscape of a project’s ups and downs
• Conducts facilitated working sessions with small groups of users
• Shares knowledge and teaches other analysts
• Identifies and fosters opportunities for continued engagements with clients
• Displays ideal behaviors and is role model for entire team
• Strong written and verbal communication skills
• Travels to client location

Requirements:

• Entrepreneurial attitude with desire to foster and grow the Public Sector in addition to fulfilling project responsibilities
• Growth minded and focused on personal improvement in addition to delivering for projects
• Experience leading a team of 2-5 analysts
• Minimum of 2 years of consulting experience required
• Minimum of 3 years of work experience required
• Public Sector (State and Local Government) consulting experience is preferred
• Bachelor's degree
• US Citizen or GC Holder

Provide requirement analysis and testing services for the mandated enhancements of client’s support system.  This position will provide requirement analysis to create test cases and scripts for functional and nonfunctional requirements, prepare test data, execute test scripts, analyze data, support user acceptance testing, and provide defect triaging. The workers responsibilities and skills must include:

• Create test cases and scripts
• Skilled with Database query languages (SQL, PL/SQL)
• Prepare test data to be loaded in the database
• Execute test script logging results.
• Document defects include steps to reproduce the anomaly.
• Utilize analysis and diagramming tools to represent business processes.
• Must have historical and proven knowledge and practical application of testing best practices
• Effectively communicate with non-technical audience to understand business needs and explain complex systems and technical topics in clear and concise manner
• Other duties as assigned

• Lead teams of 2-10+ technical resources
• Manages facilitated working sessions with technical executives and experts
• Conduct hands-on development, configuration, or system setup for early stage POCs/POVs
• Present technology architecture and solution overviews to executive-level audiences
• Create presentation materials with emphasis on simplifying complex ideas into digestible topics
• Provide leadership across multiple accounts as well as support sales and business development activities
• Apply technical aptitude and design patters across multiple industry verticals and use cases
• Conduct assessments and define enterprise roadmaps for enabling a data-driven Analytics organization
• Participates in hiring resources as well as coaching and mentoring more junior staff
• Drives early stage business development and incremental work
• Effectively deals with a multitude of ambiguity by confidently walking through an undefined situation and drawing out key requirements and political constraints
• Design and implement Enterprise Data Warehouses (EDW) and related technologies (Teradata, Oracle, MS, etc.)
• Readiness, provisioning, security and governance relating to cloud platforms (AWS, Azure, Google)
• Provide thought leadership around modern analytics tools and platforms for mid-sized companies to Fortune 500s
• Aware of approaches and challenges for an Analytics organization at varying maturities

Experience/technical knowledge of the following:

• Data integration and streaming tools used for both EDW’s and Big Data (Informatica, Spark, Kafka, etc.)
• Cloud data warehouses such as AWS Redshift, Snowflake, Google BigQuery or Azure Data Warehouse
• Cloud ETL such as Informatica Cloud, Talend Cloud or Matillion
• Hadoop and related technologies (Cloudera, Hortonworks, etc.)
• Data Science and related technologies (Python, R, SAS, etc.)
• Artificial Intelligence (AI), Machine Learning (ML), and Applied Statistics

Requirements:

• US Citizen or GC Holder
• 2-3 years experience in a similar role

• 3-5+ years of experience
• Conduct hands-on development, configuration, or system setup
• Experience with the Salesforce platform, including template solutions like Sales Cloud, Service Cloud, Marketing Cloud
• Experience with custom application development in the Salesforce Platform, utilizing Visualforce and Lightning Components/Framework
• Experience with designing and implementing custom applications on the Salesforce platform using Apex programming
• Experience with object modeling in Salesforce and understanding of fundamental database concepts (including SOQL)
• Background in application development using technologies like HTML, CSS, and JavaScript
• Experience with integrating with the Salesforce platform (inbound/outbound) using the REST/SOAP APIs, MuleSoft, or Data Loader
• Executes test strategies and compiles deployment packages
• Documents technical requirements and design principles
• Analyze data and processes, compile research, and offer possible solutions
• Conducts facilitated working sessions with small groups of users
• Travels to client locations