Role & responsibilities
Seeking experienced technology professionals with strong Oracle SQL/PLSQL expertise and experience across Informatica ETL, data analysis/modelling, application development, functional/automation testing, and Treasury/Payments applications.
The candidate will work across business and technology teams supporting application development, data analysis, ETL, testing, production support, and integration activities. The role requires strong analytical and troubleshooting capabilities, experience working with complex data and applications, and the ability to translate business and technical requirements into effective solutions.
Core / Common Skills
- Strong Oracle SQL / PL/SQL
- Complex SQL queries including joins, aggregations, filtering and data validation
- Database/data analysis and troubleshooting
- Linux / Unix
- Banking or financial-services application experience
- Agile/Waterfall delivery exposure
- Strong analytical, problem-solving and communication skills
- Experience coordinating with development, testing, business and upstream/downstream teams
Relevant Specialized Skills Candidates should have strong experience in one or more of the following areas:
Informatica / ETL
- Informatica ETL development or ETL testing
- ETL mappings and data validation
- Data warehouse/database testing
- SCD and complex mapping validation
- AutoSys exposure
Data / Techno-Functional
- Data modelling and data architecture
- Requirements analysis and data mapping
- Solid functional/data analysis
- Treasury products including Payments, Deposits, Trade Finance or Liquidity
QA / Automation
- Manual and functional testing
- Automation testing
- Core Java, Cucumber/Gherkin, Selenium
- REST/SOAP and API/microservices testing
- Integration and E2E testing
- Test plans, test cases, regression testing and defect management
- Pega application testing
PL/SQL / Application Development
- Oracle PL/SQL application development
- Oracle query tuning and performance optimization
- Informatica development
- Production application support
- Technical/design analysis
Good to Have
- Treasury/Payments domain knowledge
- SWIFT, CAMT, BAI2, XML, CSV or banking message/file formats
- Starburst
- AWS S3 / Cloud exposure
- JIRA, Bitbucket or other version-control tools
- AI tool exposure
Preferred candidate profile Approximately 38+ years depending on the specialization, with senior/lead candidates expected to have deeper automation, application development, ETL, or Treasury/Payments expertise.
📌 PL/SQL Automation Tester (Chennai)
🏢 Wipro
📍 Chennai