GFTS Data Services- Data Quality Analyst Pune - Officer/C11 (R2189577) Jobs in Pune at Citi

Last Updated: Aug 15, 2021 05:10 IST


Company Name
Job title
GFTS Data Services- Data Quality Analyst Pune - Officer/C11 (R2189577)
5-8 Years
Not Mentioned

Job Profile

Job Description :

This role is for Data Quality - ETL Tester:
  • Worked on Unix scripts to execute and maintain end to end execution of ETL testing process and also execute the Ab Initio jobs through Control center.
  • Setup automation ETL process (Ab Initio Graphs) included data loaded from source files to DMART with showing exception reports and number of default values.
  • Proficient in writing complex SQL queries for functional testing and finances and risk consumer report validation. Strong understanding of Banking Data Modeling is required.
  • Complete regression and integration testing as necessary. Design regression automation testing to validate results between UAT and Production.
  • Be an expert in executing test cases, managing and analyzing large sets of data, creating automation scripts and communicating relevant insights to the teams.
  • Understand Banking and Finance data model to conduct test cases based on changed request (CR), source request testing (SRT) and consumer subscriptions validation.
  • Execute and understand ETL data pipelines with data loading from staging to DMART database platform.
  • Strong knowledge on UNIX shell scripts to validate raw data from Product processor source files (.dat files) before loading to DMART tables.
  • Analyze business requirements and technical specifications for organizationally utilized applications. Build and maintain the corresponding test strategy, test plans, and test cases.
  • Analyze test results and logs defects in JIRA. Partner with project team members on the resolution and re-testing of identified defects and issues
  • Collaborate, coordinate, and communicate across work streams
  • Strong willingness & comfort taking on and challenging development approaches
  • Conduct and facilitate UAT and Regression Testing
  • Be proactive with leadership abilities with a strong "can do attitude"

  • Defines strategies to drive data quality measurement, produce data quality dashboards and reports, and implement data quality strategies to effectively govern data and improve data quality.
  • Works with data quality partners and Technology teams to identify and implement data quality tools. Identify critical data elements, data quality rules, thresholds, and other business requirements.
  • Designs/analyzes moderately complex reports to satisfy management requirements.
  • Ability to automate repetitive steps and bring overall efficiency in deliverable
  • Ability to effectively present information and respond to questions from groups of managers, clients and customers
  • Strong Data warehouse end to end and data completeness testing experience.
  • Hands-on experience with Data transformation/ manipulation testing
  • Working Knowledge of data quality/ completeness validation (SQL scripting)
  • Creation of Test Plan/ completion documents and project timelines.
  • Knowledge of project management and execution of multiple projects
  • Contributes to the development of new techniques and processes and for the aligned business.
  • Responsible for own work to support business teams in assigned area.
  • Regularly assumes informal/formal leadership role within teams, and is involved in coaching and training of new recruits in business processes and procedures of business
  • Utilizes communication and diplomacy skills are required.
  • Responsible for the reviewing, analyzing and dispositioning of the results of those measurements as well as providing detail and summary reporting of the same.
  • Analyze data quality issues
  • Interact with business and technical staff who support the Global Functions, ensuring the data quality scorecards are measuring fit for purpose data.
  • Performs other job duties and functions as assigned.

  • 5-8 years quality assurance experiences preferred
  • Ab Initio (Batch graphs, Continuous graphs, Plans) and Unix shell scrips experiences preferred
  • Experiences database platforms Netezza, Oracle and Teradata
  • Domain knowledge on Banking and Financial Services experiences preferred
  • Experience with defining and implementing data quality programs
  • Minimum of 3 years' experience Data Warehousing/Business Intelligence concepts from QA perspective, complex SQL Queries and ETL Banking Data Warehouse Testing.

Job Family Group: Technology
Job Family:Data Quality
Time Type:Full time
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi") invite all qualified interested applicants to apply for career opportunities. 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 .
View the "" poster. View the .
View the .
View the

Apply to More than 1000+ new jobs in your city


Key skills
Banking/ Accounting/ Financial Services
Job Description : This role is for Data Quality - ETL Tester: * Worked on Unix scripts to execute and maintain end to end execution of ETL testing process and also execute the Ab Initio jobs through Control center. * Setup automation ETL proce
Last Date

Alert : FreshersLIVE Employees will not call any candidates towards Job Offer or Job assistance. FreshersLIVE will never charge any candidates for Jobs. Please be aware of fraudulent calls or emails. Please write to [email protected] for any assistance.
Disclaimer: This Job is auto-published from MonsterIndia. For any issues with above Job Posting, please contact MonsterIndia

Apply Various Job Roles on

Job Role Apply Link
Other Roles Other Roles Jobs 2021 (57378 Vacancies)
Anganwadi Worker Anganwadi Worker Jobs 2021 (50491 Vacancies)
Software Software Jobs 2021 (26944 Vacancies)
Trainee Trainee Jobs 2021 (25644 Vacancies)
Programmer Programmer Jobs 2021 (22010 Vacancies)
Trained Graduate Teacher Trained Graduate Teacher Jobs 2021 (14909 Vacancies)
Designer Designer Jobs 2021 (10366 Vacancies)
Application Engineer Application Engineer Jobs 2021 (9858 Vacancies)
Sub Inspector Sub Inspector Jobs 2021 (9621 Vacancies)
Pre Primary Teacher Pre Primary Teacher Jobs 2021 (8393 Vacancies)
Customer Service Executive Customer Service Executive Jobs 2021 (7740 Vacancies)
Auxiliary Nurse Midwifery Auxiliary Nurse Midwifery Jobs 2021 (5000 Vacancies)
Development Officer Development Officer Jobs 2021 (4396 Vacancies)
Gramin Dak Sevak Gramin Dak Sevak Jobs 2021 (4368 Vacancies)
Assistant Assistant Jobs 2021 (3934 Vacancies)
Specialist Specialist Jobs 2021 (3762 Vacancies)
Apprentice Apprentice Jobs 2021 (3606 Vacancies)
Business Development Manager Business Development Manager Jobs 2021 (3060 Vacancies)
Health Officer Health Officer Jobs 2021 (2850 Vacancies)
General Medical Officer General Medical Officer Jobs 2021 (2632 Vacancies)
View More Jobs By Role (1 lakh + vacancies) has taken maximum steps to ensure that the job posting is genuine. This Job posting was made by the company/recruiter directly and exclusively on If the recruiter is charging any Fees from the job seekers, please write to us at [email protected] / [email protected].