Hire IT People, LLC Technical Designer Data Movement in chicago, Illinois
Technical Designer Data Movement
Sign up for similar job alert!
Job ID :
2 years ago
Primary Skills: Teradata
Description:JAVA with Data warehouse10 years experience required.Job description:· This position is responsible for the design of data movement into an throughout the TIL, including but not limited to the Operational Data Store, Atomic Data Warehouse, Dimensional Data Warehouse and Master Data Management. Mentoring of designers for detailed design.· Development of technical design guidelines and standards, governance of standards, and review of actualization of implementation across projects. Development of enterprise design view and application to project level.ESSENTIAL FUNCTIONS:· Develop and Maintain Standards, Procedures, Guidelines and Best Practices· Develop and maintain ETL logic in J2EE· Act as an internal consultant, mentoring junior designers· Review all Project Level Data Movement Designs for adherence to Standards and Best Practices· Suggest changes to Project Level Designs * Develop New Data Movement Design Patterns where Required· Guide the Coding and Testing of standard data movement reuseable components.JOB REQUIREMENTS:· Strong Analytical and problem solving skills.· Technical expertise regarding data models and database design development. Understanding of XML and SQL· Identify, analyze, and interpret trends or patterns in complex data sets· Good grasp of data movement approaches and techniques and when to apply them· Good understanding of different changed data capture approached and techniques and when to use which· Ability to present complex information in an understandable and compelling manner· Ability to understand complex Business Processes and their relationships· Able to independently keep up to date with latest trends in technology affecting TIS· Healthcare background with in depth knowledge of at least one payer subject area· Strong hands on skills in DB/2 SQL, DB2 Physical Database Design, DataStage, Unix, CDC Tools and Approaches.· Exposure to Teradata, MQ, Teradata Utilities· Conceptual knowledge of Performance Monitoring Tools, ER/Win, SOA, Enterprise Modeling or IBM HPDM· Java, J2EE Standards, Servlets, EJB, JSP, Java Mail, JNDI and RMI * Service-Oriented Architecture SOAP and Restful services· Creating and consuming Web Services· Well versed with version control tools like SVN, CVS· Building and deploying source code with dependencies using tools like Jenkins Maven, Archiva, ANT· Experienced in Test Driven development methodology using tools like TestNG or JUnit· Experience working with various Web and Application servers such as Apache Tomcat and Web Logic· Understanding of RDBMS conceptsRequired skills:· Healthcare· Strong DB/2 SQL· DataStage; Unix· CDC Tools & Approaches· Teradata