Senior ODI Developer
1 month ago
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
- 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.
We have other current jobs related to this field that you can find below
-
Senior ODI Developer
4 weeks ago
Washington, United States HarmonyTech Full timeJob DescriptionJob DescriptionHarmonyTech Inc. is seeking a talented and experienced ODI Developer to join our dynamic team. As a Software Developer at HarmonyTech, you will provide data architecture support to meet the business and technical requirements for the existing DW. The ideal candidate should have a strong background in ETL design and development...
-
Senior ODI/OAS Developer
4 weeks ago
Washington, United States International Logic Systems, Inc. Full timeILS is looking for a Sr. ETL (ODI/OAS) Developer to support one of our projects in Washington, DC. This resource will be responsible for designing Enterprise-level solutions for multi-dimensional databases, will design and plan BI solutions, execute strategies for database backup, and provide documentation implementation and quality assurance....
-
Senior ODI/OAS Developer
2 weeks ago
Washington, United States INTERNATIONAL LOGIC SYSTEMS, INC. Full timeILS is looking for a Sr. ETL (ODI/OAS) Developer to support one of our projects in Washington, DC. This resource will be responsible for designing Enterprise-level solutions for multi-dimensional databases, will design and plan BI solutions, execute strategies for database backup, and provide documentation implementation and quality assurance. Make your...
-
ODI Solutions Architect
2 weeks ago
Washington, United States ECS Federal Full timeECS is seeking a ODI Solutions Architect. Ready to apply Before you do, make sure to read all the details pertaining to this job in the description below. THIS POSITION IS HYBRID.Job Description: ECS is seeking an ODI solutions Architect to support our PBES program in the Pentagon. Responsibilities and required skills. Expert in migration and conversion of...
-
OBIEEOAS Developer
1 week ago
Washington, United States i360technologies Full timeJob Description Execute requirements analysis, process review, fit gap analysis against an existing RTM Design and develop reports using OBIEE Must have demonstrated experience and understanding of Oracle R12, R12 tables, security layers and architecture Demonstrate expertise in managing and developing using all components required for developing reporting...
-
OBIEEOAS Developer
4 weeks ago
Washington, United States i360technologies Full timeJob Description Execute requirements analysis, process review, fit gap analysis against an existing RTM Design and develop reports using OBIEE Must have demonstrated experience and understanding of Oracle R12, R12 tables, security layers and architecture Demonstrate expertise in managing and developing using all components required for developing reporting...
-
BI Developer
1 week ago
Washington, United States i360technologies Full time**Company Description** - Meet with clients to thoroughly understand their business requirements and objectives. - Translate complex business needs into clear and concise technical specifications for BI solutions. - Document detailed reporting and dashboard requirements based on client discussions and needs. - Develop robust data quality checks and...
-
OBIEE/OAS Developer
2 weeks ago
Washington, United States i360technologies Full timeJob DescriptionJob DescriptionCompany DescriptionAt 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...
-
OBIEE/OAS Developer
3 days ago
Washington, United States i360technologies Full timeJob DescriptionJob DescriptionCompany DescriptionAt 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...
-
OBIEE/OAS Developer
4 weeks ago
Washington, United States i360technologies Full timeJob DescriptionJob DescriptionCompany DescriptionAt 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...
-
Extract, Transform, and Load
2 weeks ago
Washington, United States i360technologies Full time**Company Description** - Designing, developing, testing, and maintaining ETL processes. - Participate in business requirement sessions and document requirements, for each project and/or 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...
-
BI Developer
2 weeks ago
Washington, Washington, D.C., United States i360technologies Full timeCompany Description Meet with clients to thoroughly understand their business requirements and objectives. Translate complex business needs into clear and concise technical specifications for BI solutions. Document detailed reporting and dashboard requirements based on client discussions and needs. Develop robust data quality checks and incorporate them into...
-
Solutions Architect
3 weeks ago
Washington, United States ECS Federal, Inc Full timeECS is seeking a ODI Solutions Architect. THIS POSITION IS HYBRID. Job Description: ECS is seeking an ODI solutions Architect to support our PBES program in the Pentagon. Responsibilities and required skills. Expert in migration and conversion of ODI versions Tune application SQL queries for performance optimization. Convert user stories into...
-
BI Developer
4 weeks ago
Washington, United States HarmonyTech Full timeJob DescriptionJob DescriptionHarmonyTech Inc. is seeking a talented and experienced BI Developer to join our dynamic team. As a BI Developer at HarmonyTech, you will create reports and work with a team consisting of developers and solution architects. The ideal candidate should have a strong background in OAS Oracle Data Visualization (DV), Microsoft Power...
-
BI Developer
4 weeks ago
Washington, United States HarmonyTech Full timeJob DescriptionJob DescriptionHarmonyTech Inc. is seeking a talented and experienced BI Developer to join our dynamic team. As a BI Developer at HarmonyTech, you will create reports and work with a team consisting of developers and solution architects. The ideal candidate should have a strong background in OAS Oracle Data Visualization (DV), Microsoft Power...
-
EEO Investigator
2 weeks ago
Washington, United States AdNetAccountNet Inc. Full timeDuring the duration of the contract, the Contractor that fills the roles of an EEO Specialist working under the Complaints Processing Program will be responsible for performing associated tasks with the following ODI programs that are found within federal government EEO programs: EEO Complaints Processing Advisement Management of ODI Contacts Addressing ODI...
-
Senior Data Architect
4 weeks ago
Washington, United States HarmonyTech Full timeJob DescriptionJob DescriptionHarmonyTech Inc. is looking for an experienced Data Architect to become an integral part of our team. This role will focus primarily on managing a team of BI & ODI_ETL Developers and business analysts. This candidate will have a strong background in Oracle Data Integrator (ODI).The work shall be performed at the client’s...
-
Oracle Integration Cloud Jr. Developer
3 weeks ago
Washington, United States Collins Consulting Full timeThis is a hybrid position and will need to be onsite 2-3 days a week. Must be a US Citizen or Permanent resident. Statement of Work: The contractor will be modernizing the financial business processes for USAC, to include implementing Oracle EBS. There are two workstreams - one for the Federal Universal Service Fund and one for the commercial USAC entity....
-
Senior Oracle Database Administrator
4 weeks ago
Washington, Washington, D.C., United States SAIC Career Site Full timeDescription SAIC is looking for a Senior Oracle DBA/Fusion Middleware Application DBA to join our team in Washington, DC. The Senior Oracle DBA/FMW Application DBA is responsible for supporting our current versions and future upgrades of Oracle Technologies used in our Environment. This position is also responsible for the authentication and authorization...
-
Senior Java developer
4 weeks ago
Washington, United States Ark Solutions Full timeRole: Senior Java developer Remote The work will focus on the discovery and advancement of open source solutions in the laboratory domain to address current interoperability challenges. Position Details: Seeking a Senior Java developer to support a Federal Health Client. The work will focus on the discovery and advancement of open-source solutions in the...