1 month ago
Pune, IndiaStaff+
Responsibilities
- Lead the architecture, design, and implementation of high-volume batch and real-time ETL/ELT pipelines using Ab Initio and Python.
- Define dimensional data models, data warehousing standards, source-to-target mappings, data flows, and enterprise data governance practices.
- Develop and optimize Oracle database solutions, complex SQL, PL/SQL programs, ETL graphs, Python jobs, indexes, partitions, and bulk operations.
- Build and standardize CI/CD pipelines and database migration processes for Ab Initio code, Python scripts, and Oracle DDL/DML.
- Establish data validation, reconciliation, testing, monitoring, alerting, release management, and production resilience practices.
- Partner with business stakeholders, data product owners, quantitative analysts, reporting teams, infrastructure teams, Scrum Masters, and Project Managers.
- Mentor junior and mid-level ETL developers, data analysts, and database engineers while establishing engineering standards and reusable modules.
Requirements
- 10+ years of professional experience in data engineering, data warehousing, and ETL development.
- At least 3+ years of experience leading technical teams or complex data engineering initiatives.
- Expert hands-on proficiency with Ab Initio and advanced Python data engineering.
- Advanced Oracle 19c+ and PL/SQL experience, including complex SQL, execution plans, indexing, partitioning, and bulk operations.
- Experience with dimensional modeling, data warehousing and lakehouse concepts, data lineage, metadata governance, source-to-target mappings, and data profiling.
- Experience authoring CI/CD pipelines, database change management workflows, job schedules, version-control processes, automated data tests, and regression suites.
- Experience with banking, financial services, regulatory reporting, capital markets, retail banking, wealth management, or large enterprise data systems is highly preferred.
- Bachelor’s or master’s degree in Computer Science, Information Systems, Software Engineering, Data Analytics, or an equivalent quantitative discipline.
- Strong communication and stakeholder-influence skills, including the ability to explain complex data architectures and lead senior-level discussions.
Tech Stack
Categories
Data Engineering
About Citi
Citi is a public financial-services company offering consumer and institutional banking, credit cards, wealth management, treasury and trade solutions, and capital-markets services. It serves individuals, corporations, financial institutions, and governments in more than 160 countries and jurisdictions, earning interest and fee income from lending, payments, trading, and advisory. Founded in 1812 and headquartered in New York, it trades on the NYSE under the ticker C.