DataStage developer-Cincinnati OH (Hybrid)

Georgia Tek Systems

  • Cincinnati, OH
  • 28 days ago

    Highlights

    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. Minimum 8-10 years' experience in DataStage core development is required (requirement gathering/building/designing/testing/compiling/ tuning jobs/flows and implementing ETL workstreams).

    Numbers & Facts

    LocationCincinnati, OH

    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

    Similar Jobs