Citi Looking for AVP, Data Quality Engineer in Test (SDET) – Irving/Tampa – C12-Hybrid at Cedar Hill, Texas Full Time

The Finance, Treasury, Liquidity, Capital, and Risk functions at Citi are consumers of a vast amount of data that spans across the entirety of the firm, cutting across all lines of business, asset classes, and geographies.  To meet the needs of these functions, a large, centralized data platform has been developed to enable the acquisition of data from all appropriate sources across the firm, the normalization of data to make it consistent and consumable, the management of data to ensure its complete and accurate, and the distribution of data to the consuming functions that require it.  The scale of data that flows through this platform is significant, with thousands of inbound feeds being managed daily, dozens of consuming applications, and a 100+ terabyte data store in the middle.  While there have been efforts made to automate integration and regression testing, we need to substantially increase our investment in both automated testing tools and driving a test-first mindset in our requirement management and engineering practices.

The Software Development Engineer in Test (SDET) accomplishes results through integrating subject matter and industry expertise within a defined area. Contributes to standards around which others will operate. Requires in-depth understanding of how areas collectively integrate within the sub-function as well as coordinate and contribute to the objectives of the entire function. Requires basic commercial awareness. Developed communication and diplomacy skills are required in order to guide, influence and convince others, in particular colleagues in other areas and occasional external customers. Has responsibility for volume, quality, timeliness and delivery of end results of an area. Involved in short-term planning resource planning. Participate in initiatives related to Functional Testing, User Acceptance Testing (UAT) 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.

We value our talented employees, and whenever possible strive to help one of our associates grow professionally before recruiting new talent to our open positions. If you think the open position, you see is right for you, we encourage you to apply!

Our people make all the difference in our success.

Responsibilities:

• 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.
• 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.

Qualifications:

• Experience in Software testing lifecycle and methodologies System, Integration testing, Regression testing, Exploratory testing, Ad-hoc testing etc. and their corresponding tools.
• 4+ years’ experience in programming and scripting skills for automated test case development
• 4+ years with OOO design with automated test case development
• 4+ years proven experience creating automation test script and tools to support test automation
• 3+ years relevant experience in the Financial Service industry
• 3+ years’ experience in Java or other programming language with Unit Test Framework
• 3+ years’ experience in Java or other programming language object-oriented design and design pattern
• 3+ years’ experience in Java or other programming language DSL /Fluent Interface Implementation
• 3+ years’ experience in data quality functional testing automation
• 3+ years’ experience in ETL/ Data Quality Testing
• 3+ years’ experience Data Warehousing/Business Intelligence concepts from QA perspective, complex SQL Queries and ETL Banking Data Warehouse Testing.
• Must have experience with Implementing Data Quality Testing Strategy and responsible for executing automated testing strategy in area managed.
• Translate business process diagrams to system requirements in the development of automation testing solutions
• Experience with extending test coverage and automation scripts
• Mentor and provide training global team to become automation tester
• Implement Data Quality Testing Strategy and Responsibility for executing automated testing strategy in area managed
• Experience with exploratory data analysis on Big Data Platform, preferably on Cloudera
• Experience with Data warehouse testing and ETL experience
• Proficient in writing complex SQL queries for functional testing and finances and risk consumer report validation with Database platform like Oracle, Teradata etc. Strong understanding of Banking Data Modeling is required.
• Domain knowledge on Banking and Financial Services experiences preferred
• In-depth understanding of Systems Development Life Cycle processes
• Good Data Analytical skills and Data Quality Check
• Thorough understanding of end-to-end testing processes, Test Management and other testing related tools
• Be proactive with leadership abilities with a strong “can do attitude”

Education:

Bachelor’s/University degree or equivalent experience

Additional Job Experience:

A C12 role is needed for Retail Genesis Automated Functional Test Engineering Team to transform and support the Genesis Independent Verification & Validation (IVV) front to back QA Team. This is a transformational role to transform the long running manual QA testing process to Automated SDET oriented technical functional testing team to Faster Feedback Cycle, Reusability of Test Suite, Faster Time to Market, Higher Test Coverage, Improved Accuracy, Eliminate Human Error and Reduced Business Expenses.

 
The ideal candidate will be a mid-level technology professional and an individual contributor who will drive priorities while balancing risks and change complexities throughout the organization for data quality engineering. The candidate must be able to solve complex problems and work through roadblocks. The candidate must be able to mentor team members around various new technologies, practices and processes in the data quality landscape.

Technical and functional expertise in a Financial Services environment with a willingness to ‘roll-up sleeves’ are a must. Being able to partner with the business and create effective solutions for strategic Bank initiatives with innovation and Forward Compatibility are essential and aggregate and Reconcile data across multiple ETL pipelines in order to determine monetary data accuracy using various data analysis tools.

————————————————-

Job Family Group:

Technology

————————————————-

Job Family:

Technology Quality

——————————————————

Time Type:

Full time

——————————————————

Primary Location:

Irving Texas United States

——————————————————

Primary Location Salary Range:

$93,200.00 – $(phone number removed)

——————————————————

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 Accessibility at Citi.

View the “EEO is the Law” poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting

—————————–

Effective November 1, 2021, Citi requires that all successful applicants for positions located in the United States or Puerto Rico be fully vaccinated against COVID-19 as a condition of employment and provide proof of such vaccination prior to commencement of employment.