Job Description

We are seeking an experienced Oracle Developer with expertise in AWS cloud services and Informatica for ETL processes. The ideal candidate will have strong skills in Oracle PL/SQL development, database optimization, and cloud integration while leveraging Informatica for data transformation and migration. Key Responsibilities: 1. Oracle Database Development Develop and optimize PL/SQL scripts, stored procedures, triggers, and functions. Perform database tuning, indexing, and performance optimization . Manage schema design, data modeling, and query optimization . Ensure data security, integrity, and compliance with best practices. 2. AWS Cloud Integration Deploy, configure, and optimize Oracle databases in AWS RDS or EC2 instances . Work with AWS services such as S3, Lambda, Glue, Redshift, and DynamoDB for data processing. Implement high availability and disaster recovery solutions using AWS tools. Automate deployments using CloudFormation, Terraform, or AWS CLI . 3. Informatica ETL Development Design and develop ETL pipelines using Informatica PowerCenter/Cloud . Perform data extraction, transformation, and loading (ETL) from various sources into Oracle databases. Optimize and troubleshoot data workflows and performance bottlenecks . Integrate Informatica with AWS services for cloud-based data processing . 4. RESTful API & ORDS Development (Optional) Develop and manage REST APIs using Oracle REST Data Services (ORDS) . Integrate APIs with front-end applications, third-party tools, and AWS Lambda functions . 5. General Responsibilities Collaborate with cross-functional teams to support business requirements. Document database architecture, stored procedures, and ETL workflows . Monitor database performance and resolve critical issues proactively . Work on CI/CD automation for database deployments .