Datastage ETL Developer Lead job in Columbus, OH

Title: Lead ETL Datastage Developer
JobID #: 7277
Company: Established US Bank
Position Type: Direct Hire after 3 months contract

Pay Rate: Conversion salary of $130000/Year
Location: Columbus, OH
Hybrid role: Onsite 4 days/week and 1 day remote

Description:

Our client Bank is looking for an ETL Datastage Developer Lead in Enterprise Technology group. In this role you will be part of a team working to develop solutions enabling the business to leverage data as an asset at the bank. As an ETL Dev Lead, you will develop, maintain, and enhance code ensuring all IT SDLC processes are documented and practiced, working closely with multiple technologies teams across the enterprise. Provides technical and consultative support on the most complex technical matters.

Key technologies include Python, Datastage and SQL Development.
If you consider data as a strategic asset, evangelize the value of good data and insights, have a passion for learning and continuous improvement, this role is for you.
Preferred Qualifications:

1. Programming Languages: SQL, Python, PySpark
2. ETL Tools : IBM Datastage
3. Database : Snowflake, MySql, Oracle, SQL Server
4. Workflow Orchestration & Automation : Zena
5. Cloud Technologies : Google Cloud Platform
6. Data Governance : Infogix
7. Version Control & CI/CD : Git, Jenkins
8. Agile Scrum: Azure Dev Ops
9. Strong experience in software engineering comprising of designing, developing and operating robust and highly-scalable cloud infrastructure services.
10. Strong experience with Python/PySpark, DataStage ETL and SQL development.
11. Knowledge of Cybersecurity organization practices, operations, risk management processes, principles, architectural requirements, engineering and threats and vulnerabilities, including incident response methodologies.
12. Understand Authentication & Authorization Services, Identity & Access Management.
13. Experienced in using REST APIs.
14. Strong communication and interpersonal skills.
15. Strong organization skills and the ability to work independently as well as with a team.
16. Experience defining future state roadmaps for data warehouse applications.
17. Experience leading teams of developers within a project.
18. Experience in financial services (banking) industry.

Duties and Responsibilities:

1. Translate requirements and data mapping documents to a technical design.
2. Develop, enhance and maintain code following best practices and standards.
3. Create and execute unit test plans. Support regression and system testing efforts.
4. Debug and problem solve issues found during testing and/or production.
5. Communicate status, issues and blockers with project team.
6. Support continuous improvement by identifying and solving opportunities.
7. Analyzes, designs, and develops systems based upon user specifications.
8. Provides technical assistance in solving hardware or software problems.
9. Possesses an in-depth knowledge of and works with the technical tools available for systems development and support.
10. Maintains and demonstrates knowledge of technical industry trends, particularly as they apply to the Bank.
11. May assist with identifying training needs or with training of less experienced staff.
12. May serve as project leader for specific projects.
13. Performs other duties as assigned.