Data Warehouse Specialist L3
Apply NowCompany: Collins Consulting
Location: Washington, DC 20011
Description:
Must be a US Citizen or Green Card holder and local to the Metro DC Area.
Responsibilities:
Skills:
Preferred Skills:
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 support cyber security reviews and implement remediations as required
Skills:
- Looking for 8 years of experience.
- 5+ years of 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
- Excellent communication skills
- 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
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 Ware