(J-539) | ETL Developer

(J-539) | ETL Developer

18 Mar
Citibank India
Chennai district

18 Mar

Citibank India

Chennai district

Job Description

The purpose of the job is to design and develop ETL solutions for Global Liquidity Reporting System (GLRS). The candidate will be responsible for understanding the requirements, designing, coding and testing along with the development team. This will involve working closely with the business and SMEs to prioritize business requests, manage the Batch Processing development work slate, 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 Global Liquidity Reporting System (GLRS)

application standardized and consolidated liquidity reporting solution to global treasury users. GLRS application consumes data from GENESIS and ADS/SDRs to produce various liquidity reports for FRB and PRA agencies. GLRS Reports used by Treasury users to analyze firm liquidity status to take internal funding decisions as well as report to external agencies.

Key Responsibilities:

The key responsibilities for the candidate are -

Develop and design highly efficient ETL solutions based on the business requirements and aggressive delivery timelines. Understanding Business and Functional Requirements provided by Business Analysts and to convert into Technical Design Documents to deliver on the requirements. Ensure best practices are followed. Prepare detailed level test plans and ensure proper testing for each module developed. Prepare handover documents; manage SIT with oversight of UAT and Production Implementation. Identify and proactively resolve issues that could affect 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. Ensure process compliance and manage expectations of the leadership Work proactively & independently to address development requirements and articulate issues/challenges with enough lead time to address risks Design, Implement, Integrate and test new features. Explore existing application systems, determines areas of complexity, potential risks to successful implementation. Ability to build relationship with business and technology stakeholders. Successfully migrate ETL logic into Spark/Hadoop platform

Person Specification


3 to 8 years of experience in Software development

Expertise in building ETL applications using Ab Initio, ACE or Talend.

Good knowledge of RDBMS Oracle, with ability to write complex SQL needed to investigate and analyse data issues

2 years of experience in big data ecosystem Hadoop, Spark & Hive will be strong plus.

Good in UNIX shell scripting.

Hands on experience in Autosys/Control Centre scheduling tools.

Proven 3 years of experience in working with complex data warehouses.

Strong influencing & interpersonal skills

Willing to work flexible hours


Strong design and execution bend of mind

Candidate should possess a strong work ethic, good interpersonal, communication skills, and a high energy level.

Candidate should share many common traits: Analytical thinker, quick learner who is capable of organizing and structuring information effectively;

Ability to prioritize and manage schedules under tight, fixed deadlines.

Excellent written and verbal communication skills.

Ability to build relationships at all levels.

Ability to independently work with vendors in resolving issues and developing solutions

Strong interpersonal skills


Bachelor of Science or Master degree in Computer Science or Engineering or related discipline.


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.

Shows drive, integrity, sound judgment, adaptability, creativity, self-awareness and an ability to multitask and prioritize.

Good change management discipline

The original job offer can be found in Kit Job:

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:
Enter Your E-mail address to receive the latest job offers for: (j-539) | etl developer
Publish a new Free Offer
Need to publish an offer? With more than 1 million unique users per month, you will find the ideal candidate for your company instantly, what are you waiting for!
Publish Now

Subscribe to this job alert