Ab Initio ETL Developer

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

Job Purpose:

The primary purpose of this role is to work on the 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, 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:

The role forms part of Product Processor Development Team in Pune and supports the GTPL application which helps Product Control & Finance Department.

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 with oversight of UAT.
• 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 development 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.
• Explore existing application systems, determines areas of complexity, potential risks to successful implementation.
• 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:

• 4+ Year Software development experience.
• 3+ Year Oracle PL/SQL or SQL experience
• 3+ Year ETL Experience (AbInitio or Informatica). Hands on experience in developing complex ETL applications.
• Ab Initio experience is required
• Proficiency with Oracle PL/SQL or SQL, SQL tuning, writing packages, triggers, functions and procedures.
• UNIX knowledge
• 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:

Applications Development

------------------------------------------------------

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.