What are the responsibilities and job description for the Senior ETL Developer – IBM DataStage- 10+ yrs- New York, United States- Onsite position at iMedhas Consulting Services?
Job Description
Seeking a skilled ETL Developer specializing in IBM DataStage to support, monitor, and maintain ETL processes used across Finance and Regulatory Reporting functions. The role involves maintenance, production support, job monitoring, troubleshooting, performance optimization, and working closely with upstream and downstream teams to ensure timely, accurate, and compliant data processing.
Key Responsibilities
-
Monitor DataStage Director Operations Console to ensure smooth execution of daily, monthly, and quarterly ETL workloads.
-
Manage job schedules using Huntington Bank's enterprise scheduling tool, Zena.
-
Ensure adherence to SLAs for all Finance and Regulatory Reporting job cycles.
-
Provide L2/L3 support for ETL job failures, including error analysis and timely restarts.
-
Perform root cause analysis for incidents such as source file corruption, network connectivity drops, database locks, or deadlocks.
-
Document incident recovery steps and preventive actions.
-
Ensure efficient use of partitioning techniques, Hash, Range, Entire, Auto Buffer tuning, and memory configurations.
-
Apply parallel processing best practices.
-
Work with DBAs to maintain the performance of source and target databases by ensuring indexes are updated, statistics are refreshed, and tablespace storage issues are resolved.
Required Skills and Experience
-
10 years of hands-on IBM DataStage development and support experience.
-
Strong SQL skills and experience with Snowflake and Oracle databases.
-
Experience supporting Finance or Regulatory Reporting ETL workloads.
-
Solid understanding of ETL performance tuning and parallelism concepts.
-
Experience in production support, job monitoring, and incident management.
-
Knowledge of job scheduling tools; Control-M preferred.
Preferred Qualifications
-
Prior experience working with a banking client.
-
Familiarity with regulatory reporting domains, such as FR Y-9C and FFIEC.
-
Exposure to cloud data platforms such as Azure or AWS.
-
Experience with Data Quality, Metadata, or Data Governance systems.
Soft Skills
-
Strong communication and stakeholder management abilities.
-
Analytical, detail-oriented, and proactive in problem-solving.
-
Ability to support high-pressure reporting cycles with tight deadlines.
Technical Skills
DataStage, SQL, Snowflake, Oracle, Python, ServiceNow awareness, and ITIL awareness.