Senior ODI Developer
4 weeks ago
The work shall be performed at the client’s location in Washington D.C. All candidates shall be U.S. citizens, have lawful permanent resident status, or possess a valid “green card” or equivalent.
Responsibilities:
- 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.
Requirements:
- Minimum of twelve (12) years of relevant solution development experience
- At least five (5) years experience with Oracle Data Integrator (ODI) required
- At least five (5) years experience with 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
- Bachelors in computer science or related field of study, required
If you are interested and feel that you would excel in the position, we invite you to apply. During this phase of our recruiting effort, we will not be able to accept telephone calls. Only those candidates meeting the requirements will be contacted. No recruiters please.
About HarmonyTech
We have been delivering information technology services and solutions across the Federal government and commercial clients for over a decade. Our employees are the most important assets of our company because they delivery value and care for our clients. We are a company of passionate technologist constantly evolving in our understanding and application of technology to best fulfill our client’s mission needs. We operate under a flat and efficient organizational structure to ensure our hand-picked consultants have the flexibility to take risks and be innovative. We typically work in small, agile teams as we design and develop solutions to address our client’s business challenges. Our success is measured with every satisfied customer and employee.
Why you want to join us
- You have a passion for solving our customers complex business problems
- Awesome learning and professional development opportunities
- A culture built on teamwork and excellence
Benefits
HarmonyTech offers a highly competitive salary and benefits package including:
- Medical/Dental/Vision Insurance (company contributes 80% of the entire premium)
- Short/Long Term Disability Coverage
- Life and AD&D Insurance
- 401(k) Retirement Plan with Company Match
- Tuition Reimbursement
- Employee Referral Bonus
- Paid Federal Holidays
- Accrued Paid Time Off
- Click the benefits package link above to check out the benefits we offer
Legal
HarmonyTech believes in a policy of equal employment and opportunity for all people based on merit. We are an Equal Opportunity Employer (EEO) and Drug Free Workplace Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or national origin or any other category protected by applicable federal, state or local laws.
The statements herein are intended to describe the general nature and level of work being performed by employees and are not to be construed as an exhaustive list of responsibilities, duties, and skills required of personnel. Additionally, they do not establish a contract for employment and are subject to change at the discretion of HarmonyTech.
Powered by JazzHR
pVsMxHwft6
-
Senior ODI 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...
-
Senior ODI 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...
-
Senior ODI 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...
-
Senior ODI/OAS Developer
3 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
7 days 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
22 hours 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
1 week 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
2 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...
-
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...
