ETL Database Tester

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

The Testing Intermediate Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the objectives of the subfunction/ job family. Applies analytical thinking and knowledge of data analysis tools and methodologies. Requires attention to detail when making judgments and recommendations based on the analysis of factual information. Typically deals with variable issues with potentially broader business impact. Applies professional judgment when interpreting data and results. Breaks down information in a systematic and communicable manner. Developed communication and diplomacy skills are required in order to exchange potentially complex/sensitive information. Moderate but direct impact through close contact with the businesses' core activities. Quality and timeliness of service provided will affect the effectiveness of own team and other closely related teams.

Responsibilities:

• Conducts 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. Responsibilities may also include software quality assurance testing.
• Conducts a variety of tests and analyses to ensure that systems and or applications meet or exceed specified standards and end-user requirements.
• Works 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.
• Interfaces with development teams if clarification is needed on requirements or to convey test results.
• Exhibits good understanding of concepts and principles in own technical area and a basic knowledge of these elements in other areas.
• Requires basic understanding of how own area integrates within IT testing to achieve objectives.
• Makes evaluative judgments based on analysis of factual information.
• 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.
• Resolves problems by identifying and selecting solutions through the application of acquired technical experience and guided by precedents
• Requires sound and comprehensive communication and diplomacy skills to exchange complex information.
• Provides informal guidance to new team members.
• Performs 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:

• 4-9 years of experience in Data/ETL testing
• Experience in writting 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
• Demonstrated analytical skills & ability to work independently on assigned tasks
• Good written and verbal communication

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.