DataStage developer-Cincinnati OH (Hybrid)

Georgia Tek Systems
Cincinnati, OH, United States
2 days ago
Apply on www.careerbuilder.com
Prepare application

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

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

Good distractions

Loading talks and stories from around this role…