PLSQL Developer
- Kiya.ai
- 5 - 7 years
- Mumbai
- 2 months ago
- Email to a friend
- Report this job
Job Description
Hi All,
We have an urgent opening for the role of PLSQL Developer for one of our leading Investment Banking client in Mumbai.
Location : Mumbai
Experience : 5-7 years
Responsibilities
Direct Responsibilities
- Design, develop, test, and implement ETL processes using PL/SQL, Python and Unix shell scripting to extract data from various sources, transform it into a suitable format, and load it into target systems.
- Develop and maintain complex SQL scripts, stored procedures, and functions to support ETL processes.
- Write Python and Unix shell scripts to automate ETL tasks, such as data file transfers, data validation, and error handling.
- Collaborate with data architects, business analysts, and other stakeholders to understand data requirements and develop ETL solutions that meet business needs.
- Troubleshoot ETL issues, identify root causes, and implement fixes to ensure data integrity and system reliability.
- Optimize ETL processes for performance, scalability, and reliability, and implement data quality checks to ensure data accuracy and consistency.
- Develop and maintain documentation of ETL processes, including data flow diagrams, data dictionaries, and technical notes.
- Participate in code reviews and contribute to the improvement of the overall quality of the codebase.
- Stay up-to-date with new technologies and trends in ETL development, and apply this knowledge to continuously improve ETL processes and systems.
Technical & Behavioral Competencies
- At least 5 years of experience in ETL development, with a focus on PL/SQL, Python and Unix shell scripting for ETL projects.
- Strong knowledge of PL/SQL, including SQL, stored procedures, functions, and packages.
- Experience with Python and Unix shell scripting, including shell scripts, cron jobs, and automation tools.
- Familiarity with data warehousing concepts, data modeling, and data governance.
- Good to have experience with ETL tools, such as Informatica, Oracle SQL Loader, Oracle Data Integrator, or Talend.
- Strong problem-solving skills, with the ability to analyze complex issues and develop creative solutions.
- Excellent communication and collaboration skills, with the ability to work effectively with technical and non-technical stakeholders.
- Ability to work in a fast-paced environment, with multiple priorities and deadlines.
Behavioral Competencies
- Excellent verbal and written communication skills.
- Conduct meetings with global stakeholders, prepare minutes & summaries.
- Assertiveness, Negotiation, Proactiveness & Prioritization skills are important.
- Discipline in documenting, following up on issues and changes.
- Experience in interacting with global stakeholders and independently managing discussions.
If you are interested , please share your resumes to as***********y@ki*a.ai
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: Software DevelopmentRole: Software Development - OtherEmployement Type: Full timeContact Details:
Company: Kiya.aiLocation(s): Mumbai
Keyskills: PLSQL Unix Shell Scripting Python Unix Shell Scripting
Similar positions
Kiya.ai
Kiya.ai (Infrasoft Tech) is a leading #FinTech Digital Solutions provider for the Banking and Financial sector. Kiya.ai is one of the most innovative digital solutions providers serving financial institutions and governments globally. Our deep domain expertise in Financial Services, Digital Payment...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in