Title: DataStage Developer
Location: Hybrid Troy, MI
Duration: 6+ Months
MOI: Phone then Video
Visa: No H1B
Responsibilities and Duties
This role is responsible to create, integrate, implement, and support large, highly complex ETL Data Warehouse.
• Develop and implement tests on all data stage jobs.
• Design and analyze all ETL jobs edition.
• Manage work and apply various performing techniques.
• Document all program level and user level processes.
• Prepare ETL architecture and associate procedures.
• Designs or enhances ETL systems, applications, functions, and procedures to solve complex problems and meet business objectives.
• Prepares detailed ETL functional specification solution development -- has full technical knowledge of all phases of analysis, integration, development, quality assurance, and implementation procedures
• Application/System Troubleshooting interfaces with appropriate corporate area to provide detailed data and analysis to assist with problem determination and resolution.
• Maintain an efficient infrastructure by recognizing and reducing latencies and gaining efficiencies where recognized or needed
JOB REQUIREMENTS
• Bachelor's Degree in a Computer Science or Technology related field -- or -- an equivalent combination of education and experience
• 10 years of quality experience in designing and development of ETL jobs using IBM DataStage.
• Experience in the Data Analysis, Design, Development, Implementation and Testing of Data Warehousing projects.
• Proficiency to understand DW concepts like conformed dimensions, conformed facts and Data Warehouse architecture for ETL development.
• Recent experience with ETL in a cloud environment
• Experience working with Cloud Databases (Snowflake preferred)
• Experience working with Relational Databases, Business Intelligence solutions
• Strong SQL skills, able to write and optimize complex queries
• Experience with multiple Database platforms (DB2, Oracle, Informix, SQL Server, MySQL, Netezza, Snowflake - as many as possible) and Oracle Database is a must
• Experience with Unix shell scripting
• Strong written and verbal communication skills, and effective interpersonal skills to work with internal and external customers and vendors Good analytical/research and problem-solving skills
Thank You!
Udit Dabas| Sr. Technical Recruiter
D: 215-278-8860| E: udit.dabas@firstringsolutions.com
First Ring Solutions LLC | Philadelphia, PA 19102