The Role
Design, develop and execute automated test plans and scripts for ETL workflows. Validate data extraction, transformation, and loading using PL/SQL and ETL tools, identify data quality issues, collaborate with developers to resolve them, and maintain automation frameworks and CI/CD integration.
Summary Generated by Built In
The Skills that are Key to this role
Technical
- Develop and execute test plans, test cases, and test scripts for ETL processes.
- Expertise in validate data extraction, transformation, and loading workflows. Writing PL SQL Queries/Procedures and managing databases, validating data transformations, and ensuring data integrity
- Identify and report data quality issues and inconsistencies.
- Collaborate with ETL developers and data engineers to resolve data quality issues.
- Analyze test results and provide detailed reports to stakeholders.
- Automate repetitive testing tasks to improve efficiency.
- Ensure compliance with industry standards and best practices in data quality assurance.
- Experience with tools like Informatica, Control-M, and DataStage for automating data extraction and transformation processes
- Understanding of data warehousing architectures and schemas to ensure effective data integration
- Experience building, maintaining, and optimizing automated test cases
- Good to have experience with Selenium, Cucumber, Java, Shell, groovy scripting.
- Experience with automated application build, deployment, and support using Maven and Ant
- Experience with performing version control and continuous integration of build, deploy, and test, using Jenkins, Stash
- Designing innovative technical solutions using Automation practices.
- Experience in framework development and maintenance.
- Experience working with AWS is a big plus!
- Experience as a developer (e.g.- Java, Spring) a plus
- Communicate effectively within team as well as with partners
Behavioral
- Strong communication – verbal and written
- Assertive and logical
- Interacts effectively with peers to resolve issues
- Proven success in a fast paced environment
- Ability to diagram and summarize design solutions comfortably to a broad and diverse population
- Ability to deal with ambiguity
- Self-motivated with a high degree of intellectual curiosity
- Is flexible and can make adjustments to changes in operating environment
- Promotes positive and professional work environment
The Skills that are Good to Have for this role
- Financial Services domain experience with exposure to Mutual Funds
- Unix/Linux , Shell scripting, Tomcat, Docker , Scheduling Tool like ControlM
- Experience in agile methodology
The Expertise We’re Looking For
- Bachelor's degree in Computer Science or related subject.
- 3+ years of experience in information technology.
- Financial services experience preferred.
Location: Bangalore
Shift timings: 11:00 AM - 8:00pm
Experience: 3 - 5 Years
Skills Required
- Bachelor's degree in Computer Science or related subject
- 3+ years of experience in information technology
- Develop and execute test plans, test cases, and test scripts for ETL processes
- Validate data extraction, transformation, and loading workflows; write PL/SQL queries and procedures; manage and validate databases
- Experience with ETL and data integration tools (Informatica, DataStage) and scheduling tools (Control-M)
- Build, maintain, and optimize automated test cases and automation frameworks
- Automated application build, deployment, and support using Maven and Ant
- Version control and CI integration using Jenkins and Stash
- Understanding of data warehousing architectures and schemas
- Identify and report data quality issues and collaborate with ETL developers and data engineers
- Strong verbal and written communication skills
- Experience with Selenium, Cucumber, Java, Shell, Groovy scripting
- Experience working with AWS
- Experience as a developer (Java, Spring)
- Financial services domain experience, exposure to Mutual Funds
- Unix/Linux, Shell scripting, Tomcat, Docker, Agile methodology experience
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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.
