Siebel Developer/Integration/Architect

Phone/Skype Hire. Onsite from day 1Location: NYC, NYDuration: 6 months  (35 hrs/week)ResponsibilitiesFor Public housing Residents, For Annual Rent calculation, team needs to create Annual recertifications in two types of packets (online and paper). Team needs to make sure all online Users are registered on web. This needs to be attended every quarter IT is also fulfilling Data extract Requests from various Business Divisions of LHD e.g. Borrows Vendor Payment Unit, Legal Departments, InspectionsEvery month around 105K invoices will be generated approx. $160 millions) and money will be deposited via EFT to Private Sec8 Landlords (approx. 26K Landlords). We have created an Apex Report for business for Case creations. If the request is more than 15 cases, IT will load the cases in apex table and will create/register the cases. We are doing the troubleshooting where there is an error in case creation. We are doing modifications for the reports as per business requirements. We have created Two Apex reports for Case and SRs for Section 8 Voucher Holder Program users to update the status and sub status to avoid delays with interacting with IT. We are doing modifications for the reports as per business requirements. We have created Two Apex reports for Case and SRs for Public Housing Section 9 users to update the status and sub status to avoid delays with interacting with IT. We are doing modifications for the reports as per business requirements. As required by Business, on Ad hoc basis Case/SR’s will be assigned as per the employee changes in LHD For various enhancements testing in lower environments, we will need to set up data since it will not match PRD data. This is to assist the integration testing from failing due to data errors.All TSAP reports and new enhancements development Address TSAP incidents related to integration failures and data updates. As SME for integrations between Siebel and AS400, all integration related incidents are assigned and addressed. Define the data migration strategy and architecture in line with industry best practices for largescale data migration.Define data migration objectives & scope, identify stakeholders, outline data migration activities & deliverables.Develop data migration approach and data model for supporting massive scale data loads.Work with multiple vendors for data source and mapping of entities.Skills NeededSolid work experience required on PLSQL.Review and execute data analysis, data cleansing, enrichment, and mapping activities to ensure zero fallouts.Manage execution of data migration cycles, unit test migration .Work closely with business functions to maintain data integrity and accuracy, suggest performance tuning/optimal way to reduce fallouts while maintaining data quality.Publish execution reports to stakeholders.Ensure successful migration from source to target system and obtain data sanity signoff post cutoverProfessional experience required on SQL,PLSQL, Siebel EIM, Siebel Admin.Good understanding on Siebel EIM performance tuning.Deep understanding on Siebel EIM methods.Develop PLSQL packages and performance tuning.Demonstrated experience creating data models for application operations and performance requirements.Deep understanding of query performance tuningDeep understanding of Packages/Procedures.Advanced knowledge and extensive experience with PL/SQL advance featuresGood experience in all aspects of SQL development: review requirements, design/document database objects, create database objects and test database layer.Experience working on higher environment SQL code deliveryAdvanced PL/SQL & Advanced query tuning