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.
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
Photon Chennai, Tamil Nadu, IND Office
DLF IT Park 1/124 Mount Poonamallee Road Sivaji Gardens Manapakkam , Chennai, India, 600089
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves managing finance change, regulatory reporting, project management, and software testing, requiring extensive experience in financial services and team leadership.
Top Skills:
Automation Testing ToolsExcelSQL
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Manage projects in the transaction banking sector with an emphasis on compliance and retail payments, using Agile methodologies and strong stakeholder management.
Top Skills:
ConfluenceIso20022JIRA
.png){kind=logo}
Artificial Intelligence • Edtech • Mobile • Natural Language Processing • Productivity • Software
The IT Systems Engineer II will design, automate, and manage scalable IT infrastructure while collaborating across teams to ensure operational excellence in cloud and on-prem environments.
Top Skills:
AnsibleAWSBashCloudFormationGCPGithub ActionsGitlabGrafanaJenkinsPowershellPrometheusPythonTerraform
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
