Who are we?
For the past 20 years, we have powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization. For a brief 1 minute video about us, you can check https://youtu.be/uJWBWQZEA6o.
What will you do? What are we looking for?
Key Responsibilities:
- Design, develop, and optimize complex PL/SQL procedures, packages, triggers, and functions.
- Write efficient Python scripts for data transformation, ETL automation, system integration, and reporting tasks.
- Analyze business requirements and translate them into technical specifications.
- Troubleshoot and resolve performance issues in PL/SQL queries and stored procedures.
- Ensure data integrity, quality, and availability across systems.
- Integrate data between systems using Python (e.g., REST APIs, flat files, database connectors).
- Support deployment, monitoring, and maintenance of applications in production.
- Collaborate with data engineers, analysts, and application developers to deliver data-driven solutions.
- Proficient in Oracle and PostgreSQL database administration, with strong skills in Python for automation, data modeling, and experience using GitLab and Jira for version control and project tracking.
Required Qualifications:
- 3+ years of experience in software development with strong proficiency in PL/SQL and Python.
- Deep understanding of Oracle Database and SQL performance tuning.
- Experience working with large datasets and data manipulation.
- Familiarity with version control tools such as Git.
- Ability to write clean, maintainable, and scalable code.
- Strong debugging and problem-solving skills.
Preferred Qualifications:
- Experience with job schedulers and ETL tools (e.g., Apache Airflow, Control-M, Informatica).
- Familiarity with REST APIs and JSON/XML data formats.
- Exposure to cloud platforms (AWS) is a plus.
- Knowledge of data modeling and database design best practices.
Skills Required
- 3+ years of software development experience
- Strong proficiency in PL/SQL (procedures, packages, triggers, functions)
- Strong proficiency in Python for data transformation and automation
- Deep understanding of Oracle Database and SQL performance tuning
- Experience working with large datasets and data manipulation
- Proficient in PostgreSQL database administration
- Familiarity with version control tools such as Git (experience with GitLab)
- Experience using Jira for project tracking
- Ability to write clean, maintainable, and scalable code
- Strong debugging and problem-solving skills
- Experience with job schedulers and ETL tools (Apache Airflow, Control-M, Informatica)
- Familiarity with REST APIs and JSON/XML data formats
- Exposure to cloud platforms (AWS)
- Knowledge of data modeling and database design best practices
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
.jpeg)
