*Dear Candidate,* * We have an urgent opening for EPIC / CLARITY ETL Data Stage Developer.and I have sent you a job description ,Please go through it and let me know if you are comfortable with it and also send me your consultant's updated*
*Role: EPIC / CLARITY ETL Data Stage Developer* *Location: Minneapolis, MN* *Duration: 5+ Months* *Overview:* • *Will be working on an integration of two Epic systems into one system. * • *The Epic application uses Cache for the backend, and the data from the Cache data store is being translated into a Clarity based Oracle ODS. * • *The ETL Administrator will be working on developing the ETL programs between Cache and Oracle.* *Required Skills:* • *Mid – Senior level experience working on Epic integration projects. Experience with the following:* • *Epic* *1. **Cache* *2. **Oracle* *3. **Clarity* *4. **ETL - Data Stage* *5. **SAP Business Objects* EXAMPLE RESUME – SEE BELOW *ETL Data Stage Developer * • *A Dynamic IT professional with 7+ years of work experience in Data Analysis, design and development of* • *ETL applications* • *6+ years of strong experience in designing and developing Business Intelligence solutions in Data* • *Warehousing Systems using ETL tools Data Stage PX 7.5/8.x,Informatica,Pentahoand with strong business* • *understanding knowledge of Banking, Insurance, Financial, Healthcare and postal verticals.* • *5+ years of ETL lead experience in leading multiple projects in Finance and healthcare verticals.* • *5+ years of experience with SQL, and Database Stored Procedures using ORACLE (PL/SQL), SQL server* • *and Teradata.* • *Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational* • *Database Management System (RDBMS).* • *Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions,* • *Materialized Views, Query Re-Write and Transportable table spaces.* • *4+ years of experience in UNIX Korn shell and awk scripts, Sun Solaris8, IBM UNIX* • *5+ years in ETL DataStage testing and involved in writing test cases for various complex scenarios.* • *Involved in the data analysis for source and target systems, and good understanding of Data Warehousing* • *concepts, dimensional schema, Star schema and Snow-Flake schema.* • *5+ years in preparing technical specification documents.* • *Expertise in RDBMS concepts, conceptual/logical/physical data.* • *Experience with Performance Tuning for Oracle RDBMS using Explain Plan* • *Working knowledge of ETL design and commercial frameworks that implement the data design patterns.* • *Implemented Performance Tuning techniques at application, database, and system levels* • *Have worked in mainframe applications in banking domain* • *Have knowledge on Epic Clarity database and its data model.* • *Have knowledge on SSIS, SSRS and SSAS.* • *Have Working experience in Designing, developing and testing in Business Objects Reporting Tool.* • *Expertise in developing staging components in Ascential and Infospheredatastage 7.5, 8x and 8.5 and* • *execution of them in UNIX environment by using Control-M Scheduler.* • *2+ years of experience in designing, developing and testing Crystal XCelcius Dashboard Tool and Quality* • *Stage 8.1 Tool.* • *2+ years of experience in Control-M scheduling Tool.* • *1+ years of experience in TWS(Tivoli Integrated Portal) and Pentaho ETL tool.* • *Have work experience on Visual Source Safe and Service Now* • *Deep understanding of developing transactional enterprise data models that strictly meet normalization rules,* • *as well as enterprise data warehouses using Kimball and Inmon data warehouse methodologies.* • *Strong analytical skills with ability to quickly understand client's business needs and create specifications.* • *Excellent team player with strong written, communication, interpersonal, analytical skills, Capable of working* • *under high stress environment with resource constraints.* • *Willing to learn new concepts and accept challenges with positive attitude.* *Rohit Bhasin |* Module lead Recruiter | Apetan Consulting LLC Tel: 201-620-9700* |121| Fax:2015266869 | *Mail *: 72 van reipen ave pmb#255, Jersey City, NJ 07306| *Corp. Office:* 15 Union Avenue, office # 6, Rutherford, New Jersey 07070| [email protected]| www.apetan.com | *“Forget all the reasons why it won’t work and believe the one reason it will work**"* <http://www.facebook.com/Apetanconsulting> <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> <http://twitter.com/ApetanLLC> *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at [email protected] and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "SAP ABAP" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sap-abap. For more options, visit https://groups.google.com/d/optout.
