ETL Developer - PLSQL, Python, Unix Shell

The Senior Developer will be a part of the ISPL Mumbai IHC ETL projects team. The developer position will primarily work on PL/SQL, Python, Unix shell scripting, ETL and data warehousing tools and Autosys

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.

• 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.