Officer-etl Tester

**Job Purpose**:
The primary purpose of this role is to work on the QA and development work for the Product Processor Technology area. This will involve working closely with the business and SMEs to prioritize business requests, manage the ETL development workslate, QA Automation efforts, provide estimate efforts, and ensure timely delivery on committed items and to project manage all aspects of software development according to the Software Development Lifecycle (SDLC).

**Job Background/context**:
GTPL is the global finance product control’s strategic product processor for all cash products and internally traded futures. GTPL will be the one stop shop to enable consistent and granular accounting globally, accepting latest global reference and market data to reduce manual adjustments and cleaner reconciliations. GTPL will continue enabling several global functions like Compliance, Risk including BASEL, Tax and Regulatory Reporting and firm-wide strategic initiatives by being the gateway to 100+ systems

**Key Responsibilities**:

- Understanding Business Requirements and Functional Requirements provided by Business Analysts and to convert into Technical Design Documents and leading the development team to deliver on those requirements.
- Leading a Technical Team in Pune supporting GTPL in Product Processor Departments.
- Ensure projects Plans are created and PTS documentation is up to date.
- Work closely with Cross Functional Teams e.g. Business Analysis, Product Assurance, Platforms and Infrastructure, Business Office, Controls and Production Support. Prepare handover documents, manage SIT, UAT, automation of Unit Tsting.
- Identify and proactively resolve issues that could impact system performance, reliability, and usability.
- Demonstrates an in-depth understanding of how the development function integrates within overall business/technology to achieve objectives; requires a good understanding of the industry.
- Work proactively & independently to address testing requirements and articulate issues/challenges with enough lead time to address risks
- Ability to understand complex data problems, analyze and provide generic solutions compatible with existing Infrastructure.
- Design, Implement, Integrate and test new features.
- Owns success - Takes responsibility for successful delivery of the solutions. Mentoring other developers on their implementation as needed, and organize review activities like design review, code review and technical document review etc. to ensure successful delivery.
- Contribute to continual improvement by suggesting improvements to software architecture, software development process and new technologies etc.
- Ability to build relationship with business and technology stakeholders.

**Knowledge/Experience**:

- 5+ Year Software development and QA t experience.
- 3+ Year Oracle PL/SQL experience
- Development experience in a fast-paced, time-to-market driven environment Experience with test automation, test scenario and test scripts creation and modification Comfortable with writing complex queries Experience with reporting tools. Hands on experience with testing automation tools.
- Proficiency with Oracle PL/SQL, SQL tuning, writing packages, triggers, functions and procedures.
- Experience with data conversion / migration
- Excellent trouble shooting and debugging skills.
- Worked in Onsite - offshore model.

**Skills**:

- Strong analytic skills.
- Excellent communication and internal customer management skills.
- Excellent written and verbal communication skills.
- Excellent facilitation skills.
- Ability to build relationships at all levels.

**Qualifications**:

- B.E/B.Tech or Master degree in Computer Science or Engineering or related discipline.

**Competencies**:

- Strong work organization and prioritization capabilities.
- Takes ownership and accountability for assigned work.
- Ability to manage multiple activities.
- Focused and determined in getting the job done right.
- Ability to identify and manage key risks and issues.
- Personal maturity and sense of responsibility.
- Shows drive, integrity, sound judgment, adaptability, creativity, self-awareness and an ability to multitask and prioritize.
- Sensitive to cultural and background differences and environments Confident and assertive.
- Values diversity: Demonstrates an appreciation of a diverse workforce.
- Appreciates differences in style or perspective.**Job Family Group**:
Technology
- **Job Family**:
Technology Quality
- **Time Type**:
Full time-
- View Citi’s _EEO Policy Statement_ and the _Know Your Rights_ poster._