Title: ETL Developer
Location: Remote (Cincinnati, OH)
Duration: Long Term
Only USC or GC
Job Description:-
Must Have
- Ascential DataStage
- DataStage, SQL, understanding of dimensionally-designed databases, and experience interacting with a relational database (DB2, Oracle, etc.). Mainframe experience would be a bonus, but not required. Ability to analyze complex data flows and understand existing jobs.
- DB2
- Basic IBM Mainframe COBOL and JCL Skills
- Design, Code, Test, and Document mappings/transformations of load routines to the Data Warehouse or Data Marts.
- Translation of Functional Specifications into Technical Design Specifications for off-shore development team.
- May serve as an individual contributor on smaller initiatives, or as a member of a development team on larger initiatives.
- Function as Technical Lead to junior resources or our off-shore development team.
- May be asked to tune SQL statements to ensure optimal performance.
- Provide input on physical database design decisions.
- Trouble shoot and problem solve data integrity issues.
- Maintain documentation in corporate data dictionary.
- May provide 24 x 7 production support.
- 7+ years of related experience.
- Proficient in SQL.
- General understanding of Data Modeling principles.
- General knowledge of Extract, Transform, and Load (ETL) concepts, and working knowledge of 3rd party ETL tool.
- Knowledge of DataStage and/or Job Control Language (JCL) a plus.
- Scripting skills (SQL, AQT, Shell) a plus.
o Bachelor's degree in Computer Science/Information Systems or comparable with 7+ years of experience
o Strong Knowledge of Amazon Web Services
o Strong Knowledge of Terraform
o Strong Knowledge of GitHub, Jenkins, and other DevOps tools
o Familiarity with RESTful networking
o Understanding of Software Development Methodologies
o Understanding of security best practices
o Strong problem solving skills
o Strong collaboration skills
o Excellent verbal and written communication skills