Data Warehouse Specialist L3 - Collins Consulting Inc

Must be a US Citizen and local to the Metro DC Area.

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.
• 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
• Excellent communication skills

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

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