Informatica Oracle Developer

Required Skills & Qualifications:Minimum 6-8 years of hands-on experience in ETL development, data warehousing, and business intelligence.Extensive hands-on experience with Informatica PowerCenter (versions 9.x/10.x) including Designer, Workflow Manager, Workflow Monitor.Extensive expertise in Oracle SQL and PL/SQL including advanced concepts (e.g., analytical functions, complex joins, dynamic SQL, exception handling).Proven experience with Oracle Database 11g, 12c, 19c or higher.Strong understanding of ETL methodologies, data warehousing principles, and dimensional modeling (Star Schema, Snowflake Schema).Experience with performance tuning of Informatica PowerCenter mappings/workflows and large-scale Oracle databases.Proficiency in shell scripting (e.g., Bash, Korn Shell) for automation of ETL jobs and pre/post-session commands.Familiarity with version control systems (e.g., Git).Excellent problem-solving, analytical, and debugging skills.Strong communication (verbal and written) and interpersonal skills.Ability to work independently and as part of a collaborative team in a fast-paced environment.Bachelors degree in Computer Science, Information Technology, Engineering, or a related field.Preferred Skills:Experience with Oracle-plsql ETL tools (e.g., Informatica).Familiarity with Agile development methodologies. Proficiency in Git for source code control, including code migration and deployment workflows.Demonstrated ability to write and optimize complex SQL queries for large datasets.Design, develop, test, and maintain robust and highly efficient Oracle PL/SQL stored procedures, functions, packages, and database triggers.Implement complex business logic, data transformations, and automated tasks using PL/SQL to support ETL processes and application requirements.