Nisum is a leading global digital commerce firm headquartered in California, with services spanning digital strategy and transformation, insights and analytics, blockchain, business agility, and custom software development. Founded in 2000 with the customer-centric motto “Building Success Together®,” Nisum has grown to over 1,800 professionals across the United States, Chile,Colombia, India, Pakistan and Canada. A preferred advisor to leading Fortune 500 brands, Nisum enables clients to achieve direct business growth by building the advanced technology they need to reach end customers in today’s world, with immersive and seamless experiences across digital and physical channels.
What You'll Do
Develop, debug, and optimize PL/SQL scripts for data transformation and integration
Rewriting queries and PL/SQL code to improve efficiency, scalability, and response time
Write and maintain scripts for data extraction, transformation, and loading (ETL) between various databases and systems.
Perform data migration, ensuring data integrity during the process.
Perform root cause analysis and troubleshoot database issues, including application performance, errors, and system downtime.
What You Know
A minimum 6+ years of PL/SQL Developer experience is required.
This role is purely for handling oracle data and preparation of SQL scripts for data updates, migration
Resolve database-related issues by performing recovery, patching, and upgrading.
Work closely with other developers, DBAs (Database Administrators), business analysts, and project managers to deliver high-quality solutions.
Participate in code reviews, peer programming, and provide mentoring to junior developers
Deep understanding of Oracle Database (version 11g, 12c, or higher), its architecture, and features like tablespaces, indexes, constraints, etc.
Experience working with Oracle database tools like SQL*Plus, SQL Developer, TOAD, and Oracle Enterprise Manager.
Excellent written and verbal communication skills.
Nice to have Java programming knowledge
Education
Bachelor’s degree in Computer Science/Engineering or equivalent work experience
Benefits
In addition to competitive salaries and benefits packages, Nisum India offers its employees some unique and fun extras:
Continuous Learning - Year-round training sessions are offered as part of skill enhancement certifications sponsored by the company on a need basis. We support our team to excel in their field.
Parental Medical Insurance - Nisum believes our team is the heart of our business and we want to make sure to take care of the heart of theirs. We offer opt-in parental medical insurance in addition to our medical benefits.
Activities -From the Nisum Premier League's cricket tournaments to hosted Hack-a-thon, Nisum employees can participate in a variety of team-building activities such as skits, and dances performance in addition to festival celebrations.
Free Meals - Free snacks and dinner is provided on a daily basis, in addition to subsidized lunch.
