- Company Name
- Epsilon Solutions Ltd.
- Job Title
- AbInitio-Snowflake-ControlM Developer
- Job Description
-
Job title: AbInitio‑Snowflake‑ControlM Developer
Role Summary:
Seasoned developer (6+ yrs) specializing in Ab Initio ETL, Snowflake data warehousing, and Control‑M scheduling. Designs, implements, and maintains end‑to‑end data ingestion pipelines from multiple source systems to target data stores, ensuring reliability, performance, and compliance in a finance domain.
Expectations:
- Deliver production‑ready ETL solutions on a contract basis.
- Lead or mentor small teams, assigning tasks and coordinating progress.
- Communicate effectively with clients, stakeholders, and Agile teams.
- Resolve production issues swiftly and document root causes.
- Maintain high data quality and adherence to governing standards.
Key Responsibilities:
- Build, test, and deploy Ab Initio jobs for daily ingestion from 2‑3 source systems to target warehouses (mainly Snowflake).
- Develop and maintain Control‑M schedules, including dependent job flows and error handling.
- Write efficient SQL scripts for data transformation, loading, and reporting.
- Optimize Unix/Linux shell scripts (sed, awk, more, etc.) for auxiliary tasks.
- Use JDBC/ODBC utilities for Oracle, DB2, and Teradata integrations.
- Integrate Jenkins pipelines for CI/CD of ETL artefacts.
- Manage Jira and ServiceNow tickets to track defects and enhancements.
- Participate in daily stand‑ups, sprint planning, and retrospectives in an Agile environment.
- Produce technical documentation, run‑books, and knowledge‑transfer materials.
Required Skills:
- Expert in Ab Initio ETL toolset (StreamWrite, StreamDesign, etc.).
- Strong SQL proficiency; ability to write complex queries and stored procedures.
- Working knowledge of Snowflake concepts (warehouses, schemas, SnowSQL).
- Experienced with Unix/Linux utilities and shell scripting.
- Proficient in DB Load/Unload utilities and database concepts.
- Hands‑on experience with Oracle, DB2, Teradata, and potentially Spark/Python.
- Skilled in scheduling tools: Control‑M (primary), Maestro, or Autosys.
- Familiar with CI/CD: Jenkins.
- Ticketing: Jira and ServiceNow.
- Knowledge of Data Warehouse architecture and ETL best practices.
- Agile project development experience.
- Strong analytical, problem‑solving, and communication skills.
- Leadership: ability to manage, coach, and collaborate with cross‑functional teams.
Required Education & Certifications:
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- Ab Initio certification (e.g., Advanced Ab Initio Developer) strongly preferred.
- Snowflake SnowPro Core certification a plus.
- Any relevant database or ETL certification (e.g., Oracle, Teradata, DB2) valued.
---