Senior Data Warehouse Engineer (E-Business Suite & Python)
Hello,Greetings!!!This is Abhishek from Jconnect INC. Below is the requirement with my client. Please let me know if you are available for this role.Title: Senior Data Warehouse Engineer (E-Business Suite & Python)Location: RemoteDuration: FulltimeJOB DESCRIPTION:We are seeking a Senior Data Warehouse Engineer with a background in Oracle E-Business Suite (EBS) and Python-based data engineering to design, develop, and maintain enterprise data solutions. The ideal candidate will have hands-on experience building and optimizing data pipelines, integrating ERP data into warehouse environments, and enabling analytics and reporting across business domains such as Finance, Supply Chain, HR, and Manufacturing.Skills:Bachelor's or Master's degree in Computer Science, Information Systems, or related field.8+ years of experience in data warehousing and ETL development, including hands-on experience with Oracle E-Business Suite data structures and APIs.Strong SQL and PL/SQL skills, with experience in query optimization and complex joins.Proficiency in Python for data processing, automation, and integration tasks.Experience with ETL tools such as Informatica, ODI, Talend, or custom Python-based ETL frameworks.Solid understanding of data modeling principles (Kimball or Inmon methodologies).Experience with data orchestration tools (e.g., Apache Airflow, Control-M, or Azure Data Factory).Familiarity with cloud-based data platforms (Snowflake, Redshift, BigQuery, or Oracle Cloud).Knowledge of EBS modules (Finance, SCM, HR, Manufacturing) and underlying data structures.Roles and Responsibilities:Design, develop, and maintain data warehouse architectures supporting enterprise analytics and reporting.Extract, transform, and load (ETL/ELT) data from Oracle E-Business Suite (EBS) and other enterprise systems into the warehouse (e.g., Snowflake, BigQuery, Redshift, or Oracle DW).Develop efficient and reusable Python scripts for data ingestion, transformation, and validation.Build and optimize SQL and PL/SQL queries, stored procedures, and views for high-performance data access.Work with business analysts, functional teams, and ERP specialists to understand data models and reporting needs.Ensure data quality, lineage, and consistency across multiple systems.Participate in data modeling (conceptual, logical, and physical) for warehouse and reporting layers.Automate workflows and data pipelines using Airflow, DBT, or similar orchestration tools.Troubleshoot and optimize data pipelines for performance and scalability.Implement best practices for data governance, metadata management, and security.If you are interested, please send me your updated resume ASAP with below details:Full Name:Current Location/Zip:Contact Number:E-Mail Id:Alternate Email Id:Visa/Work Permit Status:Current Rate/Salary:Expected Base Salary:Notice Period/Availability to Start:Skype ID:Willingness to relocate to job location:Any Relocation Concern (family/house/weather):Current/Previous Employer Name:Preferred Interview timings (Specify Time zone):Any other job opportunity in process & at which stage:Overall Experience Summary:LinkedIn URL:Looking forward for your response..Thanks and Regards,Abhishek SinghJconnect Infotech Inc.168 Barclay Center Ste. 347,Cherry Hill, NJ 08034Contact: 856-770-2379Email: abhi.k@jconnectinc.com