Senior Data Engineer – Oracle EBS, Snowflake & Azure Data Factory - Locals Only --- 100 % Onsite

This is a direct client requirement ! "Work sponsorship is not available for this position. Applicants must be a United States citizen, Green card holder or EAD Green Cards at the direction of our client". Reach Shaily Sharma || 908-487-4334 shaily(at)zilliontechnologies(dot)com Senior Data Engineer – Oracle EBS, Snowflake & Azure Data Factory Location - 100 % Onsite - Irving, TX Duration : longterm ongoing with contract to hire Compensation • Rate : $65/hr to $80/hr • This is the targeted compensation range for this role per hour. Please note that this range is provided as a guideline and the final offer will be based on several factors, including but not limited to, skillset and competencies, level of experience, education, certifications, and location. Benefits We offer a comprehensive benefits package including medical, dental, vision, and disability insurance; 401(k) Call notes Date warehousing guru Multiple level solutions Oracle EBS Legacy system - dates back 10 years Querying We need to reach in Oracle pull source tables and write all the report Need expert who can Look at the complexity of pulling reports Oracle, SQL Server, and Snowflake expert The strongest technical requirements are: • Azure Data Factory • Oracle EBS extraction • Snowflake • Advanced SQL • Data pipelines • REST APIs • Incremental loads / MERGE logic • JSON transformation Job Summary The Senior Data Warehouse Engineer is responsible for designing, building, and optimizing enterprise data pipelines and data models to transform complex operational data into scalable, consumable datasets. This role will focus on modernizing data from Oracle EBS and other sources into Azure-based platforms, enabling near real-time data availability through incremental load and UPSERT patterns. This role requires deep expertise in Azure Data Factory, strong SQL engineering skills, and experience working with both structured and semi-structured data, including JSON. The engineer will also integrate external data sources via REST APIs and help standardize data for downstream reporting and analytics. Primary Responsibilities • Design, build, and maintain data pipelines using Azure Data Factory (ADF) • Develop and implement incremental data processing patterns, including UPSERT/MERGE logic • Ingest and transform data from Oracle EBS into Azure SQL and Snowflake • Integrate REST API-based data sources into enterprise data pipelines • Design and maintain data warehouse and data mart structures (star/snowflake schemas) • Transform and normalize semi-structured data (JSON) into relational models • Optimize performance for large-scale datasets (indexing, partitioning, query tuning) • Establish standards for data modeling, naming conventions, and pipeline design • Partner with BI/reporting teams to ensure data is accurate, performant, and consumable • Troubleshoot and resolve issues across ingestion, transformation, and storage layers • Provide technical leadership, mentoring, and best practices in data engineering Required Qualifications • 7–10+ years of experience in data engineering or data warehousing Advanced SQL expertise across: • Oracle • SQL Server / Azure SQL • Snowflake • Strong hands-on experience with Azure Data Factory (ADF) (required) • Advanced SQL query capabilities, including but not limited to: Joins, aggregations, memory tables, CTEs, subqueries (all candidates will be screened for this ability) Experience implementing: • Incremental data loads • UPSERT / MERGE patterns • Experience integrating data from: • Oracle EBS or similarly complex ERP systems • REST APIs as data sources • Managing orchestrated workflows involving placement of sFTP files Strong experience working with: • JSON data structures and parsing in SQL • Hybrid structured and semi-structured datasets • Deep understanding of: • Dimensional data modeling (star/snowflake schema) • Data pipeline architecture and lifecycle Please send qualified resumes directly to : shaily(at)zilliontechnologies(dot)com // 9084874334 Thanks, Shaily Sharma Zillion Technologies Inc. Asst. Director - Talent Acquisition 9084874334 Email: shaily(at)zilliontechnologies(dot)com // 9084874334 "We are an equal opportunity employer. We do not discriminate on the basis of race, color, religion, sex, national origin, age, disability, genetic information, veteran status, sexual orientation, gender identity, or any other characteristic protected by applicable federal, state, or local law."