Robotics Prcocess Automation, LLC
ETL - Datastage Lead Developer
Robotics Prcocess Automation, LLC, Columbus, Ohio, United States, 43224
Position Summary
We are seeking a highly skilled DataStage Lead with Python to join our IT Corporate Finance Regulatory Reporting team. This role will initially focus on IBM DataStage for ETL processes but will transition to Python development over the next 1-2 years. The ideal candidate will have strong experience in both technologies and a passion for building efficient, compliant data solutions.
Key Responsibilities
Lead the design, development, and maintenance of ETL processes using IBM DataStage and Python.
Collaborate with data architects, business analysts, and compliance teams to create and maintain technical design documents.
Develop and optimize SQL queries and scripts for Snowflake and other relational databases.
Write and maintain Unix shell scripts to support automation and data processing tasks.
Manage and resolve incidents promptly to minimize business impact.
Participate in change management processes, including planning, documentation, and execution.
Provide technical insights during project and team meetings.
Ensure compliance with internal standards, security policies, and regulatory requirements.
Mentor junior team members and provide technical leadership.
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field.
5+ years of experience in ETL development with IBM DataStage and Python.
Strong experience with Snowflake or other cloud-based data platforms.
Proficiency in Unix/Linux shell scripting.
Solid understanding of relational databases and SQL.
Experience with incident and change management processes (ITIL framework preferred).
Excellent problem-solving, analytical, and communication skills.
Ability to work onsite 4 days a week in Columbus, OH.
Preferred Qualifications
Experience in banking or financial services industry.
Familiarity with Agile methodologies and DevOps practices.
Knowledge of data governance and data quality best practices.
Equal Opportunity ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.
#J-18808-Ljbffr
Key Responsibilities
Lead the design, development, and maintenance of ETL processes using IBM DataStage and Python.
Collaborate with data architects, business analysts, and compliance teams to create and maintain technical design documents.
Develop and optimize SQL queries and scripts for Snowflake and other relational databases.
Write and maintain Unix shell scripts to support automation and data processing tasks.
Manage and resolve incidents promptly to minimize business impact.
Participate in change management processes, including planning, documentation, and execution.
Provide technical insights during project and team meetings.
Ensure compliance with internal standards, security policies, and regulatory requirements.
Mentor junior team members and provide technical leadership.
Required Qualifications
Bachelor's degree in Computer Science, Information Systems, or related field.
5+ years of experience in ETL development with IBM DataStage and Python.
Strong experience with Snowflake or other cloud-based data platforms.
Proficiency in Unix/Linux shell scripting.
Solid understanding of relational databases and SQL.
Experience with incident and change management processes (ITIL framework preferred).
Excellent problem-solving, analytical, and communication skills.
Ability to work onsite 4 days a week in Columbus, OH.
Preferred Qualifications
Experience in banking or financial services industry.
Familiarity with Agile methodologies and DevOps practices.
Knowledge of data governance and data quality best practices.
Equal Opportunity ROBOTIC PROCESS AUTOMATION LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ROBOTIC PROCESS AUTOMATION LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ROBOTIC PROCESS AUTOMATION LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract.
#J-18808-Ljbffr