Citigroup Senior ETL Developer in Pune, India
The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.
Utilize knowledge of applications development procedures and concepts, and basic knowledge of other technical areas to identify and define necessary system enhancements, including using script tools and analyzing/interpreting code
The candidate will be responsible for developing and maintaining systems within SMC ETL stream.
Work directly with global application development teams, Operations teams/partners to successfully integrate.
The developer will be responsible for product design and delivery as well as unit testing, integration testing and regression testing activity and ensuring the software produced does not negatively impact overall stability.
Work closely with other team members, onsite and remote to ensure consistent approach to development is used within the application.
Provide on-going maintenance and L3 production support
Keep up to date with new technologies and their possible adoption within ISG .
ETL developer will be responsible for specification review, technical deliverables, enforce best Citi technical practices, conduct code reviews, build support processes, and serve as escalation point during production outages.
Candidate will also be required to develop SQL stored procedures, triggers and non-trivial SQL for data retrieval and manipulation..
- Knowledge/Experience: • Strong command of Abinitio and working with relational databases• Proven proficiency in dealing with complex technical issues across all aspects of the project lifecycle• Experience of working in a demanding and results driven, time critical environment• All potential candidates must be able to work in a dynamic team environment which includes developers working with different technologies (such as Java, Web Services and C#/.NET) and across multiple regions Required Skills: • Ab Initio GDE and Co>Op (Continuous, Batch, Plans)• UNIX/Linux Shell scripting• Oracle concepts, SQL, PL/SQL• SQL performance tuning• Autosys Skills that are a plus: • Data modeling• Talend• Knowledge of advance AbInitio components• XML/XSD/XSLT• Web Services• Java SE• Prior industry experience with Reference Data
- Bachelor’s degree MCA /B.Tech / M.E. / M.Tech (in computers, information technology or engineering)
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
Grade :All Job Level - All Job FunctionsAll Job Level - All Job Functions - IN
Time Type :
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
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 CLICK HERE at https://www.citigroup.com/citi/accessibility.html .
To view the "EEO is the Law" poster CLICK HERE at https://www.dol.gov/ofccp/regs/compliance/posters/pdf/eeopost.pdf . To view the EEO is the Law Supplement CLICK HERE at https://www.dol.gov/ofccp/regs/compliance/posters/pdf/OFCCPEEOSupplementFinalJRFQA508c.pdf .
To view the EEO Policy Statement CLICK HERE at http://citi.com/citi/diversity/assets/pdf/eeoaapolicy.pdf .
To view the Pay Transparency Posting CLICK HERE at https://www.dol.gov/ofccp/pdf/pay-transp_unformattedESQA508c.pdf .
Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.