DB / Bigdata developer C10

The Applications Development 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: Design and develop reusable Frameworks for Data ingestion, extraction, report submission etc. Translate high-level & functional requirements, Data Modelling (dimensional, semi structured, transactional use cases) to technical design. Develop batch & real time data ingestion Pipelines involving wide range of technologies like Messaging middleware, Kafka, SFTP, Spark, Hive etc. Experience as a Big Data Engineer to develop, optimize, and manage large-scale data processing systems and analytics platforms. Hands-on Expertise in SQL, PL/SQL, Advanced SQL concepts. Hands-on experience in Performance tuning, understanding and interpreting AWR reports, Indexing. Good understanding on DB modelling, ER diagrams, Data warehousing concepts- SCD1 and SCD2 records. Good analytical abilities in understanding the data requirements and identifying data gaps. Should be good at shell scripting and job scheduling tool like Autosys. Should be able to work on tasks independently and co-ordinate with other teams to achieve tasks. Willingness to learn new technologies and scaleup based on the project requirements. Qualifications: 2+ years of software development experience building large scale distributed data processing systems or large-scale Web applications. Experience of at least 3 years in designing & developing Big Data solutions with at least one end to end implementation. Experience with Linux systems and hands on shell scripting. Excellent documentation and presentation skills. ------------------------------------------------------ Job Family Group: Technology ------------------------------------------------------ Job Family: Applications Development ------------------------------------------------------ Time Type: Full time ------------------------------------------------------ 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. Show more Show less