Python ETL Developer
Citi
About the role
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.
Responsibilities
- The candidate will be responsible for developing and maintaining systems within EMC ETL stream
- Work on Client Onboarding and managing reference data domain tables.
- Work directly with global application development teams, Operations teams/partners to successfully integrate application data.
- Perform unit testing with proper documentation to adhere to application standards.
- Work closely with other team members, onsite and remote to ensure consistent approach to development is used within the application.
- Involve in strategic Abinitio to Python Migration initiative to setup the ETL architecture.
- Provide on-going maintenance and L3 production support
Qualifications
- 5+ years of relevant experience
- Skills Required : Python/PySpark, SQL/Oracle, Unix, Autosys, Kubernetes
- Good to Have : Knowledge of ETL Data Processing tools
- Consistently demonstrates clear and concise written and verbal communication
Education
- Bachelor’s degree/University degree or equivalent experience
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
------------------------------------------------------
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.
Eligibility & process
Who can apply
Employment type: Full-time
Skills & stack
Selection process
Details are shared by the recruiter after shortlisting.
Prep kit
20 resourcesStudy material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Behavioural & HR questions 3
Highlight Citi's market reputation, recent tech innovations, and how your skills in Python directly solve their team's objectives.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Competitive Package
Chennai, India
Employment type: Full-time
