Job Description

Job profile: SQL Developer with OFSAA (Oracle Financial Services Analytical Applications) knowledge. Experience: 8-10 years Job Summary: Skilled SQL, and SSIS developer, complemented by minimum experience Oracle OFSAA. Other skills include Control-M, PowerShell, and Unix. Key Responsibilities: •Lead the design, development, and implementation of OFSAA solutions. •Develop and optimize complex SQL queries and database procedures. •Build and maintain ETL processes using SSIS to support data integration and reporting. •Manage job scheduling and automation using Control-M. •Write and maintain PowerShell scripts for automation and system management tasks. •Perform Unix shell scripting and administration to support development and production environments. •Collaborate with business stakeholders and translate business requirements into technical specifications. •Lead and mentor a team of developers, ensuring best practices and quality standards. •Communicate effectively with cross-functional teams and stakeholders to provide project updates and resolve issues. •Troubleshoot and resolve technical issues related to OFSAA, SQL, SSIS, and related tools. •Ensure adherence to project timelines and deliverables. Required Skills: •Strong expertise in OFSAA (Oracle Financial Services Analytical Applications). •Advanced SQL skills for data manipulation and reporting. •Proficient in SSIS for ETL development. •Experience with Control-M for job scheduling and automation. •Knowledge of PowerShell scripting. •Familiarity with Unix/Linux environments and shell scripting. •Excellent communication and interpersonal skills. •Proven leadership and team management experience. •Ability to understand and handle business requirements and communicate effectively with stakeholders