Oracle ETL Architect- C2C Contract Position
Menands, NY, USA
Contract Senior-level / Expert USD 120K - 122K
Fortuna
Are you passionate about architecting efficient data solutions within the Oracle ecosystem? Do you thrive in designing and optimizing Extract, Transform, Load (ETL) processes to drive data-driven insights and decision-making?
As an Oracle ETL Architect, you will play a pivotal role in designing, implementing, and optimizing ETL solutions using Oracle technologies. You will collaborate closely with stakeholders to understand data requirements, design scalable ETL architectures, and ensure seamless data integration across systems. Your expertise in Oracle databases, ETL tools, and data modeling will be instrumental in driving the success of our data initiatives.
If you are a proactive problem-solver with a knack for optimizing data workflows and a passion for leveraging Oracle technologies to unlock the full potential of data, we want to hear from you.
This position is 100% onsite in Menards, NY and a C2C contract for 30 months.
WHAT YOU'LL DO:
- Working with large and complex Oracle data warehouses, data marts and OLTP databases.
- Overseeing the creation/modification of Oracle database tables of the appropriate type for the situation.
- Writing/executing SQL for querying various Oracle databases as well as the Informatica Metadata Repository for validating unit and QA testing, monitoring, and for investigating integrity issues.
- Guiding the ETL team in the development and monitoring of ETL processes and test plans using Informatica Power Center and Rhapsody.
- Guiding the ETL team in shaping, enhancing and recommending best practices to the overall ETL (Informatica/Rhapsody) architecture.
- Investigating and resolving difficult design and build issues, data loading and data integrity issues.
Performance tuning Informatica/Rhapsody workflows. - Using Informatica/Rhapsody to develop ETL mappings and workflows including the use of mapplets, reusable transformations and worklets.
WHAT YOU'LL BRING:
-
Experience (12+ Years) Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.
-
84 Months Experience writing complex SQL, PL/SQL (stored procedures/functions), with Oracle 12c or higher, including 19c, to Informatica mappings.
-
48 months Experience developing Rhapsody routes, including Rhapsody 7, acquiring and managing millions of records of data including XML and HL7 message formats.
-
84 Months Experience using Informatica 8.x or higher, including 10.2, in a data warehouse environment including warehousing concepts, design and development of complex mappings.
-
84 Months Experience with Informatica Data Quality 8.x or higher, including 10.2, processes, approaches, measurement techniques and business cases for data profiling, data cleansing, standardization, match and merge.
-
84 Months Experience specifying and conducting system testing (e.g. unit, integration, regression, load, performance) and user acceptance testing.
-
72 Months Experience working with Health Data with HIPAA, HL7 or similar standards.
Tags: Architecture Data quality Data warehouse ETL HL7 Informatica Oracle SQL Testing XML
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.
- Open Marketing Data Analyst jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Principal Data Engineer jobs
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Research Scientist jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs