Viva USA INC Chicago , IL 60601
Title: Sr Systems Analyst
Sr Systems Analyst, System Engineer Analyst
This position is responsible supporting enhancements and new capabilities to an existing, critical, mainframe based business application within Claims applications space. As a systems analyst, it is required you bring strong experience of performing Systems Analysis for various projects and build a backlog of systems requirements that can be assigned to various developers. You are for also responsible for ensuring reviews of the requirements, designs, code and help plan SIT and UAT testing as well as releases. You will be working closely with the business team comprising of business analysts, business owners, QA team as well as IT team members like Applications Architects, Developers, product and project managers and other team members.
Advanced working SQL knowledge and experience working with relational databases, database concepts, dimensional modeling, query authoring (SQL) as well as working familiarity with a variety of databases.
Collaborating with Business Analysts, Project Leads and IT team to resolve issues and ensuring solutions are viable and consistent
Structuring and prioritizing business requirements and communicating System analyst plans with stakeholders for Data type/Mapping review and approval
Designing new data source data flow and/or updating current system data flow into various server/system/projects
Maintain and troubleshoot our data warehouse, provide risk mitigation planning, ensure data integrity and naming standards
Creating system guidelines and mapping documents
Running review sessions for system processes, Data Mapping, and data reports on efficiencies/improvement areas with in databases/tables
Experience working with and extracting data from large, disconnected and/or unstructured datasets
Experience performing root cause analysis on internal and external data and processes to answer specific business questions
Experience with Teradata and Big data tools and technologies: Hadoop, HDFS, Sqoop, Spark, Kafka, Hive/Beeline, NoSQL databases
Experience working with different file format : XML, JSON, CSS, CSV, HTML etc.
Determine database structural requirements by analyzing client operations, applications and programming; review objectives with clients and evaluate current systems
Develop database solutions by designing proposed system; define database physical structure and functional capabilities, security, back-up and recovery specifications
Maintain database performance by identifying and resolving production and application development problems, calculating optimum values for parameters; evaluating, integrating and installing new releases, completing maintenance and answering user questions
Required Qualification(s) :
10+ Years of IT Experience
VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment. The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions.
Please send your resumes to "" and one of our recruiter will get in touch with you.
Account co-ordinator: Ganesh P,Phone No: Extn: 228, Email id:
VIVA USA INC.
3601 Algonquin Road, Suite 425
Rolling Meadows, IL 60008
Sr Systems Analyst, System Engineer Analyst Insurance SQL relational databases Business Analysis query authoring