Senior Datastage Architect

Role : Senior Datastage Architect Location : Norfolk,VA Looking for a Senior Datastage Architect with 10+ Year of Experience. Skills :

• Datastage Architect

• Looking for Senior Datastage Architect with ability to Perform analysis, design and development.
• Knowledge of relational database design with solid experience in writing complex SQL queries, should have ability to create test data with referential integrity and Unix scripting experience.
• The candidate must possess excellent written and verbal communication skills with the ability and collaborate effectively with domain and technical experts in the team.
• Datastage Developer Participate in analysis Extract, Transform and Load (ETL) Architecture design of large data warehousing system for extract/transform or data conversion from source systems to the target applications - using Datastage.
• Hands on Expert with Datastage core Components & Concept.
• Good Understanding with any Cloud experience will be plus.
• Datastage developer ETL Datastage 11.5/9.5, IBM DB2, Unix. Develop, analyze and maintain all ETL jobs according to client standards.
• Scheduling and monitoring the ETL jobs Build and review functional and business specifications (S2T) Provide the estimates for the ETL work Familiar with Agile methodologies Actively work with Architect, Business Analyst, Data Analyst, Cube and Report Developers Work with DBA's on Database creation and performance tuning Troubleshooting and fixing the code.
• Unit testing the code and documentation of results Work with gate keeper on promoting the data stage jobs to QA and Production.
• Participate in code reviews Strong Healthcare Background Strong in SQL Strong in Unix scripting

• 8 to 10 years of experience in developing/architecting solutions in financial sector with knowledge of warehousing technologies Ability to demonstrate knowledge of project architecture, meta-programming, vectors, parallelism, performance tuning, debugging, and platform integrations Contribute to the technical design documents, use cases, test cases and user manuals for various projects Conduct bug fixing, code reviews, and unit, functional and integration testing Prior Healthcare experience is preferred Excellent analytical and technical skills Team Player who is willing to share ideas and accept feedback

• Datawarehouse
• Data migration
• Architect
• Datastage
• Unix
• Performance tuning
• Database Modelling
• Infrastructure architecture design
• Solid development experience who is hands on ETL, Unix and RDBMS
• NoSQL, Hadoop and cloud will be preferred