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 Hyderabad, Telangana, IND Office
DLF Cyber City 6th Floor, Block 3 Gachibowli , Hyderabad, India, 500032
Photon Hyderabad, Telangana, IND Office
Hyderabad, India
Similar Jobs
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
The role involves supporting PMO functions through reporting, financial controls, capacity tracking, and governance in the Banking domain. Responsibilities include designing dashboards, managing financial performance, and coordinating planning activities.
Top Skills:
ClarityConfluenceGpdmJIRAPower BI
Artificial Intelligence • Productivity • Software • Automation
The Manager, Sales Assist will lead a team to drive sales and customer growth, coach representatives, and engage with clients using data-driven strategies.
Top Skills:
GongHubspot
Cloud • Information Technology • Productivity • Software • Automation
The role involves monitoring and resolving customer integration issues on the Boomi platform, troubleshooting errors, and maintaining customer relationships while providing technical support.
Top Skills:
As2BoomiEdiEdifactFlat FilesGraphQLGroovyJavaJavaScriptJSONMs SqlMySQLOftpPostgresPythonRestSftpSoapX12XML
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
