Location : ,
Job Title: Data Warehouse Specialist
*Interview will be conducted in person, video conference, or by phone using a standardized set of interview questions. The location of the interview will be at any of the three Places of Performance identified above.
Duties/Responsibilities:
• 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
• Analyze requirements for BI reports and dashboards;
• Analyze data sources for mapping to BI requirements;
• Work closely with customers to determine the best approach for the user community;
• Use BI tools to develop reports, dashboards, and widgets; create and execute test plans;
• coordinate life cycle activities from development to production;
• Create and maintain data models to support requirements;
• Determine the best approach for data delivery depending on data sources and requirements;
• Develop spreadsheets and databases as needed to support interim strategies for data
• To analyze and gather the requirements of BI data from users/customers
• Need a create ETL/ELT for Peoplesoft EPM Datawarehouse
• Maintaining the ERP data warehouse and Ascential/Datastage environments
• To design and develop data models and data mart tables
• To design and develop ETL processes and data pipelines using Data Stage ETL tool.
• To support and maintenance of Production ETL processes and jobs of Data Stage
• To support and fulfill adhoc data requests from customers and management using SQL queries and Excel sheets and to perform data validation, accuracy and its completeness during delivery of the data
• To support other BI team members during development of reports and dashboards for their data needs.
• Document product specifications, create user guides for operations and maintenance
• Support cyber security reviews and implement remediations as required
Education: Graduate degree or equivalent from an accredited college or university with a bachelor’s degree in Management information science, Computer Science, Mathematics, Finance, Business, Accounting, Public Administration, or in a related discipline
Must have minimum experience: (ex:5 years) At least 8 years of progressively responsible, diversified technical application operations and maintenance in a large organization.
Minimum Requirements:
• Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
• Proven experience in data migration projects, specifically from PeopleSoft to a Cloud Based Data Warehouse system.
• Strong proficiency in SQL for data extraction and manipulation
• Experience with ETL tools and data integration techniques.
• 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 in IBM Datastage
• Experience in customizing Peoplesoft delivered maps
• Six (6) months of experience using the Datastage tool and version designated in the Task Order; and
• Excellent communication skills
Preferred Skills:
• Experience with cloud-based Data Warehouse platforms and solutions (e.g., Oracle FDIP, Snowflake, Amazon Redshift, Google BigQuery).
• Relevant certifications in data management or ETL tools are a plus Experience with one or more of the following systems: Maximo, PeopleSoft FSCM, HCM, ELM, PeopleSoft EPM, NextFare, and Trapeze; 3+Years of Experience in building ETL Maps/Sequences using IBM DataStage(IBM Infosphere Information Server) In depth understanding of Data Warehouse Principles Experience in the transit industry. .