Hello Associates, Hope you are doing fine Please send me your consultants resume to zain.k...@panzersolutions.com
Job Title: SQL/SSIS - EDM Designer. Duration: 6 month contract Location: Plano, TX. (Need Locals F2F Required) Top 3 Skills: OLTP Modeling Building ETL Processes SQL This role will be responsible for bringing data in from various external sources and how it will look in the internal Data Warehouse. They will set up the ETL backend process. OLTP modeling and ETL are most important skills for this role. If someone has healthcare experience it will be helpful. Job Purpose: The EDM Database Designer/Developer role will be involved in planning, development, and deployment activities related to the design and implementation of an Enterprise ODS, as well as Enterprise Data Quality Solution with associated management and reporting capabilities. The Database designer/developer is expected to provide technical leadership as well as mentor other team members. The designer/developer is also expected to work with Product Managers to define and clarify requirements, provide design estimates, and support production environments. Essential Duties & Responsibilities: Provide technical and architectural leadership in database modeling and configuration. Mentor and develop junior resources within the group. Complete assigned tasks within the agreed project timeline and schedule. Work with the production support group to resolve any service affecting issues that the support group escalates. Internal Responsibilities: Adheres to all company policies and procedures including, but not limited to those identified within the Standards of Business Conduct and the Employee Handbook, as may be amended from time to time. Adheres to all applicable laws and regulations and the company's governance/compliance program. Responsible for reporting violations of the company's policies and procedures, Standards of Business Conduct, governance program, laws and regulations through the company's Help Line or other mechanism that may be available at the time of the violation. Assists with internal control failure remediation efforts. Becomes knowledgeable of internal control responsibilities through training and instruction. Responsible and accountable for internal control performance within their area of responsibility. Participates in the internal controls self-assessment process. Ensures concerns with internal control design or performance and process changes that impact internal control execution are communicated to management. Minimum Qualifications & Competencies: Minimum 5+ years’ experience in Database Design and Development in the following environments: OLTP Data Quality Data Ingest and Exhaust through various mechanisms OLAP Data Warehousing Healthcare Experience Proven written and verbal communication skills Proven documentation skills Demonstrated proficiency in using: SQL Server 2008 R2 SSIS Erwin/ErStudio Proven experience working with large data sets and high transaction volumes Demonstrated ability to work in a team environment that requires quick turnaround and quality output Solid knowledge of all MS Office Products Job/Functional Knowledge Understands duties and responsibilities, has necessary functional and technical knowledge for task completion, keeps job knowledge current, applies knowledge and skills that lead to success in the job. Effectively applies background & experience to current role Demonstrates a comprehensive knowledge of particular field Keeps informed of latest trends, developments, and best and current practices in particular field Problem Solving/Analysis Breaks down problems into smaller components, understands underlying issues, can simplify and process complex issues, understands the difference between critical details and unimportant facts. Uses logic and methods to solve difficult problems with effective solutions Probes all potential sources for answers Looks beyond the obvious to identify hidden problems Searches until appropriate solutions are found and implemented Approaches issues logically and challenges proposed solutions inquisitively Adaptability/Flexibility Adapts to change, is open to new ideas, takes on new responsibilities, handles pressure, adjusts plans to meet changing needs. Demonstrates comfort with uncertainty and takes necessary risk when outcomes are unknown Adapts personal work style to achieve team objectives Drives change by energizing and motivating others Task Management Prioritizes well, manages time effectively, shows energy and a sense of urgency, reacts to opportunities, instills urgency in others, meets deadlines. Accurately scopes out length and difficulty of task and projects Attends to a broad range of activities and completes them efficiently Arranges information and files in a useful manner Demonstrates a strong work ethic with the ability to complete tasks and deliverables under tight deadlines while maintaining flexibility Creativity/Innovation Generate new ideas, challenges the status quo, takes risks, supports change, encourages innovation, solves problems creatively. Easily makes new connections between concepts and ideas Adds a great deal of value in brainstorming settings Applies new solutions to unsolved problems -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To post to this group, send email to oracle-projects@googlegroups.com. To unsubscribe from this group, send email to oracle-projects+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/oracle-projects?hl=en.