Company Description
At i360technologies, we help our employees succeed. Competitive pay, robust benefits for full-time employees, and professional development opportunities are a few reasons that i360 is a great place to build your career. Founded in 1999, i360 is a growing GOVCON professional services company looking for motivated individuals excited to embrace a fast-paced environment while applying strategic problem-solving skills, excellent work ethic, and positive energy to an already first-class team. You have a home with us if you enjoy solving complex business problems through business consulting and technology implementation.
At i360, we offer unlimited professional growth and career possibilities.This position will mainly support the following task areas:
- Provide data architecture support to meet the business and technical requirements for the existing DW.
- Provide ETL design and development services that enable the client to make major enhancements to its current DW.
Their focus will be on the integration between the Client systems and the DW. The integration is accomplished using the ETL process, and the tool the Client's tool is ODI.
Job Description
- Designing, developing, testing, and maintaining ETL processes
- participate in business requirement sessions and document requirements for change requests
- perform data profile and data analysis of source system data and identify all source data issues.
- perform data analysis of client’s reporting systems.
- participate in business requirement sessions and document requirements, for each project and/or change request.
- design ETL process based on the business requirements.
- Develop ETL process and unit test.
- design and develop ETL process using Oracle Data Integrator (ODI)
- prepare test data to validate all scenarios, including invalid data scenarios.
- develop test cases and test scripts, and execute and support UAT activities as needed.
- Perform detailed requirements analysis for submitted change requests (CRs).
- Identify and maintain subject areas and conceptual entities
- Design and develop Data Flow Diagram and process diagram
- Develop logical and physical data models
- Develop database DDL scripts
- Perform data profiling
- Develop a process to perform data quality checks
- Manage and maintain metadata, including data transformation
- develop and document data exchange framework for internal and external data
Qualifications
- Oracle Data Integrator (ODI) required
- Oracle Database Engine required
- Oracle Analytic Server (OAS) and Data Visualization is preferred
- Oracle Analytics Publisher (aka BI Publisher) is preferred
- Microsoft Power BI is preferred
- Nice to have: knowledge of Salesforce/Hubspot
- Strong knowledge of Relational and Dimensional modeling techniques of Data warehouse (EDS/Data marts) concepts and principles (Kimball/Inman) - Star, Snowflake schema, Surrogate keys, and Normalization/Denormalization.
- Strong knowledge of Slowly Changing Dimensions (SCDs) and their implementation (Type1, Type 2, and Type 3) to keep track of historical data
- Hands-on experience with ETL tools such as ODI, Informatica
- Bachelor’s degree
- 12 years of professional work experience
- This role is currently on-site but may become hybrid.
Additional Information
i360 is an Equal Opportunity Employer - Minority/Female/Veteran/Disability
All qualified applicants will receive consideration for employment regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or status within any other protected group.
Benefits
- Holidays - Eleven
- Adoption Assistance
- Tuition Reimbursement
- Technology Reimbursement
- Utilization Compensation Plan
- Retirement Plan (401k) Matching
- Family Leave, Maternity, Paternity
- Short-Term & Long-Term Disability
- Life Insurance (Basic, Voluntary & AD&D)
- Health Care Plan (Medical, Dental & Vision)
- Paid Time Off (0-3 years - 15 Days PTO | 3+ years 20 Days)
What You Can Expect from Us
- At i360technologies, we help our employees succeed. Competitive pay, robust benefits for full-time employees, and professional development opportunities are a few reasons that i360 is a great place to build your career.
- Meaningful work. Our employees often tell us that their work gives them a sense of purpose as it supports many federal agencies.
- Leadership that cares. Our leadership team has prioritized creating a culture that appreciates and takes good care of its people. As a result, being an employee of i360 means you are part of the i360 family, and you matter.
- Flexibility. We value work-life balance because we know that happy employees create happy customers.
