DataStage developer-Cincinnati OH (Hybrid)

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