ETL ODI Developer – Night Shift open position. Experience:7 + Years Shift: 9PM IST to 6 AM IST Requirements We are seeking a skilled and experienced Data Integration Specialist with over 5 years of experience in designing and developing data solutions using Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in data modeling, ETL/ELT processes, and SQL, along with exposure to Python scripting for API-based data ingestion. Key Responsibilities: Design, develop, and maintain functions and stored procedures using Oracle Data Integrator (ODI). Create and document data warehouse schemas, including fact and dimension tables, based on business requirements. Develop and execute SQL scripts for table creation and collaborate with Database Administrators (DBAs) for deployment. Analyze various data sources to identify relationships and align them with Business Requirements Documentation (BRD). Design and implement Extract, Load, Transform (ELT) processes to load data from source systems into staging and target environments. Validate and profile data using Structured Query Language (SQL) and other analytical tools to ensure data accuracy and completeness. Apply best practices in data governance, including query optimization, metadata management, and data quality monitoring. Demonstrate strong data modeling skills to support scalable and efficient data architecture. Utilize Python to automate data collection from APIs, enhancing integration workflows and enabling real-time data ingestion. Investigate and resolve data quality issues through detailed analysis and root cause identification. Communicate effectively with stakeholders through strong written, verbal, and analytical skills. Exhibit excellent problem-solving and research capabilities in a fast-paced, data-driven environment. Job Type: Full-time Work Location: In person
Requirements Prior Experience: 7+ Yrs We are seeking a highly skilled and detail-oriented Performance Engineer/Tester with experience in Oil & Gas Drilling applications to join our engineering team. This role focuses on ensuring the performance, scalability, and reliability of critical real-time and data-intensive software systems used in drilling operations. You will work closely with developers, domain experts, and product managers to simulate real-world usage, design performance test strategies, identify bottlenecks, and help optimize application performance under various load conditions. Key Responsibilities • Develop, execute, and maintain performance test plans, scripts, and scenarios for drilling applications. • Analyze system behavior under stress, load, and endurance conditions to identify performance bottlenecks and work with development teams for resolution. • Use tools such as LoadRunner, JMeter, or custom scripts to simulate operational environments typical in drilling operations. • Collaborate with software architects, developers, and DevOps to optimize throughput, latency, and resource utilization. • Monitor key performance indicators (CPU, memory, I/O, network) during test executions using tools like New Relic and correlate results with backend logs and telemetry data. • Create performance benchmark baselines and contribute to SLAs definition for system responsiveness and throughput. • Support CI/CD pipelines by integrating performance testing into automated workflows (e.g., Jenkins, Azure DevOps). • Participate in code and architecture reviews to assess and improve system scalability and resiliency. • Generate detailed test reports and provide actionable recommendations to stakeholders. Required Qualifications • Bachelor’s degree in computer science, Engineering, or related field. • 3+ years of experience in performance engineering or testing in enterprise or industrial software. • Familiarity with oil and gas drilling workflows, real-time data protocols. • Proficient in scripting languages (e.g., Python, PowerShell, Bash) for test automation. • Experience with monitoring tools like New Relic, Dynatrace. • Solid understanding of network latency, threading/concurrency, memory profiling, and database performance (SQL/NoSQL). • Strong problem-solving skills and ability to interpret performance metrics into actionable insights. Preferred Qualifications • Experience with cloud platforms such as AWS, Azure, or private data centers supporting oilfield operations. • ISTQB or other performance testing certifications. Soft Skills • Strong communication and documentation skills. • Ability to work independently and in a fast-paced, agile team environment. • Comfortable interacting with both technical and non-technical stakeholders. Job Type: Contractual / Temporary Contract length: 06 months Pay: ₹100.00 per year Work Location: In person