Find JobsSalary EstimateCareer AdviceUpload ResumeEmployers / Post JobProfileMessage Center

DataStage developer-Cincinnati OH (Hybrid)

Georgia Tek Systems

Cincinnati, OH

Apply
JOB DETAILS
SKILLS
Analysis Skills, Application Integration, Banking Services, Best Practices, Business Skills, CPU (Central Processing Unit), Code Reviews, Communication Skills, Cross-Functional, Customer Relations, Data Analysis, Data Collection, Data Mart, Data Modeling, Data Visualization, Data Visualization Tools, Data Warehousing, Database Architecture, Database Design, Database Extract Transform and Load (ETL), Debugging Skills, Delivery Management, DevOps, Documentation, Establish Priorities, IBM DB2, IBM WebSphere DataStage, Identify Issues, Information Technology & Information Systems, Interpersonal Skills, Java, Memory Hardware, Microsoft SQL Server, Middleware, Multitasking, Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Production Support, Python Programming/Scripting Language, Quality Assurance Methodology, Relational Databases (RDBMS), Reporting Dashboards, Requirements Management, Root Cause Analysis, SQL (Structured Query Language), Scripting (Scripting Languages), Secure/SSH File Transfer Protocol (SFTP), Snowflake Schema, Software Development, Star Schema, Team Player, Test Design, Testing, Trend Analysis, United States Department of Energy (DOE), Unix Shell Programming, Windows PowerShell, Writing Skills
LOCATION
Cincinnati, OH
POSTED
30+ days ago
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

About the Company

G

Georgia Tek Systems