• US Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• W2-Permanent

• W2-Contract

• Contract to Hire

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 27th Dec 2024

• Analyze the existing data structures in PeopleSoft and confirm the necessary transformations for Data Warehouse compatibility.

• Extract data from PeopleSoft using SQL and other relevant tools.

• Creation of efficient data structures that support reporting and analytics (expertise in dimensional modeling and entity-relationship (ER) modeling)

• Develop and implement data transformation processes to clean, standardize, and enhance the quality of the data during migration.

• Create data mapping documents that outline the relationships between source and target data fields.

• Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity.

• Utilize ETL tools for data integration.

• Validate data accuracy and completeness post-migration to ensure that all data has been successfully transferred.

• Work closely with business analysts, data architects, and stakeholders to understand data requirements and ensure alignment with business objectives.

• Familiarity with data governance, compliance, and data security protocols, including encryption, data masking, and compliance with regulations (e.g., PII, HIPAA)

• Recommending and analyzing the possibility of Cloud Data Warehousing