Job Role : Application Analyst - Data Migration

Hi Professionals, Hope you are doing well, Kindly find our new requirement , Job Role : Application Analyst - Data Migration Location : Sunnyvale, CA( Onsite) Client : City of Sunnyvale Candidate must pass a background check. The City will conduct in-person interviews. These positions will work on-site in Sunnyvale 5 days a week, remote work is not an option. Job Description: Seeking analysts to be a technical resource in supporting our HCM data migration from legacy application and integrations definition for ERP/HCM implementation. In addition, this role will provide primary IT technical support with various database (Oracle and SQL Server) and interface tools (scripting and reporting). This position is required to participate in a hard-charging project environment, quickly analyzing and understanding legacy systems and help identify the best solutions in a timely manner utilizing database, programming and application analysis skills. Required Skills/Experience Working knowledge of Oracle, Microsoft SQL Server, and Microsoft Access Ability to learn and understand application data table structure to create database schemas and ability to conditionally extract data directly from data base to create complex database views with Strong SQL programming Experience with Microsoft SQL Server and Oracle database backup/restore processes and Microsoft SQL Server SSIS Define, manage and/or perform the design, testing, implementation and documentation of IT systems per agreed timelines, business requirements and organization standards in collaboration with internal business units Experience developing interfaces and integration between different system Extract & transform for data integration Work as a cross-functional team member, critically evaluate and manage user requests to ensure accurate prioritization and optimal resolutions Lead communication with internal staff, business users, and technology service providers to bridge the requirement gaps and technical needs 2 years' experience in IT Applications 2 years' report development in Oracle BI Publisher, Crystal reports or SSRS 4-year degree or Master's degree related to Computer Science and Business Analyst Desired Skills/Experience Working experience of creating Oracle Packages/functions and Microsoft SQL Server stored procedures Experience supporting application functions like Payroll, Time Reporting, Absences, Benefits, Position Budgeting and Core HR Working experience of developing reports in Oracle Fusion including Oracle BI Publisher and OTBI Working experience of Oracle Fast Formula, HCM extract Experience with ASP.net programming Experience working on interface development between finance/HR system (eP/NextGen) and Questica budget system Experience with a public-sector agency Thanks & Regards Velan | Infowaygroup.com | US IT Recruiter, Email:Velaninfowaygroup.com Cell: (925) 378-2449 /(315) 875-7462. Info Way Solutions LLC | 46520 Fremont Blvd, Suite 614 | Fremont, CA -94538 https://www.linkedin.com/in/velan-b-771932189/