Oracle OCI ETL Developer

Carolina Beach, North Carolina, United States

Applications have closed

eTelligent Group

We connect thought leaders together with experts to assist our customers to address challenges and solve problems.

View company page

Company Overview:

For the past 15+ years, eTelligent Group has consistently delivered excellent services that are demonstrated through our exceptional past performances. As a WOSB, and small business, we have distinguished our company as effective problem solvers with innovative, scalable solutions. We integrate CMMI Dev Level 3 processes, tools, and techniques with innovative, cost-efficient, and secure solutions to address complex challenges. We also hold ISO 9001:2015, ISO/IEC 27001:2013, and ISO/IEC 20000-1:2018 certifications.

Task Description:

This individual will act as the Oracle OCI ETL Developer and will be responsible for developing ETL application using Informatica for high volume data. This position requires demonstrated experience using the Informatica Suite of tools including Power Center, B2B, and Power in an Agile/Scrum environment. This position will develop Extract, Transformation and Loading (ETL) procedures for implementing data integration and data loading tasks in support of CDR Data Repository from client and non-client data sources. The Database environment for the project is Oracle and for the data sources, it will vary depending upon the data source (XML, flat file, Relational Databases).  Prior experience with SQL on Oracle databases will be required.

Primary Duties:

  • Develop new ETL application using Informatica Power Center to load large amount of data from multiple data sources into CDR/IRDB Repository using Oracle database.
  • Develop Data Integration procedures using Informatica suite of tools including B2B and Power Exchange.
  • Develop SQL programs and Stored Procedures as required for the ETL processes and Data Integration activities.
  • Provide support to technical team, write the necessary required documentation as per the Client’s development methodology for ETL processes, and Develop unit test plan, test cases and resolve ETL related test problems.
  • Coordinate the DRIVE build deployment with EAD team from EST to PROD.

Required skills/Level of Experience:

  • Demonstrated experience in designing ETL processes using Informatica for high-volume, complex data environments in an Agile environment– 2 years
  • Demonstrated Strong experience using the Informatica Suite of Tools - Power Center, Power Exchange, B2B Data Transformation – 2 years
  • Strong experience in the design and development of mappings, transformations, sessions, and workflows in PowerCenter – 2 years
  • Strong experience in SQL in the Oracle environment – 3 years
  • Data warehouse data modeling experience – 2 years
  • Develop and implement solution against identified masked data issues while function/performance testing – 1 year

Qualifications:

  • Bachelor’s or Master's Degree in Computer Science, Information Systems, Engineering or related field.
  • Minimum 5 years of related experience.
  • Candidates must be a US Citizen or a Legal Permanent Resident (Green Card status) for at least three (3) years, and Federal Tax compliant.

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Tags: Agile Computer Science Data warehouse Engineering ETL Informatica Oracle RDBMS Scrum SQL Testing XML

Region: North America
Country: United States
Job stats:  1  0  0
Category: Engineering Jobs

More jobs like this

Explore more AI, ML, Data Science career opportunities

Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.