Description

Job Title : Senior ETL Developer specializing in IBM DataStage

Job Location: Columbus, Indiana, United States(onsite)

Only Locas OR Nearby states, Banking Domain  exp

Study Level : Bachelor's Degree

Skill Required : Data-DataStage with Python/Scala/Java/.NET, ANSI SQL compliant, Traditional Or Cloud DB, Pipeline orchestration .

Primary Skill : Python, SQL.NET, Snowflake

Experience : 10 years

Job Duration : 36 Months

Job Description :

Seeking a skilled ETL Senior 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 and Operations Console to ensure smooth execution of daily, monthly, and quarterly ETL workloads.

Manage job schedules using Huntington Bank enterprise scheduling tools (Zena).

Ensure adherence to SLAs for all Finance and Regulatory Reporting job cycles.

Provide L2 and 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, and database locks or deadlocks.

Document incident recovery steps and preventive actions.

Debug and support issues caused by upstream system defects or downstream application failures, even if outside pure ETL scope.

Work cross-functionally to ensure data lineage, dependencies, and integrations remain stable.

Support ETL execution across Dev, QA, Stage, and Production environments.

Collaborate with Infrastructure teams to maintain IBM InfoSphere Information Server (IIS) platform health.

Manage environment-level configurations, parameter sets, and shared containers.

Promote DataStage code (DSX and ISX) across environments following Huntington change management process.

Validate ETL components during deployment and support post-migration testing.

Assist in patching, fix packs, and version upgrades of the IIS DataStage platform.

Support approval workflows for DataStage project access and environment-level privileges.

Coordinate with IAM teams for provisioning, deprovisioning, and periodic access reviews.

Perform periodic job health checks to identify high-latency or long-running ETL workloads.

Optimize DataStage jobs through efficient use of partitioning techniques, including Hash, Range, Entire, and Auto, along with buffer tuning, memory configurations, and parallel processing best practices.

Work with DBAs to maintain performance of source and target databases by ensuring indexes are updated, statistics are refreshed, and tablespace or storage issues are resolved.

Best Regards, 

Lakshmi

Technical Recruiter

Email: lakshmiv@imedhas.com

Google Chat: recruiterlakshmiit@gmail.com

Connect on Linkedin: Vajrala Lakshmi

iMedhas Consulting Services | Newark, Delaware 19702 

https://www.imedhas.com

Key Skills

Education

Not specified