DataStage developer-Cincinnati OH (Hybrid)

Cincinnati, OH

Today

Job Description

DataStage developer
Location: Cincinnati OH (Hybrid)
Duration: 06 Months plus
Rate: DOE

US Citizens and Green cards are Preferred.

Job Description:

10+ years of Information Technology experience
Minimum 8-10 years' experience in DataStage core development is required (requirement gathering/building/designing/testing/compiling/ tuning jobs/flows and implementing ETL workstreams)
8 – 10 years of experience in developing Datastage parallel/server/sequence jobs and converting server jobs to parallel jobs.
8+ years of experience in Middleware, Data Warehouse, Data Mart and Data Integration applications
Strong knowledge in combine/sort/aggregate/transform data
At least 8 years of experience in ETL development within a Data Warehouse.
Strong Experience (8+ years) interacting with a relational database including DB2/oracle/sql server/snowflake
Strong SQL/plsql (8+ years) Skills with ability to perform ETL
Strong knowledge and Understanding of dimensionally-designed databases
Strong understanding of relational database architecture techniques like EDW
Strong Knowledge (8 + years) for scripting languages, like Python, Java, Powershell, UNIX scripting, SFTP and basic network principles
At least 5+ years of banking knowledge is required
Development & Production Support experience
Ability to analyze complex data flows and understand existing jobs
Prepare root cause analysis documents, conduct code review, and test and tune the already developed jobs (running longer/consuming high resources such as cpu/memory etc)
Translate business requirements into functional / technical specifications
Strong understanding of Software Development Lifecyle
Strong quality and testing practices
Experience in design-related extraction, loading data functions, testing designs, data modeling, and ensure the smooth running of applications
Analyzing Audit /monitoring data, identifying gaps, issues patterns, and trends and identify jobs to performance tune and if required engage other squads/PO's, conduct meetings, influence backlogs, and get the jobs performance tuned.
Analyze application dependencies and conduct an impact assessment of changes
8+ years of experience creating documentation, training and conducting knowledge
Develop, enhance, and maintain code following best practices and standards
Strong knowledge of Star Schema design and coding (Dimension and Fact Table design)
8+ years of experience in testing, debugging skills and troubleshooting support and development issues
8 + years of experience with devops pipelines
Accept escalation from L3 team members in production support issues, address those issues and KT and upskill L3 resource to reduce further escalations.

Other skills required:--

Excellent communication skills/Analytical skills/problem solving skills
Good interpersonal and client-handling skills with the ability to manage expectations and explain technical detail.
Ability to multitask, prioritizes tasks, and quickly adjusts in a rapidly changing environment.
Working with cross-functional teams located across geographies
High level of dedication, initiative, vision, and enthusiasm
Customer focused and work well in a team environment
Proactive and self-managed to achieve deliverables
Must possess good verbal and written communication skills
Ability to write consistent, clear and accurate documentation
Competencies leveraging data visualization tools for senior management and enterprise data visualization
Ability to translate business requirements into specifications that will be used to implement required reports and dashboards

Numbers & Facts

Location

Cincinnati, OH

Skills

Analysis Skillsunmatched
Application Integrationunmatched
Banking Servicesunmatched
Best Practicesunmatched
Business Skillsunmatched
CPU (Central Processing Unit)unmatched
Code Reviewsunmatched
Communication Skillsunmatched
Cross-Functionalunmatched
Customer Relationsunmatched
Data Analysisunmatched
Data Collectionunmatched
Data Martunmatched
Data Modelingunmatched
Data Visualizationunmatched
Data Visualization Toolsunmatched
Data Warehousingunmatched
Database Architectureunmatched
Database Designunmatched
Database Extract Transform and Load (ETL)unmatched
Debugging Skillsunmatched
Delivery Managementunmatched
DevOpsunmatched
Documentationunmatched
Establish Prioritiesunmatched
IBM DB2unmatched
IBM WebSphere DataStageunmatched
Identify Issuesunmatched
Information Technology & Information Systemsunmatched
Interpersonal Skillsunmatched
Javaunmatched
Memory Hardwareunmatched
Microsoft SQL Serverunmatched
Middlewareunmatched
Multitaskingunmatched
Oracle Databaseunmatched
Oracle PL-SQLunmatched
Performance Tuning/Optimizationunmatched
Presentation/Verbal Skillsunmatched
Problem Solving Skillsunmatched
Production Supportunmatched
Python Programming/Scripting Languageunmatched
Quality Assurance Methodologyunmatched
Relational Databases (RDBMS)unmatched
Reporting Dashboardsunmatched
Requirements Managementunmatched
Root Cause Analysisunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Secure/SSH File Transfer Protocol (SFTP)unmatched
Snowflake Schemaunmatched
Software Developmentunmatched
Star Schemaunmatched
Team Playerunmatched
Test Designunmatched
Testingunmatched
Trend Analysisunmatched
United States Department of Energy (DOE)unmatched
Unix Shell Programmingunmatched
Windows PowerShellunmatched
Writing Skillsunmatched

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder

DataStage developer-Cincinnati OH (Hybrid)

Job Description

Numbers & Facts

Skills

Be found by employers

Level up your application

Professional resume templates

Free resume builder