DataStage DeveloperLocation: Cincinnati OH (Hybrid)Duration: 06 Months plusRate: DOEUS Citizens and Green cards are Preferred.Job Description:10+ years of Information Technology experienceMinimum 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 applicationsStrong knowledge in combine/sort/aggregate/transform dataAt 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/snowflakeStrong SQL/plsql (8+ years) Skills with ability to perform ETLStrong knowledge and Understanding of dimensionally-designed databasesStrong understanding of relational database architecture techniques like EDWStrong Knowledge (8 + years) for scripting languages, like Python, Java, Powershell, UNIX scripting, SFTP and basic network principlesAt least 5+ years of banking knowledge is requiredDevelopment & Production Support experienceAbility to analyze complex data flows and understand existing jobsPrepare 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 specificationsStrong understanding of Software Development LifecyleStrong quality and testing practicesExperience in design-related extraction, loading data functions, testing designs, data modeling, and ensure the smooth running of applicationsAnalyzing 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 changes8+ years of experience creating documentation, training and conducting knowledgeDevelop, enhance, and maintain code following best practices and standardsStrong 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 issues8 + years of experience with devops pipelinesAccept 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 skillsGood 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 geographiesHigh level of dedication, initiative, vision, and enthusiasmCustomer focused and work well in a team environmentProactive and self-managed to achieve deliverablesMust possess good verbal and written communication skillsAbility to write consistent, clear and accurate documentationCompetencies leveraging data visualization tools for senior management and enterprise data visualizationAbility to translate business requirements into specifications that will be used to implement required reports and dashboards