Dreampath Services
Website:
ondreampath.com
Company:
https://www.linkedin.com/company/dreampath-services
Seniority: Mid-Senior level
Industries: IT Services and IT Consulting
Job details:
Job Role : ETL Developer (Oracle PL/SQL, DataStage)
Location: Hyderabad / Bengaluru
Experience: 5+
Work Mode: Hybrid
Work Timings: 2:00 PM – 11:00 PM
Interview Mode: Virtual (2 Rounds)
Job Overview
We are seeking skilled ETL Developers with strong expertise in Oracle PL/SQL and ETL development to join our growing data engineering team. The ideal candidate will have hands-on experience in designing, developing, and supporting ETL processes, working with large datasets, and delivering high-quality solutions in an Agile environment.
The role requires strong technical capabilities, effective client communication skills, and a solid understanding of the Software Development Life Cycle (SDLC).
Key Responsibilities
- Design, develop, test, and maintain ETL workflows and data integration solutions.
- Develop and optimize complex Oracle PL/SQL procedures, functions, packages, and queries.
- Build and support ETL processes using DataStage.
- Monitor, troubleshoot, and resolve production issues related to ETL jobs and data processing.
- Work with scheduling and batch processing tools such as Autosys.
- Collaborate with business stakeholders, architects, and cross-functional teams to understand requirements and deliver solutions.
- Participate in Agile ceremonies including sprint planning, daily stand-ups, retrospectives, and reviews.
- Ensure adherence to SDLC processes, coding standards, and best practices.
- Perform impact analysis, root cause analysis, and performance tuning of ETL processes.
- Drive client communication and provide regular project updates.
Required Skills
- 3–5 years of experience in ETL Development.
- Strong hands-on experience with Oracle PL/SQL.
- Experience with IBM DataStage.
- Exposure to Autosys scheduling tool.
- Strong understanding of ETL concepts, data warehousing, and batch processing.
- Experience working in Agile development environments.
- Good understanding of SDLC methodologies and processes.
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management abilities.
Preferred Qualifications
- Experience working in enterprise-scale data integration projects.
- Knowledge of performance tuning and optimization techniques.
- Exposure to data migration and data quality initiatives.
- Ability to work independently and manage client interactions effectively.
Click on Apply to know more.
