| Looking for Business Intelligence Developer//Remote Hyattsville, MD, Washington, DC, Alexandria, VA.//H4,GC EAD,GC and USC at Hyattsville, Maryland, USA |
| Email: [email protected] |
|
Hello I am Vikas from Okaya INC; we have an opening for Business Intelligence Developer - Remote Hyattsville, MD, Washington, DC, Alexandria, VA only. Below are the requirement details, please go through it, revert back to me with your updated resume your earliest reply is highly appreciated. Title: Business Intelligence Developer Location: Remote Hyattsville, MD, Washington, DC, Alexandria, VA. Duration: 12 Month Visa: H4,GC EAD,GC and USC Background The Washington Metropolitan Area Transit Authority (WMATA) is seeking proposals to provide key staff augmentation resources for backfilling WMATA IT Full-Time Employees (FTEs) who support Accounting, Finance, Human Resources, Timekeeping Management, Management Reporting and other related operations. These roles will be temporary contract positions to support daily operations during the lifecycle of a major ERP System upgrade initiative for the anticipated period of 18 months. This procurement is for backfilling two (2) FTEs who supports WMATAs Digital Modernization office in the capacity as the Conversion and Data Specialists. (Background information/Scope of Services) The Washington Metropolitan Area Transit Authority (WMATA) is seeking two Data Conversion Specialists to facilitate the migration of data from PeopleSoft to the Oracle FDIP (Fusion Data Intelligence Platform) system, ensuring data integrity and optimal performance. As a Data Conversion Specialist, they will be responsible for extracting, transforming, and loading (ETL) data from PeopleSoft into FDIP. They will also need to possess front-end development skills to develop reports and dashboards as required. They will ensure that data is accurately migrated and optimized for reporting and analytics, collaborating with various teams to achieve project goals. Job Description(s) Duties/Responsibilities: x Analyze the existing data structures in PeopleSoft and confirm the necessary transformations for Data Warehouse compatibility. x Extract data from PeopleSoft using SQL and other relevant tools. x Creation of efficient data structures that support reporting and analytics (expertise in dimensional modeling and entity-relationship (ER) modeling) x Develop and implement data transformation processes to clean, standardize, and enhance the quality of the data during migration. x Create data mapping documents that outline the relationships between source and target data fields. x Design and implement ETL processes to load data into the Data Warehouse, ensuring efficient performance and data integrity. x Utilize ETL tools for data integration. x Validate data accuracy and completeness post-migration to ensure that all data has been successfully transferred. x Work closely with business analysts, data architects, and stakeholders to understand data requirements and ensure alignment with business objectives. x Familiarity with data governance, compliance, and data security protocols, including encryption, data masking, and compliance with regulations (e.g., PII, HIPAA) x Recommending and analyzing the possibility of Cloud Data Warehousing Experience Minimum Requirements: Bachelors degree in Computer Science, Information Technology, Data Science, or a related field. 5+ experience in data migration projects, specifically from PeopleSoft to a Cloud Based Data Warehouse system. Strong proficiency in SQL for data extraction and manipulation 8+ Experience with ETL tools and data integration techniques. Experience with databases such as ORACLE, SQL Server, SYBASE, INFORMIX, and DB2 Familiarity with data warehousing concepts, data modeling, and reporting tools. Excellent analytical, problem-solving, and communication skills. Strong attention to detail and commitment to data accuracy. Experience with cloud-based Data Warehouse solutions (e.g., Oracle FDIP, Snowflake, Amazon Redshift, Google BigQuery). x Relevant certifications in data management or ETL tools are a plus. Thanks, and Regards . . . . Vikas Kumar Senior Executive - Recruitment, Okaya Inc 4949 Expy Dr N, Suite 101, Ronkonkoma, NY 11779 Landline: +1-631-267-4883 Extn. 209, Direct no: 281-215-5745 Email [ [email protected] ] || www.okayainc.com GTalk- [email protected] Keywords: access management information technology golang green card Maryland New York Virginia Looking for Business Intelligence Developer//Remote Hyattsville, MD, Washington, DC, Alexandria, VA.//H4,GC EAD,GC and USC [email protected] |
| [email protected] View All |
| 08:37 PM 10-Jan-25 |