Senior Database ETL Tester is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the function and overall business. Evaluates moderately complex and variable issues with substantial potential impact, where development of an approach/taking of an action involves weighing various alternatives and balancing potentially conflicting situations using multiple sources of information. Requires good analytical skills in order to filter, prioritize and validate potentially complex and dynamic material from multiple sources. Strong communication and diplomacy skills are required. Regularly assumes informal/formal leadership role within teams. Involved in coaching and training of new recruits Significant impact in terms of project size, geography, etc. by influencing decisions through advice, counsel and/or facilitating services to others in area of specialization. Work and performance of all teams in the area are directly affected by the performance of the individual.
Responsibilities:
- Supports initiatives related to System Integration Testing (SIT) process and product rollout into production. Testing specialists who work with technology project managers, UAT professionals and users to design and implement appropriate scripts/plans for an application testing strategy/approach.
- Tests and analyzes a broad range of systems and applications to ensure they meet or exceed specified standards and end-user requirements.
- Work closely with key stakeholders to understand business and functional requirements to develop test plans, test cases and scripts.
- Works complex testing assignments.
- Executes test scripts according to application requirements documentation.
- Identifies defects and recommends appropriate course of action; performs root cause analyses.
- Coordinates multiple testers and testing activities within a project.
- Retests after corrections are made to ensure problems are resolved.
- Documents, evaluates and researches test results for future replication.
- Identifies, recommends and implements process improvements to enhance testing strategies.
- Analyzes requirements and design aspects of projects. Interfaces with client leads and development teams.
- Exhibits sound understanding of concepts and principles in own technical area and a basic knowledge of these elements in other areas.
- Requires in-depth understanding of how own area integrates within IT testing and has basic commercial awareness.
- Makes evaluative judgments based on analysis of factual information in complicated and novel situations.
- Participate in test strategy meetings,
- Has direct impact on the team and closely related teams by ensuring the quality of the tasks services information provided by self and others.
- Requires sound and comprehensive communication and diplomacy skills to exchange complex information.
- Provide metrics related to the cost, effort, and milestones of Quality activities on a project level
- Acts as advisor and mentor for junior members of the team.
- Regularly assumes informal/formal leadership role within teams.
- Perform other duties and functions as assigned
- Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.
Qualifications:
- 8-12 years of experience in Database testing /ETL testing, SQL, Unix, Job scheduling tool, writing comprehensive test cases, test planning & execution and defect triage
- Experience in writing complex SQLs
- Experience in Unix commands
- Experience in testing Bigdata applications will be an added advantage
- Experience in testing process - writing comprehensive test cases, test execution and defect triage
- Experience in using job scheduling tools like Control Centre/Autosys etc.,
- Experience in agile process
- Experience in automation in data testing will be a big plus
- Experience in preparing and presenting comprehensive status update to management
- Demonstrated analytical skills & ability to work independently on assigned tasks
- Good written and verbal communication
- Requires methodical approach to testing and problem solving. Requires theoretical and analytical skills, with demonstrated ability in planning and operations
Education:
- Bachelor’s/University degree or equivalent experience
------------------------------------------------------
Job Family Group:
Technology
------------------------------------------------------
Job Family:
Technology Quality
------------------------------------------------------
Time Type:
Full time
------------------------------------------------------
Most Relevant Skills
Please see the requirements listed above.
------------------------------------------------------
Other Relevant Skills
For complementary skills, please see above and/or contact the recruiter.
------------------------------------------------------
Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.
If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View Citi’s EEO Policy Statement and the Know Your Rights poster.
