20 Sep
|
Citigroup
|
Chennai
Citi is looking for a ETL Developer to design and deliver enterprise-scale data integration solutions that keep critical reporting and analytics capabilities running reliably across a global financial institution. In this role, you will take ownership of end-to-end ETL development using Ab Initio, set the standard for data quality and governance practices, and work directly with stakeholders across the business to translate complex requirements into production-grade pipelines. This is a high-impact position for a technical specialist who wants to solve meaningful data challenges at scale within a team-oriented, performance-driven environment. **Responsibilities** + Design, develop, and tune highly scalable ETL processes using Ab Initio - including GDE, EME, Co>Operating System, Conduct>IT, and Continuous Flows - to ensure reliable and efficient data integration across the organization. + Build and deploy robust data integration solutions that streamline data flows between source systems and downstream reporting and analytics platforms. + Write and tune advanced SQL and PL/SQL queries against Oracle and relational databases to support accurate and performant data processing. + Drive data governance and data quality best practices across the integration landscape, ensuring accuracy, consistency, and reliability of data assets. + Oversee code migration, version control, and environment infrastructure setups including private and public sandboxes and EME permissions management. + Translate functional requirements from business stakeholders, data architects, and project managers into clear and implementable technical specifications. + Investigate, analyse, and resolve L2 production issues, maintaining the stability and continuity of live data pipelines.
+ Manage the full data application development lifecycle - from technical planning and feasibility assessment through to testing, implementation, and ongoing production support. **Required qualifications & skills** + * **Core Ab Initio Expertise:** 6+ years of hands-on experience with Ab Initio GDE, Co>Operating System, Express>It, Conduct>It, and EME.* **Database & SQL** : Strong proficiency in writing and optimizing complex SQL queries in Oracle DB.* **OS & Scripting:** Strong working knowledge of UNIX/Linux operating systems and shell scripting (Bash, Korn shell).* **Data Warehousing Concepts:** Deep understanding of dimensional modeling, star/snowflake schemas, and enterprise data warehouse architectures.* **Problem Solving** : Demonstrated ability to troubleshoot job failures, resolve performance bottlenecks, and manage root-cause analysis in high-volume production environments. + **Familiarity** with CI/CD tools, version control (Git), and agile software development methodologies. **Beneficial skills & qualifications** + Expertise in Large Language Models (LLMs) including OpenAI, Gemini, Claude, Llama, and local/open source models + Hands-on experience in Python for data ingestion, transformation. + Experience working with cloud-native data platforms or migrating ETL workloads from on-premise environments to contemporary data infrastructure. + Knowledge of data governance frameworks,
metadata management practices, or data quality tooling within large-scale enterprise environments. + Familiarity with project management or consulting approaches applied in a technology delivery context. ------------------------------------------------------ **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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi's_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
📌 ETL Abinitio Developer (Chennai)
🏢 Citigroup
📍 Chennai