DataStage developer-Cincinnati OH (Hybrid)
Georgia Tek Systems
Cincinnati, OH, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Working hours
Regular working hours
Job source
Tech stack
Java (Programming Language)
Unix
Code Review
Information Systems
Databases
Data Integration
Extract Transform Load (ETL)
Data Mart
Data Visualization
Data Warehousing
IBM DB2
Relational Databases
+19 more
IBM InfoSphere DataStage
Software Debugging
Middleware
Python (Programming Language)
Microsoft SQL Server
Networking Basics
Oracle (Applications)
Windows PowerShell
Requirements Management
Software Engineering
PL-SQL
Data Streaming
Scripting
File Transfer Protocol (FTP)
Delivery Pipeline
Snowflake
Core Api
Information Technology
Star Schema
Requirements
IBM WebSphere DataStage, IBM WebSphere DataStage, United States Department of Energy (DOE), Information Technology & Information Systems, Database Extract Transform and Load (ETL), Requirements Management, Test Design, Middleware, Data Mart, Data Warehousing, * 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
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.careerbuilder.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦