*Role : Senior SSIS ETL Consultant with Pharma experience Duration: 12+ Months*
Position Senior SSIS ETL Consultant with Pharma experience *Location* New Jersey, Princeton Minimum Experience / Relevance · Over all 8+ IT Experience · 6-7 years of ETL Architecture experience using ETL and Business Intelligence techniques including 5+ years using SSIS product suite development tools and environments. · Skills (Mandatory) · Good Knowledge / Experience in SSIS · Good expertise in Designing, Developing SSIS Packages and Workflows · Debugging / Trouble shooting of SSIS Jobs · Good in MS SQL Server Database · Good Knowledge in Migration (between versions and other tools) · Strong Data Warehousing Concepts & Architecture · Good Knowledge on Data warehousing Design approach · Experience in Big Data and AWS is a Great Plus · Good Knowledge in ETL Testing Methodologies · Experience in Pharma Domain and it’s data set is a great plus - Good Data Modelling in Commercial Pharma · Strong Experience in life sciences/healthcare and working experience with various Healthcare Sources IMS data, Medpro, Plantrack, IMS Xponent, Fingertip, Formulary,DDD, Call Plan, Speciality exclusion primarily in the areas on Physician Targeting , Segment profiling analytics, Source of business etc is a Great PLUS · Very good Communication and experienced in Development / Support projects · Demonstrated experience leading MSBI product suite, ETL and Business Intelligence products. · Demonstrated understandings of database architecture design patterns, and complete application development lifecycle. · Demonstrated experience ETL and Business Intelligence products. · Customer handling and good communications skills Skills (Optional) OLAP Reporting Tools is a plus Roles & Responsibilities · Define data relationship model to support data migration from source systems to target data warehousing environments. · ETL solutions should follow database normalization standards and best practices. · Design and develop Informatica mapping and transformation rules to support new data warehouse architecture model · Understand Change control Management and drive changes by performing Impact Analysis · Working with dependent teams such as DBA, Admin etc for tasks that require other team’s assistance · Identify, design, and write technical specifications and champion re-usable software and frameworks and common objects using ETL and Business Intelligence technology. · Define database architecture development principles, standards, and best practices. · Preparing test/quality strategies, plans for meeting the CTQs of the project · Research current trends and emerging technologies and provide input on how they may positively or negatively impact the enterprise. · Solutioning and Customer manager skills are necessary Thanks & Regards Mounika recrui...@nityainc.com/nitya.recruit...@gmail.com -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.