Data Migration Expert (Siebel)

Job Title Data Migration Expert (Siebel) Location Lower Manhattan, NY
Duration 6+ months

Hours Weekly: 35 hrs/week

DESCRIPTION OF WORK AND SKILLS DESIRED:

-Define the data migration strategy and architecture in line with industry best practices for large-scale 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.

-Solid work experience required on PLSQL.

-Review and execute data analysis, data cleansing, enrichment, and mapping activities to ensure zero fall-outs.

-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 sign-off post cut-over

-Professional 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 tuning

-Deep understanding of Packages/Procedures.

-Advancedknowledge and extensive experience with PL/SQLadvance features

-Good 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 delivery

-Advanced PL/SQL & Advanced query tuning

Tasks/ Duties

• For 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 5.00% IT is also fulfilling Data extract Requests from various Business Divisions of LHD e.g. Borrows Vendor Payment Unit, Legal Departments, Inspections 3.00% IT is also fulfilling Data extract Requests from various Business Divisions of LHD e.g. Borrows Vendor Payment Unit, Legal Departments, Inspections 2.00% Every month around 105K invoices will be generated approx. $160 millions) and money will be deposited via EFT to Private Sec8 Landlords (approx. 26K Landlords). 5.00% 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. 5.00%.
• 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. 5.00% 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. 5.00% As required by Business, on Ad hoc basis Case/SR s will be assigned as per the employee changes in LHD 5.00% 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. 5.00%
• All TSAP reports and new enhancements -development 5.00% Address TSAP incidents related to integration failures and data updates. 5.00% As SME for integrations between Siebel and AS400, all integration related incidents are assigned and addressed. 5.00%

Why Choose Cogent? Cogent Infotech stands at the forefront of technology consulting and is recognized globally for its award-winning services. With our headquarters in Pittsburgh, PA, USA, we specialize in guiding enterprises through digital transformation, leveraging the power of emerging technologies such as Cloud Computing, Cybersecurity, Data Analytics, and AI. Our mission is to provide innovative workforce solutions that address the complex challenges faced by today s businesses.

As an ISO-certified firm and appraised at CMMI level 3, our reputation for excellence is well-established. We are proud to collaborate with over 70 Fortune 500 companies and more than 150 Federal C State agencies, delivering cutting-edge technology solutions that drive success.

Cogent is an equal opportunity employer. Cogent will not discriminate against applicants or employees based on race, color, religion, national origin, age, sex, pregnancy (including childbirth or related medical condition), genetic information, sexual orientation, gender
identity, military status, citizenship, or any other class protected by applicable law