ETL Developer

We are looking for an experienced Ab Initio Developer to design, develop, and optimize ETL solutions for enterprise-scale data integration projects in the finance and capital markets domain . The role demands strong technical skills in Ab Initio and related technologies, along with the ability to work in an agile environment and collaborate with cross-functional teams.

Locations: PAN India

Key Responsibilities:

• Develop and maintain Ab Initio graphs using components like Rollup, Scan, Join, Partition (by key/by round robin), Gather, Merge, Interleave, Lookup
• Configure Ab Initio standard environment parameters , GD (PDL, MFS concepts), and EME basics
• Produce Low-Level Design (LLD) documents and collaborate with testers and PMO
• Work on multiple source systems and targets , handling daily and monthly batch schedules
• Develop and support complex frameworks for multiple data ingestion patterns (messaging files, hierarchical/polymorphic XML structures, canonical models)
• Implement Plans and Conduct>It for orchestration and scheduling
• Provide 3rd-level support and troubleshoot performance issues
• Collaborate on data modeling (CDM, LDM, PDM) using tools like Erwin, PowerDesigner, MagicDraw
• Ensure compliance with SDLC , QA processes, and agile methodologies

Required Skills:

• Ab Initio: Graph development, PDL, meta-programming, Plans, Conduct>It, Express>It (preferred)
• Database: SQL proficiency, DB load/unload utilities, experience with Oracle, DB2, Teradata
• UNIX: Shell scripting (must), utilities like sed, awk, perl, python
• Scheduling Tools: Control-M, Autosys, Maestro, TWS, ESP
• CI/CD: Knowledge of Jenkins and automation concepts
• Capital Markets Domain: Understanding of derivatives (IRS, CDS, Options), structured products, and fixed income
• Data Modeling: Experience creating CDMs, LDMs, PDMs
• Strong understanding of Ab Initio interaction with hardware ecosystem